Reference Qualifier with dot walking or script

[Raphael D_]

Hi Experts,

I need help in the following case.

The field invoice_address is a reference field to the table x_addressen. In the table x_addressen is the field key. A example key is: BKH-1-2

Than I have the field Group Company (it’s a mandatory field) The field Group Company is also a reference field to the table sys_user_group. In the table sys_user_group we added an additional reference field named "key".  The reference of the field key is the table x_order with also a field named "key". A example key is: BKH-1.

What I want is to see in the drop-down of the field invoice_address just the entrys which correspondence with the field key in the x_order.

Please note: the key in invoice_adress is BKH-1-2. But the key in x_addressen is just BKH-1.
I have to search with präfix BKH-1*. Or via encoded query string it would be: keyLIKEBKH-1.

I can find a lot of inputs in the community, but I am not sure if I can use a simple Reference Qualifier with dot walking or I have to create a script.

I am thankfull for any inputs:-)

Thanks,
Raphael

[Harsh Vardhan]

you can try with advance reference qualifier

sample code:

javascript: 'keyLIKE='+current.<group comp field name>.getDisplayValue();

make sure key column name and group company field name. 

[Raphael D_]

javascript:'invoice_addressLIKE='+current.<sys_user_group.u_volta_org_unit>.getDisplayValue();

I tryed, but it does not working........

[Raphael D_ · Accepted solution]

solution: javascript:'keyLIKE'+current.assignment_group.u_volta_org_unit.key