How to get current record producer variable names as choices to a field

[Mr_Vin]

Hi All,

Can anyone accept this challenge?

I have an interesting requirement to get the record producer variables as a choice list ( should be able to select multiple ) to a field in the record producer. And, the choice list must be built by pulling current record producer variables.

for EG:

1. I have created a field 'u_rp_variables' on 'sc_cat_item_producer'

2. I have sample record producer 'My_record_producer1' and it has variables 'short_description','description','comments'

3. Now, I would like to get those 3 variables as choice list and I should able to select two of them.

Any suggestions/guidance is much appreciated.

Thanks

Vino.

[Patrick Schult2]

Well, remember that the reference qualifier is actually an encoded query. What you can do here is take your current encoded query, and add additional conditions to it to filter out the 3 variable types for containers (container start, split, end).

For an example, you currently have this query: cat_item={a sys_id}. If you want to add another condition to exclude Container Split variables (remember, there are 3 variable types for containers, this is just one of them), you would write the query as: type!=24^cat_item={some sys_id}. Read the docs below to figure out how to determine what to use as the query.

Because you want to make it dynamic and work with the current record, you write it in the dictionary's Reference qual field as: javascript: 'type!=24^cat_item=' + current.getValue('sys_id'); When the dictionary actually reads this, it will come out like: type!=24^cat_item=25110912372211003e7d40ed9dbe5dd6

Encoded query strings - how to work with encoded queries, and write your own.

Generate an encoded query string through a filter - easy way to generate an encoded query after building it in a list.

[Mr_Vin]

This worked!!

javascript: 'nameNOT LIKEcontainer^cat_item='+current.getValue('sys_id');

Thank you so much @patrickschulte. You're awesome!