OK, it's translating the empty field into a space like this:
WHERE (T438.C200000005 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:[email protected]] On Behalf Of Chuck
Sent: Tuesday, August 02, 2011 6:22 PM
To: [email protected]
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 <[email protected]> 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"
