Filter on Related List

[Alex Kraemer]

Hello

I have created a Related List which shows all incidents with the same caller in the Incident Table. The list also works properly. Is it possible to set a filter so that the active Incident in which you are working is not displayed in the Related List?

The reason for this is that the Related List should only be displayed if there are Incidents from the same caller, which does not work because there is always an Incident from this caller.

Thanks for input and greetings
Alex

[Community Alums]

Hi @Alex Kraemer ,

1. Navigate to the related list (example, Incidents on a problem record).
2. Create the desired filter using the condition builder (example, [Active] [is] [true]).
   

   3. Click Set as Default Filter.

[Alex Kraemer]

Thanks for your reply.
I know this option but now i need the filter to filter out the active record above. Any idea?

[Ahmmed Ali · Accepted solution]

Hello @Alex Kraemer 

I am assuming you are using OOTB "Incidents by Same Caller" relationship to show the incidents from same caller. If yes, then you can simply update query of the relationship to not include current incident being viewed. steps to do that:

1. Open relationships table and search with name and open the record which both queries and applies to incident table

2. Update the script with additional query as current.addEncodedQuery('sys_id!=' + parent.sys_id);

3. If not already done, open any incident, in related list of incidents by same caller, right lick and select configure > list control

4. Then in list control form, select "Omit if empty" and save

If you are not using OOTB, then create new relationship as shown above and add to your incident form.

Thank you,

Ali

[Alex Kraemer]

Hi Ali

The query you gave me was exactely what i was looking for.

Thanks a log

Regards

Alex