So far I think I have it working from the OQL module … Wish the module had more documentation though to prevent trial-and-error type of things :)
I recently worked on OQL and was facing issue with Parameter so did below steps.
1.Created seprate entity for Reporting parameter.
2.Create association between report entity and User,session.
3.Create object when click on Report link and using below query as exapmle to filter OQL data.
select
INVITE.InviteCode AS InviteCode,
INVITE.CustomerEmail AS CustomerEmail
CUSTOMER.CompanyName As CompanyName
FROM ABC_Customer.Invite INVITE
LEFT OUTER JOIN INVITE/ABC_Customer.Invite_CustomerAccount/ABC_Customer.CustomerAccount AS CUSTOMER
where 1=1
and ( INVITE.DateSent>=(Select max(Reporting.ReportSearch.InviteCreationStartDate)
from Reporting.ReportSearch where Reporting.ReportSearch/Reporting.ReportSearch_User='[%CurrentUser%]'
) or (Select max(Reporting.ReportSearch.InviteCreationStartDate)
from Reporting.ReportSearch)=NULL )