AnsweredAssumed Answered

Filter dtlDropdown with SREL attribute

Question asked by lxpbn on Mar 14, 2016
Latest reply on Mar 21, 2016 by Chris_Hackett

Hello everyone,

 

I want to link a CI (family nr) to a CI (family slax).

My family nr has an attribute (SREL) "z_it_service" that is a SREL to the nr table obviously.

 

In my case a specific role needs to use that SREL but doesnt want to search for the required value in a Lookup field of houndreds of entries but wants to have a dropdown list with only his required three entries.

So I tried to create a dropdown that shows only three values but still creates a correct SREL. Addtitionally that dropdown needs to filter the entries to only three left entries. Also we dont want to display the actual common name of the nr object but the content of an attribute that is located in the slax family named z_productname.

 

So kind of "graphically":

 

NR

Dropdown     ->     NR

                                  -> SLAX

                                        -> z_productname

 

So what I tried is to use the normal Dropdown function and add the list_display function like that, but I dont get it done.

 

<PDM_MACRO name=dtlDropdown hdr="Test"

attr="z_IT_service"

make_required="yes"

link="yes"

factory="slax"

list_display="z_productname"

list_orderby="z_productname"

rel_attr_name="id"

use_list_display="1"

whereclause="name='SERV-IT-000001' or name='SERV-IT-000002'">

 

Could you please help me?

Outcomes