Page Comparison

...

To create a new search page, you need to create a single XML file and place it under: ../pages/search/<module_name>/ directory.

An SQL determines the information that will be retrieved and specified fields will be able to be displayed and/or searched for.

In this case, we create a directory named

In the following example loadservices.xml is created under ../pages/search/inventory and then we create a new XML file named loadwarehouses.xmlproducts

Code Block

theme	Eclipse
language	xml
title	loadwarehousesloadschemes.xml
collapse	true

<dataset<?xml version="1.0" encoding="UTF-8"?><dataset xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../xsd/search.xsd">
	<searchcaption>Search Warehouses<<searchcaption>key_search_services</searchcaption>
	<sqltype>SELECT<<sqltype>Select</sqltype>
	<entitytable>PRODUCTS</entitytable>
	<entityfield>PRODID</entityfield>
	<tables>
		<table><tablename>WAREHOUSE<<table><tablename>PRODUCTS</tablename></table>
		<table><tablename>PRODUCTTYPES</tablename></table>
		<table><tablename>PRODUCTBRANDS</tablename></table>
		<table><tablename>PRODUCTFAMILIES</tablename></table>
	</tables>
	<joins>
		<join>
			<indexorder>1</indexorder>
			<outertable>PRODUCTS</outertable>
			<innertable>PRODUCTTYPES</innertable>
			<jointype>RIGHT</jointype>
			<conditions>
				<conditionitem>
					<outerfield>PRODTYPEID</outerfield>
					<condition>=</condition>
					<innerfield>PRODTYPEID</innerfield>
	<joins/>
					<andor>AND</andor>
				</conditionitem>
			</conditions>
		</join>
		<join>
			<indexorder>2</indexorder>
			<outertable>PRODUCTS</outertable>
			<innertable>PRODUCTBRANDS</innertable>
			<jointype>LEFT</jointype>
			<conditions>
				<conditionitem>
					<outerfield>PRODBRANDID</outerfield>
					<condition>=</condition>
					<innerfield>PRODBRANDID</innerfield>
					<andor>AND</andor>
				</conditionitem>
			</conditions>
		</join>
		<join>
			<indexorder>3</indexorder>
			<outertable>PRODUCTS</outertable>
			<innertable>PRODUCTFAMILIES</innertable>
			<jointype>LEFT</jointype>
			<conditions>
				<conditionitem>
					<outerfield>PRODFAMILYID</outerfield>
					<condition>=</condition>
					<innerfield>PRODFAMILYID</innerfield>
					<andor>AND</andor>
				</conditionitem>
			</conditions>
		</join>
	</joins>
	<fields>
		<fielditem>
			<field>WAREHOUSE<field>PRODUCTS.WRHID<PRODID</field>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>32</fieldlen>
			<searchcriteria>0</searchcriteria>
			<visible>0</visible>
			<executable>1</executable>
			<indexorder>1<<indexorder>10</indexorder>
		</fielditem>
		<fielditem>
			<field>PRODUCTS.PRODCODE</field>
			<label>key_product_code</label>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>32</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>1</visible>
			<executable>1</executable>
			<indexorder>20</indexorder>
		</fielditem>
		<fielditem>
			<field>WAREHOUSE.WRHNAME<<field>PRODUCTS.PRODTYPEID</field>
			<label>key_product_type</label>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>32</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>0</visible>
			<executable>1</executable>
			<lookup>dataset;products.loadtypes;prodtypeid;prodtypename</lookup>
			<indexorder>30</indexorder>
		</fielditem>
		<fielditem>
			<field>PRODUCTS.PRODFAMILYID</field>
			<label>Name<<label>key_product_family</label>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>100<<fieldlen>32</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>1<<visible>0</visible>
			<executable>1</executable>
			<indexorder>2<<lookup>dataset;products.loadfamilies;prodfamilyid;prodfamilyname</lookup>
			<indexorder>40</indexorder>
		</fielditem>
 		<fielditem>
			<field>PRODUCTS.PRODBRANDID</field>
			<label>key_product_brand</label>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>32</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>0</visible>
			<executable>1</executable>
			<lookup>dataset;products.loadbrands;prodbrandid;prodbrandname</lookup>
			<indexorder>50</indexorder>
		</fielditem>
		<fielditem>
			<field>PRODUCTS.PRODALTCODE</field>
			<label>key_alternative_code</label>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>32</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>1</visible>
			<executable>1</executable>
			<indexorder>60</indexorder>
		</fielditem>
		<fielditem>
			<field>PRODUCTS.
 PRODDESC</field>
			<label>key_description</label>
			<expression>VALUE</expression>
			<datatype>ftXString</datatype>
			<fieldlen>255</fieldlen>
			<searchcriteria>1</searchcriteria>
			<visible>1</visible>
			<executable>1</executable>
			<indexorder>70</indexorder>
		</fielditem>
	</fields>

	<wheregroups>
		<wheregroup>
			<wherefields>
				<wherefield>
					<field>PRODUCTS.PRODDELETED</field>
					<alias>Expr001</alias>
					<expression>VALUE</expression>
				</wherefield>
				<wherefield>
					<field>0</field>
					<alias>Expr001</alias>
					<expression>VALUE</expression>
				</wherefield>
			</wherefields>
			<wheremembers>
				<wheremember>
					<lparenth>0</lparenth>
					<lfield>WAREHOUSE<lfield>PRODUCTS.WRHDELETED<PRODDELETED</lfield>
					<expression>=</expression>
					<rfield>0</rfield>
					<rparenth>0</rparenth>
					<andor>AND</andor>
				</wheremember>
				<wheremember>
					<lparenth>0</lparenth>
					<lfield>PRODUCTTYPES.PRODTYPECLASSIFICATION</lfield>
					<expression>=</expression>
					<rfield>'SERVICES'</rfield>
					<rparenth>0</rparenth>
					<andor>AND</andor>
				</wheremember>
			</wheremembers>
		</wheregroup>
	</wheregroups>

	<groupby/>

	<orderby/>

</dataset>

Expand

title	Search Services Page

Image Added

...

For a full list of search page attributes, go to Search Pages Documentation

...

Versions Compared

Old Version 16

New Version 17

Key