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

[former_member513075]

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

[gmblom]

do not put in the '=' in the selections tab for a value. The '=' expects a valid REL expression. For fixed values just pass in the correct value.

Regards Gerben