Using a Object as a Dataset Parameter

0
Hi, I'm trying to incorporate an Object parameter in an OQL Dataset but cannot see the right syntax anywhere. The parameter is tied to a drop down in a report. My goal is to be able to select something in the drop down, generate the report and then use the parameter to filter my dataset. So far I've tried the below in the WHERE and JOIN constraint clauses: Module.Entity = $Parameter Module.Entity.Attribute = $Parameter/Attribute None of these allow me to use the Parameter. Anybody know how to query the object parameter in a dataset? Many Thanks
asked
2 answers
1

Use CTRL-Space as a hint just like in the xpath editor

Sample

FROM MyFirstModule.Customer 
WHERE  MyFirstModule.Customer/ID = $OBJECTPARAMETER AND
              MyFirstModule.Customer/Number = $INTPARAM
SELECT Name
answered
0

Quick question : What if the report parameter which is of type Object is not selected on the page, the execution (oql execution) failed , how do we check $parameter empty or null , i am unable to cast or use coalesce functions. If i remove the where predicate where i am checking that object parameter , it works fine… If we select  value in the object report parameter , there is no issue.

answered