- Create SO Item with no block ( ')
- First Delivery Block (ZX) We are using the following PQL query is returning no values. Can you please guide us whether the pql query is correct?
We are trying to build a dashboard to calculate throughput time between two activities.
Page 1 / 1
Hi Muvva,
it seems that you are missing some ' ' in the _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG statement. This should be _CEL_O2C_ACTIVITIES.CHANGED_TO = 'ZG'. Additionally I assume in the _CEL_O2C_ACTIVITIES.CHANGED_FROM = ' you want to indicate that the CHANGED_FROM should be empty. This can be achieved by_CEL_O2C_ACTIVITIES.CHANGED_FROM IS NULL
Hope this helps.
BR
Kevin
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.