The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Filter reference field based on another reference field

RishabhB
Tera Contributor

Greetings,

 

There is a requirement to filter a reference field(Table A: Entity Type) based on other reference field(Table B: Entity Name) in the Table C(c_entity_type, c_entity_name). The relationship between the 2 fields are maintained in Table B.

1. I tried adding c_entity_type under dependent field in c_entity_name variable which gives me blank.

2. I also tried using javascript:'entity_type='+current.variables.c_entity_type under advanced reference qualifier of c_entity_name variable which gives me all the values instead of filtered ones.

 

Please suggest on the above requirement, if there is any change required or solution available.

0 REPLIES 0