Skip to Content
0
Jun 21, 2018 at 02:36 PM

Generate Report in redwood BPA to capture all the jobs with XXXX as the spool recipient

541 Views Last edit Jun 21, 2018 at 02:37 PM 2 rev

When I attempted, I used the SQL query

select * from JobDefinitionParameter where Name = 'REC_RECIPIENT'

and in the column chooser (4th Tab) i picked Default expression, Jobdefinition and the name fields and lastly in the selections I choose the name =REC_recipient and picked the defaultexpression = XXXX, it fails at the report preview with a JCS error.

I have tried multiple combinations but no luck