Build query range on Multiple Tables

str qvalue;

qvalue = strFmt(‘((%1 like “%5”) || (%2 like “%5”) || (%3 like “%5”) || (%4 like “%5”) || (%6 like “%5”) || (%7 like “%5”) || (%8 like “%5”))’,
fieldStr(ProductsAndVariants, ItemId),
fieldStr(ProductsAndVariants, ItemName),
fieldStr(ProductsAndVariants, VariantDescription),
fieldStr(ProductsAndVariants, ItemSearchName),
_searchText,
fieldStr(CustVendExternalItem, ExternalItemId ),
fieldStr(CustVendExternalItem, ExternalItemTxt),
fieldStr(InventItemBarcode, itemBarCode));

 

qbs = query.addDataSource(tableNum(ProductAndVariantSearch));
qbr = qbs.addRange(fieldNum(ProductAndVariantSearch, DataAreaId));
qbr.value(qvalue);

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s