Enable DB Logging and see what the server is sending the database... On Aug 2, 4:39 pm, Lyle Taylor <tayl...@ldschurch.org> wrote: > Hi All, > > I have a table field that pulls in the Product Categorization Tier 1-3 fields > from PCT:Product Catalog and am seeing weird behavior based on the > qualification. I have search qualification fields on the form to help the > user narrow down the list of tiers being shown in the table. My > Qualification for the table has elements that look something like this: > > 'Product Categorization Tier 1' LIKE (("%" + $Tier 1 Search$) + "%") > > I just add AND clauses to that for the other two tiers. What I'm seeing, > though, is that I get different behavior for each of the fields. For > example, with just that above, and the Tier 1 Search field empty, I get all > records displayed in the table. However, if I change the field referenced on > the PCT:Product Catalog table to Product Categorization Tier 2 and still with > the Search field empty, I get back 145 rows. If I change it to Tier 3, I get > back 457 rows. In all cases, that should effectively be translating to the > following: > > 'Product Categorization Tier X' LIKE "%%" > > But it's not behaving that way. Using that statement above, I get all rows, > but as soon as I add the field reference to the Search field, I get less > results for Tier 2 and Tier 3, even though the Search field is empty. > > Has anybody ever seen behavior similar to that? Any ideas how to fix it? > > AR Server 7.1 > ITSM Suite 7.0.03 > > Thanks, > Lyle Taylor > > NOTICE: This email message is for the sole use of the intended recipient(s) > and may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply email and destroy all > copies of the original message. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug11www.wwrug.comARSList: "Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"