question Re: Add filter to Edit.. related list button (m2m table relationship) in ITSM forum

Add filter to Edit.. related list button (m2m table relationship)

R_52 — Thu, 07 Sep 2023 18:08:22 GMT

Intro:

I am trying to add a filter for Edit.. button on a Related lists. This Edit.. button was coming as part of the newly created m2m relationship b/w 2 tables. Now, when I am trying to add the filter conditions via "Edit Default Filter" option in the sys_ui_control record.. it's only having very limited options. I am unable to add custom filter.

Also, User is able to remove this existing filter and can see all the values. It's not even read-only.

Does anyone know how to provide the custom filter conditions for his Edit... button ? Please leave your thoughts..

Re: Add filter to Edit.. related list button (m2m table relationship)

Brad Bowman — Thu, 07 Sep 2023 18:59:23 GMT

What you need to do is alter the UI Action for the Edit... record. Find the one for m2m then change the Script, or you can try first changing the table then doing an Insert and Stay to make a copy so that you're not changing the button for all m2m related lists. In any event you need to add 2 uri.set lines to set a default filter on the ensuing slushbucket, and to hide it so that it can't be altered.

uri.set('jvar_no_filter', 'true'); uri.set('sysparm_query', 'nameIN' + GlideStringUtil.join(tables) + '^sys_scope!=' + parent.sys_scope.toString());

sysparm_query can reference any number of things - a variable that calls a Script Include, encoded query,... this one is from an Edit UI Action in my PDI.

Re: Add filter to Edit.. related list button (m2m table relationship)

R_52 — Fri, 08 Sep 2023 09:58:27 GMT

It worked. Very much appreciated!

Re: Add filter to Edit.. related list button (m2m table relationship)

Brad Bowman — Fri, 08 Sep 2023 11:42:10 GMT

You are welcome!

Re: Add filter to Edit.. related list button (m2m table relationship)

R_52 — Mon, 11 Sep 2023 11:21:06 GMT

Hi @Brad Bowman

I am trying to implement similar behavior in Configurable workspace as well.. The thing is when I am trying to select the record and save it. then it is not saving the records.

If you have came across any such issues.. please let me know

Re: Add filter to Edit.. related list button (m2m table relationship)

Elena Spıru — Tue, 03 Sep 2024 08:04:39 GMT

Hello!

I have a similar task now but in my case when I go to a change task record, in the affected CIs related list and I click on the Edit button (custom made)...I need a filter to show only those Affected CIs that are listed in the Change request as "Affected CIs" (parent of that change task) and somehow all the logic is correct but when I try to apply the filter, nothing happens.

Can you please explain the following code?

uri.set('sysparm_query', 'nameIN' + GlideStringUtil.join(tables) + '^sys_scope!=' + parent.sys_scope.toString());

If you want I can provide additional info regarding my task, maybe you have an idea.

Thank you,
Elena