I’m trying to use the Report Rule Log to figure out why my report rule is not yielding the expected results and am having trouble understanding what the log is telling me.
For each test, I get two records, one saying the result = TRUE (Log ID 152), the next saying the result = FALSE (Log ID 154). I’d like to understand what’s happening at Log ID 154 so my rule is evaluating as FALSE.
This is what the actual rule looks like:
And this is the Expression 1:
[&SELECT NVL(cf$_subcontract,'No') from purchase_order_cfv p where p.order_no ='[@PURCHASE_ORDER_PRINT_REP/PO_HEADERS/PO_HEADER/ORDER_NO]' ]
As you can see by the log, the rule fires without error, but the action to add the pdf to the end of the report does not succeed.
I’ve tried this with another rule to add the pdf where my custom field value = “Yes” and that works fine since I don’t have to do a coding work around to handle the null custom field values. I’m pretty sure my issue is just with the way I’m creating Expression 1.
Any help is appreciated
Best answer by mwilson
View original
