Fixes Issue 0022031: Now selectors are working properly but not as before
authorShankar Balachandran <shankar.balachandran@openbravo.com>
Wed, 24 Oct 2012 11:11:00 +0200
changeset 18270 90820fdcd175
parent 18269 ec10f528e45f
child 18271 0a2bdc2397de
Fixes Issue 0022031: Now selectors are working properly but not as before

The way selectors were working was modified to work properly in this issue https://issues.openbravo.com/view.php?id=21470.Prior to this change, even though 'startsWith' was set, the suggestion box always worked with the 'Contains' filter. Because of the change the behaviour was different from the existing behaviour of the selector, so modified the suggestion text match style from 'startsWith' to 'Contains' so that the existing behaviour will be restored.
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Tue Oct 23 15:14:04 2012 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Wed Oct 24 11:11:00 2012 +0200
@@ -33,7 +33,7 @@
 <!--9FAD469CE4414A25974CF45C0AD22D35-->  <FILTER_EXPRESSION><![CDATA[OB.getFilterExpression("org.openbravo.advpaymentmngt.ad_actionbutton.GLItemSelectorFilterExpression")]]></FILTER_EXPRESSION>
 <!--9FAD469CE4414A25974CF45C0AD22D35-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--9FAD469CE4414A25974CF45C0AD22D35-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--9FAD469CE4414A25974CF45C0AD22D35-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--9FAD469CE4414A25974CF45C0AD22D35-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--9FAD469CE4414A25974CF45C0AD22D35-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--9FAD469CE4414A25974CF45C0AD22D35-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--9FAD469CE4414A25974CF45C0AD22D35--></OBUISEL_SELECTOR>
@@ -49,7 +49,7 @@
 <!--A98899B1C75A4F4EBD3414F1B654EFAB-->  <FILTER_EXPRESSION><![CDATA["e.active=true"]]></FILTER_EXPRESSION>
 <!--A98899B1C75A4F4EBD3414F1B654EFAB-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--A98899B1C75A4F4EBD3414F1B654EFAB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--A98899B1C75A4F4EBD3414F1B654EFAB-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--A98899B1C75A4F4EBD3414F1B654EFAB-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--A98899B1C75A4F4EBD3414F1B654EFAB-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--A98899B1C75A4F4EBD3414F1B654EFAB-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--A98899B1C75A4F4EBD3414F1B654EFAB--></OBUISEL_SELECTOR>
@@ -65,7 +65,7 @@
 <!--FF808181312D569C01312D8C1EC40036-->  <AD_COLUMN_ID><![CDATA[3457]]></AD_COLUMN_ID>
 <!--FF808181312D569C01312D8C1EC40036-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--FF808181312D569C01312D8C1EC40036-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF808181312D569C01312D8C1EC40036-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--FF808181312D569C01312D8C1EC40036-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D8C1EC40036-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D8C1EC40036-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--FF808181312D569C01312D8C1EC40036--></OBUISEL_SELECTOR>
@@ -81,7 +81,7 @@
 <!--FF808181312D569C01312D8DCCD50045-->  <AD_COLUMN_ID><![CDATA[2570]]></AD_COLUMN_ID>
 <!--FF808181312D569C01312D8DCCD50045-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--FF808181312D569C01312D8DCCD50045-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF808181312D569C01312D8DCCD50045-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--FF808181312D569C01312D8DCCD50045-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D8DCCD50045-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D8DCCD50045-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--FF808181312D569C01312D8DCCD50045--></OBUISEL_SELECTOR>
@@ -97,7 +97,7 @@
 <!--FF808181312D569C01312D8EE5430054-->  <AD_COLUMN_ID><![CDATA[1823]]></AD_COLUMN_ID>
 <!--FF808181312D569C01312D8EE5430054-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--FF808181312D569C01312D8EE5430054-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF808181312D569C01312D8EE5430054-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--FF808181312D569C01312D8EE5430054-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D8EE5430054-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D8EE5430054-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--FF808181312D569C01312D8EE5430054--></OBUISEL_SELECTOR>
@@ -113,7 +113,7 @@
 <!--FF808181312D569C01312D90408D005D-->  <AD_COLUMN_ID><![CDATA[1349]]></AD_COLUMN_ID>
 <!--FF808181312D569C01312D90408D005D-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--FF808181312D569C01312D90408D005D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF808181312D569C01312D90408D005D-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--FF808181312D569C01312D90408D005D-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D90408D005D-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--FF808181312D569C01312D90408D005D-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--FF808181312D569C01312D90408D005D--></OBUISEL_SELECTOR>
@@ -131,7 +131,7 @@
 <!--FF808181312DA8D801312DDE869B000C-->  <FILTER_EXPRESSION><![CDATA[OB.getFilterExpression("org.openbravo.erpCommon.info.RMProductSelectorFilterExpression")]]></FILTER_EXPRESSION>
 <!--FF808181312DA8D801312DDE869B000C-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--FF808181312DA8D801312DDE869B000C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF808181312DA8D801312DDE869B000C-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--FF808181312DA8D801312DDE869B000C-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--FF808181312DA8D801312DDE869B000C-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--FF808181312DA8D801312DDE869B000C-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--FF808181312DA8D801312DDE869B000C--></OBUISEL_SELECTOR>
--- a/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Tue Oct 23 15:14:04 2012 +0200
+++ b/modules/org.openbravo.userinterface.selector/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Wed Oct 24 11:11:00 2012 +0200
@@ -13,7 +13,7 @@
 <!--387D9FFC48A74054835C5DF6E6FD08F7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--387D9FFC48A74054835C5DF6E6FD08F7-->  <VALUEFIELD_ID><![CDATA[DD28F69792084E7F8EBBF2FA94F52A5F]]></VALUEFIELD_ID>
 <!--387D9FFC48A74054835C5DF6E6FD08F7-->  <DISPLAYFIELD_ID><![CDATA[DD28F69792084E7F8EBBF2FA94F52A5F]]></DISPLAYFIELD_ID>
-<!--387D9FFC48A74054835C5DF6E6FD08F7-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--387D9FFC48A74054835C5DF6E6FD08F7-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--387D9FFC48A74054835C5DF6E6FD08F7-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--387D9FFC48A74054835C5DF6E6FD08F7-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--387D9FFC48A74054835C5DF6E6FD08F7--></OBUISEL_SELECTOR>
@@ -29,7 +29,7 @@
 <!--E4F389D409DF4EC3B371B69C8A124DA7-->  <OBSERDS_DATASOURCE_ID><![CDATA[5C8B84FA41CE4876B26B9E96A9E909BD]]></OBSERDS_DATASOURCE_ID>
 <!--E4F389D409DF4EC3B371B69C8A124DA7-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--E4F389D409DF4EC3B371B69C8A124DA7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--E4F389D409DF4EC3B371B69C8A124DA7-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--E4F389D409DF4EC3B371B69C8A124DA7-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--E4F389D409DF4EC3B371B69C8A124DA7-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--E4F389D409DF4EC3B371B69C8A124DA7-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--E4F389D409DF4EC3B371B69C8A124DA7--></OBUISEL_SELECTOR>
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Tue Oct 23 15:14:04 2012 +0200
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml	Wed Oct 24 11:11:00 2012 +0200
@@ -13,7 +13,7 @@
 <!--2E64F551C7C4470C80C29DBA24B34A5F-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--2E64F551C7C4470C80C29DBA24B34A5F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--2E64F551C7C4470C80C29DBA24B34A5F-->  <VALUEFIELD_ID><![CDATA[2CB91FE062B541ACB00D82AC69858446]]></VALUEFIELD_ID>
-<!--2E64F551C7C4470C80C29DBA24B34A5F-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--2E64F551C7C4470C80C29DBA24B34A5F-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--2E64F551C7C4470C80C29DBA24B34A5F-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--2E64F551C7C4470C80C29DBA24B34A5F-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--2E64F551C7C4470C80C29DBA24B34A5F--></OBUISEL_SELECTOR>
@@ -30,7 +30,7 @@
 <!--4028E61131FB4B1B0131FB5307F1000C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--4028E61131FB4B1B0131FB5307F1000C-->  <VALUEFIELD_ID><![CDATA[4028E61131FB4B1B0131FB5711430042]]></VALUEFIELD_ID>
 <!--4028E61131FB4B1B0131FB5307F1000C-->  <DISPLAYFIELD_ID><![CDATA[4028E61131FB4B1B0131FB5625760036]]></DISPLAYFIELD_ID>
-<!--4028E61131FB4B1B0131FB5307F1000C-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--4028E61131FB4B1B0131FB5307F1000C-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--4028E61131FB4B1B0131FB5307F1000C-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--4028E61131FB4B1B0131FB5307F1000C-->  <HQL><![CDATA[SELECT distinct bp.name as name,bp.id as bpid, bp.searchKey as value,
    bp.creditLimit - bp.creditUsed as creditAvailable, bp.creditUsed as creditUsed,
@@ -61,7 +61,7 @@
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <VALUEFIELD_ID><![CDATA[D5CD42F686A14DFA949052B99900D679]]></VALUEFIELD_ID>
-<!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--4C8BC3E8E56441F4B8C98C684A0C9212--></OBUISEL_SELECTOR>
@@ -80,7 +80,7 @@
 <!--7809A075DD5C40A598FA80D7BEE70BCE-->  <WHERECLAUSE><![CDATA[e.active = true and e.warehouse.id=@inpmWarehouseId@]]></WHERECLAUSE>
 <!--7809A075DD5C40A598FA80D7BEE70BCE-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--7809A075DD5C40A598FA80D7BEE70BCE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--7809A075DD5C40A598FA80D7BEE70BCE-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--7809A075DD5C40A598FA80D7BEE70BCE-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--7809A075DD5C40A598FA80D7BEE70BCE-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--7809A075DD5C40A598FA80D7BEE70BCE-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--7809A075DD5C40A598FA80D7BEE70BCE--></OBUISEL_SELECTOR>
@@ -97,7 +97,7 @@
 <!--862F54CB1B074513BD791C6789F4AA42-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--862F54CB1B074513BD791C6789F4AA42-->  <VALUEFIELD_ID><![CDATA[B103893820FC4080809A97FABD49D8AF]]></VALUEFIELD_ID>
 <!--862F54CB1B074513BD791C6789F4AA42-->  <DISPLAYFIELD_ID><![CDATA[9835921A3AA54B8D8D0126B3696F8354]]></DISPLAYFIELD_ID>
-<!--862F54CB1B074513BD791C6789F4AA42-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--862F54CB1B074513BD791C6789F4AA42-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--862F54CB1B074513BD791C6789F4AA42-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--862F54CB1B074513BD791C6789F4AA42-->  <HQL><![CDATA[SELECT bp.name as name,bp.id as bpid, bp.searchKey as value,
    bp.creditLimit - bp.creditUsed as creditAvailable, bp.creditUsed as creditUsed,
@@ -138,7 +138,7 @@
 <!--A35B6EC33A2243018915908AEB1B3F5E-->  <WHERECLAUSE><![CDATA[e.summaryLevel='N']]></WHERECLAUSE>
 <!--A35B6EC33A2243018915908AEB1B3F5E-->  <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
 <!--A35B6EC33A2243018915908AEB1B3F5E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--A35B6EC33A2243018915908AEB1B3F5E-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--A35B6EC33A2243018915908AEB1B3F5E-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--A35B6EC33A2243018915908AEB1B3F5E-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--A35B6EC33A2243018915908AEB1B3F5E-->  <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
 <!--A35B6EC33A2243018915908AEB1B3F5E--></OBUISEL_SELECTOR>
@@ -156,7 +156,7 @@
 <!--EB3C41F0973A4EDA91E475833792A6D4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--EB3C41F0973A4EDA91E475833792A6D4-->  <VALUEFIELD_ID><![CDATA[EDADAD64A1634FDEA50343CE1AAAF1FB]]></VALUEFIELD_ID>
 <!--EB3C41F0973A4EDA91E475833792A6D4-->  <DISPLAYFIELD_ID><![CDATA[797E2E6C7A6D4A349491B85A1C1ACB7D]]></DISPLAYFIELD_ID>
-<!--EB3C41F0973A4EDA91E475833792A6D4-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--EB3C41F0973A4EDA91E475833792A6D4-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--EB3C41F0973A4EDA91E475833792A6D4-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--EB3C41F0973A4EDA91E475833792A6D4-->  <HQL><![CDATA[select p.searchKey as searchKey, p.id as id, plv as priceListVersion, plv.name as priceListVersionName, c.id as currency, pp.priceLimit as priceLimit, p.name as productName,p.uOM as uOM, pp.standardPrice as standardPrice, pp.listPrice as netListPrice, pl.salesPriceList as salesPriceList
 from PricingProductPrice pp
@@ -181,7 +181,7 @@
 <!--F132874BE0954A9B8C1301BE20704730-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--F132874BE0954A9B8C1301BE20704730-->  <VALUEFIELD_ID><![CDATA[38075EEC36C24E3CAB44D1B33D2CE637]]></VALUEFIELD_ID>
 <!--F132874BE0954A9B8C1301BE20704730-->  <DISPLAYFIELD_ID><![CDATA[7CA7330BA4864D2FB1FED44CDB88A622]]></DISPLAYFIELD_ID>
-<!--F132874BE0954A9B8C1301BE20704730-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[startsWith]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--F132874BE0954A9B8C1301BE20704730-->  <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
 <!--F132874BE0954A9B8C1301BE20704730-->  <POPUPTEXTMATCHSTYLE><![CDATA[startsWith]]></POPUPTEXTMATCHSTYLE>
 <!--F132874BE0954A9B8C1301BE20704730-->  <HQL><![CDATA[SELECT distinct bp.name as name,bp.id as bpid, bp.searchKey as value,
    bp.creditLimit - bp.creditUsed as creditAvailable, bp.creditUsed as creditUsed,