AnsweredAssumed Answered

Parametrized Lookup on filter section

Question asked by alexandrefett on Jun 13, 2012
Latest reply on Jun 14, 2012 by Dave
Hello All,

I'm trying to add a parametrized lookup on the filter section of dashboard panel, but it's not working. It seems its not possible to use a xml parameter outside of a properties screen, (2302092 In this case, the combo is filled with all possible values to all projects and not only the ones that occurs with the selected project.
I don't know if this is the only way to do this.

Lookup:
select distinct
@select:to_char(tbl.petr_versao_reaval):code@,
@select:'Versão - ' || tbl.petr_versao_reaval:nome@

from
odf_ca_petr_valores tbl
where @filter@
AND tbl.odf_parent_id = @where:param:xml:integer:/data/id/@value@ id_projeto
AND tbl.petr_sutipo_curva = 'fase4_REAV'

Does anybody tried something similar? Workarounds? Any ideas are very wellcome.

Thank you in advance,
Alex

Outcomes