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 at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
