cancel
Showing results for 
Search instead for 
Did you mean: 

issue related to query and apd

rizwana_khan1
Participant
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)

cornelia_lezoch
Active Contributor
0 Kudos

Hi,

you can not apply the condition in the query.

You need to define it as a rule in apd.

regards

Cornelia

Answers (2)

Answers (2)

anish_samuel
Explorer
0 Kudos

Hi Rizwana,

You could apply filter in APD Level.

Thanks,

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.