Showing results for 
Search instead for 
Did you mean: 

issue related to query and apd

0 Kudos

Hi Experts,

I have an issue in my apd.

source of my apd is a query.i have a field counter,my user asked  to apply condition on counter ,he wants only the records which are having value greater than 0.

i made changes in the query and it is working fine,when i have added this counter field which is having a condition in my apd,it is not executing at all.

this filtering of records must be done at the query level only that is my user's concern.

how can we implement such a scenario.

Thank you,

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


you can not apply the condition in the query.

You need to define it as a rule in apd.



Answers (2)

Answers (2)

0 Kudos

Hi Rizwana,

You could apply filter in APD Level.


Anish Samuel

Former Member
0 Kudos

Just a workaround I did when I faced same problem. Keep hidden fields in the query used in APD, at right most side.

For Open PO/SO/WO I am using conditions in the query used APD as Source.