List field reference qualifier

[conanlloyd]

Hey gang~

I have a list type field named training_class on my GE54 Application table that references the GE54 Training Class table.   I want to filter it based on the display value of the application field on the Application table.

for example, if I am editing a record on the Application table and the name field contains the display value of Conan's Awesome App, I want the filter for training_class to only show me results from the training table where active=true and related_application='Conan's Awesome App'

Apparently I have not had the right amount of coffee because I can't get it to work right.

Help?

~Conan

[Jon Barnes · Accepted solution]

You should Be able to dotwalk to the display field in your ref qual.

for example if your display field on the training table is called name, the qualifier would be:

JavaScript: "active=true^related_application.nameLIKE"+ current.name

this would give you a contains type query. Not sure I have your column names right, but should give you the concept I think you need

[conanlloyd]

You got me 99% of the way there.   My final reference qualifier ended up being: javascript:'active=true^application='+current.variables.ge54_system_name