Unusual Table Field Qualification Results
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
Re: Unusual Table Field Qualification Results
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
Re: Unusual Table Field Qualification Results
OK, it's translating the empty field into a space like this:
WHERE (T438.C20005 LIKE (('%' || ' ') || '%'))
This was causing it to only return entries that had a space in that field's
value. This explains why I see so many qualifications like this:
(($Tier 1 Search$ = ) OR ('Product Categorization Tier 1' LIKE (% + $Tier
1 Search$ + %)))
For some reason, I wasn't getting this to work for me before. I must have been
structuring the qualification wrong somehow. The qualification above works for
me on all columns.
Thanks!
Lyle
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Chuck
Sent: Tuesday, August 02, 2011 6:22 PM
To: arslist@ARSLIST.ORG
Subject: Re: Unusual Table Field Qualification Results
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
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
