Multiple related lists on the same table, related to the same form, but with different default filter

Annika Aaltonen
Kilo Guru

Hi,

I have one related list on table X, related to the Requested Item form. It has default filter ABC. Now I want to create a new related list, also on table X, related to the Requested Item form, BUT with default filter DEF. This doesn't seem to be possible, at least not by simply creating a new entry on the Related list entries -table. It seems whatever filter I set for the new related list, this filter will also copy over to the original related list on mentioned table.

Any way around this?

Thanks in advance,

Annika

1 ACCEPTED SOLUTION

Dubz
Mega Sage

Your standard related list will show records linked via a reference field, you could configure a relationship to get records from the same related table but with different conditions.

Go to system definition > relationships, configure the applies to and query from tables and set conditions using syntax like:

current.addQuery('field', 'value');
current.addQuery('another_field', 'another value');

View solution in original post

1 REPLY 1

Dubz
Mega Sage

Your standard related list will show records linked via a reference field, you could configure a relationship to get records from the same related table but with different conditions.

Go to system definition > relationships, configure the applies to and query from tables and set conditions using syntax like:

current.addQuery('field', 'value');
current.addQuery('another_field', 'another value');