AnsweredAssumed Answered

Additional Where depending value

Question asked by aebmknrl on Mar 2, 2017
Latest reply on Mar 6, 2017 by jmayer

Hi community, actually i need a conditional where that depends on the value of another field (this another field can be changed / set by the user on any moment) 

 

So this is the code:

 

<!-- This is the field that the user can select an organization of type 'VP': -->

<PDM_MACRO name=dtlLookup hdr="VP" attr="zorg_vp" factory="org" extraURL="ADDITIONAL_WHERE=ztipo_org='VP'">




<!-- This is the field that the where clause depends on the first field value -->

<PDM_MACRO name=dtlLookup hdr="Unidad Solicitante" attr=zunidad_solicitante_corr2 factory="org" extraURL="ADDITIONAL_WHERE=(ztipo_org='Unidad Solicitante' and zvp_unidadsol.name=?????? <-- here is where i need that the value)">

 

Any idea to do this? Thanks

Outcomes