Dictionary entry advanced reference qualifier to limit choices on field

[slehm]

Hi all,

I created a new column on the Application category Group table (apm_application_category_group) that is a list type and references the business capabilities table (cmdb_ci_business_capability). I also added a reference to the business capabilities table (cmdb_ci_business_capability) on the application categories table (apm_application_category). On the apm_application_category table I want to limit the choices of business capabilities to only the list of business capabilities of the chosen application category group using a dictionary entry/advanced ref qualifier. I've had success doing this with catalog items but it appears that there are differences between table and catalog item ref qualifiers. Can anyone point me in the right direction of how to achieve this? Thanks.

[vkachineni]

//try. untested.

javascript:'sys_idIN' + curren.apm_application_category_group.u_business_capability.toArray().join();

[slehm]

Thanks for this. I ended up getting it to work by removing the .toArray().join(); at the end fo the statement.

javascript:'sys_idIN' + current.apm_application_category_group.u_business_capability;

[vkachineni]

javascript:'sys_idIN' + current.apm_application_category_group.u_business_capability.toString();