Hi,

We need to create a report with 3 levels cascade parameters with OptionQuery, we are using IDM 4.5

This is our code

<PluginParameterDefinition>
<Type>String</Type>
<DisplayName>Rol30</DisplayName>
<Description>Rol30 descripcion</Description>
<InternalName>search_rol30</InternalName>
<DefaultValue/>
<IsForPrompting>0</IsForPrompting>
</PluginParameterDefinition>

<PluginParameterDefinition>
<Type>String</Type>
<DisplayName>Filtro Rol30</DisplayName>
<Description>Filtro Rol30 descripcion</Description>
<InternalName>rol30</InternalName>
<DefaultValue/>
<IsForPrompting>1</IsForPrompting>
<PreventDuplicates>1</PreventDuplicates>
<OptionQuery>
select role_name, role_id
from idm_rpt_cfg.idmrpt_role_cs_v
where
role_level=30 and
lower(role_name) like lower('##search_role30##')
</OptionQuery>
<OptionMultivalue>0</OptionMultivalue>
<OptionMultivalueDelimiter>,</OptionMultivalueDelimiter>
<Required>1</Required>
</PluginParameterDefinition>

<PluginParameterDefinition>
<Type>String</Type>
<DisplayName>Rol10</DisplayName>
<Description>Rol10 descripcion</Description>
<InternalName>search_rol10</InternalName>
<DefaultValue/>
<IsForPrompting>0</IsForPrompting>
</PluginParameterDefinition>

<PluginParameterDefinition>
<Type>String</Type>
<DisplayName>Filtro Rol10</DisplayName>
<Description>Filtro Rol10 descripcion</Description>
<InternalName>rol10</InternalName>
<DefaultValue/>
<IsForPrompting>1</IsForPrompting>
<PreventDuplicates>1</PreventDuplicates>
<OptionQuery>
select
rol.role_name, rol.role_id
from
idm_rpt_cfg.idmrpt_role_mappings_v as rm,
idm_rpt_cfg.idmrpt_role_cs_v as rol
where
rol.role_id = rm.role_id and
lower(rol.role_name) like lower('##search_rol10##') and
rm.mapped_id like '%'||lower('##rol30##')||'%'
</OptionQuery>
<OptionMultivalue>0</OptionMultivalue>
<OptionMultivalueDelimiter>,</OptionMultivalueDelimiter>
<Required>1</Required>
</PluginParameterDefinition>

The first parameter called rol30 works but the second parameter called rol10 doesn't. the rol10 field doesn't shown the roles according the role30 selected.
The error message shows that parameter rol30 isn't sent.

Any ideas, is it posible?

Thanks,
Roberto H