Advanced Condition question

[txwylde]

I have a query that I want to limit the data if the Setup Amount is equal to the Dispotion Code and the Reason Code is 0007. Is there a way to limit the data coming back in the Query Panel Window?
Take care
Bill

 

[skrandel]

Sure, one of the operators is to compare 1 object to another.

Steve Krandel
VERITAS Software

 

[txwylde]

I have created a variable to flag the fields. Here is the code:
= If ((<A/R Setup Amt>) = (<A/R Disposition Amt>)) And ((<A/R Disposition Reason Cd>) ="0007") Then "1" Else "2"

I want to filter only the items that = 2. The problem is I can not use that back into my query. I can only use it after the query has been run.

Any ideas?

 

[blom0344]

Your second demand is the opposite of the initial one.
Follow Steve's reply and build the correct condition in the query panel. It's doable and there will be no need to fetch all data first (and then flag and filter accordingly)

Ties Blom
Information analyst

 

[txwylde]

Ok.. forgive my ignorance but in the Edit the Data Provider window, the only way I can see to compare one object to another is using the User Objects which is to the right of the SQL button. In the Conditions, I do not see where I can compare two variables. Thanks!
Bill

 

[txwylde]

Wait a sec! I got it. Thanks for all of you guy's help.