limit selection options

[Sahar_Kaizer]

Hi,

I've created a record producer with a 'Caller' field and a 'Position' field, which is a reference to the 'u_positions' table. I'm attempting to use a reference qualifier to limit the selection options in the 'Position' field based on the positions listed in the related list that appears in the user record. However, I'm struggling to find the right condition to write in the reference qualifier. How can I achieve this?

Thanks,

Sahar.

[Brad Bowman]

The Related List you're referring to will be custom, since it's using a custom table.  You can view the definition of that via Relationships in the left nav.  This will show you what is involved in the query to only show certain records in the related list.  If it's just something like:

current.addQuery('field_name', parent.sys_id);

Then your reference qualifier on the position variable in your Record Producer would look something like this:

Where field_name is the name of the field on the u_positions table that is a reference to sys_user, and caller is the name of the Caller variable.  This is all just a best guess and will depend on the structure and relationships of your custom table.