I have a data table with filters to filter the displayed data.
And then there's the extended search settings and filter type
The filter used is the search filter. Set to lookup dropdown
The information in the search drop-down box is all information. That is not filtered only by the data that the table shows.
How to display search data only that the table is set to display?
<Table TblName="inbound_item_set_serial" TblType="LINKTABLE" TblGen="1" TblGenList="controller=1,info=1,entity=1,list=1,list|class=1,edit=1,edit|class=1" TblList="1" TblMultiEdit="1" TblModalMultiEdit="1" TblEdit="1" TblEditConfirm="1" TblCaption="inbound item set serial" TblUpdatable="1" TblSrchType="BASIC" TblBasicSearch="0" TblExtendedBasicSearch="0" TblFilter=""`InboundItemStatus` in (39,40)"" TblSecurity="0,"Default",0" TblLoaded="1" TblShowEmptyRows="0" TblUseGlobal="1" TblRecPerPage="20" TblRecPerPageList="10,20,50,ALL" TblGrpPerPage="3" TblGrpPerPageList="1,2,3,5,ALL" TblPagerStyle="2" TblModalEdit="1" TblAuditTrail="1" TblDisplayRowCount="1" TblUseButtonsForLinks="1" TblUseDropDownForAction="1" TblUseDropDownForListOptions="1" TblUseDropDownForExport="1" LinkDBID="stock1" LinkTableName="inbound_item" LinkTableType="TABLE">
<Field FldName="InboundItemID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldUniqueIdx="1" FldReq="1" FldIsPrimaryKey="1" FldAttribute="4" FldValidate="INTEGER" FldGenerate="1" FldExport="1" FldAddOpt="1" FldSrchOpr="=" FldCaption="Inbound Item ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagMaxLength="26" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="InboundID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="=" FldCaption="Inbound ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldSelectType="Table" FldTagLnkTbl="inbound" FldTagLnkFld="InboundID" FldTagLnkDisplay="InboundCode" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" FldFilter="1" />
<Field FldName="ProductID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="=" FldCaption="Product ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldSelectType="Table" FldTagLnkTbl="product" FldTagLnkFld="ProductID" FldTagLnkDisplay="ProductCode" FldTagLnkDisp2="ProductName" FldTagLnkDisp3="ProductPart" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldColumnWidth="200" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" FldFilter="1" />
<Field FldName="ProductBrandID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Brand ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldSelectType="Table" FldTagLnkTbl="product_brand" FldTagLnkFld="ProductBrandID" FldTagLnkDisplay="ProductBrandName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="ProductCategoryID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Category ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldSelectType="Table" FldTagLnkTbl="product_category" FldTagLnkFld="ProductCategoryID" FldTagLnkDisplay="ProductCategoryName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="ProductTypeID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Type ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldSelectType="Table" FldTagLnkTbl="product_type" FldTagLnkFld="ProductTypeID" FldTagLnkDisplay="ProductTypeName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="ProductModelID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Model ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldSelectType="Table" FldTagLnkTbl="product_model" FldTagLnkFld="ProductModelID" FldTagLnkDisplay="ProductModelName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="InboundItemSerialNumber" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="50" FldAttribute="36" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Inbound Item Serial Number" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="50" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldColumnWidth="200" FldMultiUpdate="1" FldResizeQuality="75" />
<Field FldName="InboundItemLotNumber" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="50" FldReq="1" FldAttribute="4" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Inbound Item Lot Number" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="50" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldColumnWidth="200" FldMultiUpdate="1" FldResizeQuality="75" />
<Field FldName="InboundItemStatus" FldType="21" FldTypeName="bigint" NativeDataType="508" FldSupport="1" FldSize="20" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Inbound Item Status" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="0" FldSelectType="Table" FldTagLnkTbl="status" FldTagLnkFld="StatusID" FldTagLnkDisplay="StatusNameTH" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="InboundItemOwner" FldType="200" FldTypeName="enum" NativeDataType="247" FldSupport="1" FldSize="3" FldReq="1" FldAttribute="4" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Inbound Item Owner" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="3" FldTagValues=""COM","COM"|"CUS","CUS"|" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldMultiUpdate="1" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="InboundItemRemarks" FldType="201" FldTypeName="longtext" NativeDataType="751" FldSupport="1" FldSize="2147483647" FldAttribute="36" FldGenerate="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Inbound Item Remarks" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXTAREA" FldTagMaxLength="0" FldSelectType="Values" FldTagCols="35" FldTagRows="4" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldMultiUpdate="1" FldResizeQuality="75" />
</Table>
<Table TblName="test_item_new" TblType="LINKTABLE" TblGen="1" TblGenList="controller=1,info=1,entity=1,list=1,list|class=1,grid=1,grid|class=1,view=1,view|class=1,edit=1,edit|class=1" TblList="1" TblView="1" TblEdit="1" TblEditConfirm="1" TblIsDetail="1" TblCaption="test item new" TblUpdatable="1" TblSrchType="BASIC" TblBasicSearch="0" TblExtendedBasicSearch="0" TblFilter=""`StockStatus` in (1,2)"" TblSecurity="0,"Default",0" TblLoaded="1" TblShowEmptyRows="0" TblUseGlobal="1" TblRecPerPage="20" TblRecPerPageList="10,20,50,ALL" TblGrpPerPage="3" TblGrpPerPageList="1,2,3,5,ALL" TblPrinterFriendly="1" TblExportHtml="1" TblExportWord="1" TblExportExcel="1" TblExportXml="1" TblExportCsv="1" TblExportEmail="1" TblExportPDF="1" TblExportType="ALL" TblSortType="2" TblPagerStyle="2" TblTopPageLink="1" TblBottomPageLink="0" TblViewExport="1" TblLinkOnLeft="1" TblModalEdit="1" TblModalView="1" TblAuditTrail="1" TblDetailShowCount="1" TblDetailView="1" TblShowMultipleDetails="1" TblDisplayRowCount="1" TblUseButtonsForLinks="1" TblMultiPageType="Tabs" TblUseDropDownForExport="1" LinkDBID="stock1" LinkTableName="test_item" LinkTableType="TABLE" TblPageCaptions=""Page 1"|"Page 2"">
<Field FldName="TestItemID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldUniqueIdx="1" FldReq="1" FldIsPrimaryKey="1" FldAttribute="4" FldValidate="INTEGER" FldGenerate="1" FldExport="1" FldAddOpt="1" FldSrchOpr="=" FldCaption="Test Item ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagMaxLength="26" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="TestID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Test ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="test" FldTagLnkFld="TestID" FldTagLnkDisplay="TestCode" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="StockID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Stock ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="stock" FldTagLnkFld="StockID" FldTagLnkDisplay="StockSerialNumber" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldSelectFilter="(CurrentPageID() == "add") ? "`StockStatus` in (1,2)" : """ FldAutoFillSourceFields="ProductID||ProductBrandID||ProductCategoryID||ProductTypeID||ProductModelID||StockStatus||StockOwner||StockSerialNumber||StockLotNumber||StockUSBID||StockGSMID||StockIMEI||StockMACAddress" FldAutoFillTargetFields="ProductID||ProductBrandID||ProductCategoryID||ProductTypeID||ProductModelID||StockStatus||StockOwner||StockSerialNumber||StockLotNumber||StockUSBID||StockGSMID||StockIMEI||StockMACAddress" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" FldAutoFill="1" FldModalLookup="1" />
<Field FldName="ProductID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="product" FldTagLnkFld="ProductID" FldTagLnkDisplay="ProductCode" FldTagLnkDisp2="ProductName" FldTagLnkDisp3="ProductPart" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="ProductBrandID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Brand ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="product_brand" FldTagLnkFld="ProductBrandID" FldTagLnkDisplay="ProductBrandName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="ProductCategoryID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Category ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="product_category" FldTagLnkFld="ProductCategoryID" FldTagLnkDisplay="ProductCategoryName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="ProductTypeID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Type ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="product_type" FldTagLnkFld="ProductTypeID" FldTagLnkDisplay="ProductTypeName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="ProductModelID" FldType="129" FldTypeName="char" NativeDataType="254" FldSupport="1" FldSize="26" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Product Model ID" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="product_model" FldTagLnkFld="ProductModelID" FldTagLnkDisplay="ProductModelName" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="StockStatus" FldType="21" FldTypeName="bigint" NativeDataType="508" FldSupport="1" FldSize="20" FldReq="1" FldAttribute="4" FldValidate="INTEGER" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Stock Status" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="0" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="status" FldTagLnkFld="StatusID" FldTagLnkDisplay="StatusNameTH" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="StockOwner" FldType="200" FldTypeName="enum" NativeDataType="247" FldSupport="1" FldSize="3" FldReq="1" FldAttribute="4" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Stock Owner" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="3" FldTagValues=""COM","COM"|"CUS","CUS"|" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="StockSerialNumber" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="50" FldReq="1" FldAttribute="4" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Stock Serial Number" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="50" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="StockLotNumber" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="50" FldReq="1" FldAttribute="4" FldRequired="1" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Stock Lot Number" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="50" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="StockUSBID" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="255" FldAttribute="36" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Stock USBID" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="255" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="StockGSMID" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="255" FldAttribute="36" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Stock GSMID" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="255" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="StockIMEI" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="255" FldAttribute="36" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Stock IMEI" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="255" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="StockMACAddress" FldType="200" FldTypeName="varchar" NativeDataType="253" FldSupport="1" FldSize="255" FldAttribute="36" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Stock MACAddress" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXT" FldTagSize="30" FldTagMaxLength="255" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="TestItemFile" FldType="201" FldTypeName="longtext" NativeDataType="751" FldSupport="1" FldSize="2147483647" FldAttribute="36" FldRequired="1" FldGenerate="1" FldList="1" FldView="1" FldEdit="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Test Item File" FldViewTag="FORMATTED TEXT" FldHtmlTag="FILE" FldTagMaxLength="0" FldSelectType="Values" FldTagCols="35" FldTagRows="4" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FileNameFld="TestItemFile" FldQuoteS="'" FldQuoteE="'" FldUploadPath=""files/Test/TestItemFile/"" FldResizeQuality="75" FldViewTemplate="{"id":"custom","name":"Custom"}" />
<Field FldName="TestItemResult" FldType="200" FldTypeName="enum" NativeDataType="247" FldSupport="1" FldSize="4" FldAttribute="36" FldGenerate="1" FldList="1" FldExport="1" FldView="1" FldEdit="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldDefault=""NONE"" FldDbDefault="NONE" FldCaption="Test Item Result" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="4" FldTagValues=""NONE","NONE"|"Y","Y"|"N","N"|" FldHtmlTagReadOnly="1" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" FldViewTemplate="{"id":"custom","name":"Custom"}" />
<Field FldName="TestItemSymptom" FldType="201" FldTypeName="longtext" NativeDataType="751" FldSupport="1" FldSize="2147483647" FldAttribute="36" FldGenerate="1" FldView="1" FldEdit="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Test Item Symptom" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagMaxLength="0" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="problem_symptom" FldTagLnkFld="ProblemSymptomID" FldTagLnkDisplay="ProblemSymptomNameTH" FldTagCols="35" FldTagRows="4" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldSelectMultiple="1" FldSelectAllowAdd="1" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="TestItemCause" FldType="201" FldTypeName="longtext" NativeDataType="751" FldSupport="1" FldSize="2147483647" FldAttribute="36" FldValidate="INTEGER" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Test Item Cause" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="26" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="problem_cause" FldTagLnkFld="ProblemCauseID" FldTagLnkDisplay="ProblemCauseNameTH" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldSelectMultiple="1" FldSelectAllowAdd="1" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="TestItemTested" FldType="200" FldTypeName="enum" NativeDataType="247" FldSupport="1" FldSize="1" FldAttribute="36" FldGenerate="1" FldExport="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldDefault=""N"" FldDbDefault="N" FldCaption="Test Item Tested" FldViewTag="FORMATTED TEXT" FldHtmlTag="CHECKBOX" FldTagSize="30" FldTagMaxLength="1" FldTagValues=""Y","Y"|"N","N"|" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="TestItemStatus" FldType="21" FldTypeName="bigint" NativeDataType="508" FldSupport="1" FldSize="20" FldAttribute="36" FldValidate="INTEGER" FldGenerate="1" FldExport="1" FldView="1" FldEdit="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldCaption="Test Item Status" FldViewTag="FORMATTED TEXT" FldHtmlTag="SELECT" FldTagSize="30" FldTagMaxLength="0" FldHtmlTagReadOnly="1" FldSelectType="Table" FldTagLnkTbl="status" FldTagLnkFld="StatusID" FldTagLnkDisplay="StatusNameTH" FldTagAPrefix="None" FldFmtType="Number" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldEditCustomAttributes="'readonly'" FldResizeQuality="75" />
<Field FldName="TestItemApproved" FldType="200" FldTypeName="enum" NativeDataType="247" FldSupport="1" FldSize="1" FldAttribute="36" FldGenerate="1" FldExport="1" FldAddOpt="1" FldSearch="1" FldSrchOpr="=" FldDefault=""N"" FldDbDefault="N" FldCaption="Test Item Approved" FldViewTag="FORMATTED TEXT" FldHtmlTag="CHECKBOX" FldTagSize="30" FldTagMaxLength="1" FldTagValues=""Y","Y"|"N","N"|" FldSelectType="Values" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
<Field FldName="TestItemRemarks" FldType="201" FldTypeName="longtext" NativeDataType="751" FldSupport="1" FldSize="2147483647" FldAttribute="36" FldGenerate="1" FldView="1" FldEdit="1" FldAdd="1" FldAddOpt="1" FldSearch="1" FldBasicSearch="1" FldSrchOpr="LIKE" FldCaption="Test Item Remarks" FldViewTag="FORMATTED TEXT" FldHtmlTag="TEXTAREA" FldTagMaxLength="0" FldSelectType="Values" FldTagCols="35" FldTagRows="4" FldTagAPrefix="None" FldIncLeadDigit="-2" FldUseParen="-2" FldGpDigits="-2" FldQuoteS="'" FldQuoteE="'" FldResizeQuality="75" />
</Table>