Filter conditions choice list dot walking on table

Dipu_9999 · ‎08-02-2023

what is filter conditions for "RITM is closed but its child change request is active" on change request table?

Harish KM · ‎08-02-2023

Hello find below filter. you need to dotwalk parent field

and select parent.state is closed complete

Regards
Harish

Harish KM · ‎08-02-2023

you should have a parent field on change request which stores ritm number, you can dot walk that in filter condition. child and parent will always have a relationship that is reference field

Regards
Harish

Dipu_9999 · ‎08-02-2023

can you please tell me in brief all that conditions for RITM IS closed but its child change request is active

Harish KM · ‎08-02-2023

on your change request table what is the field name where ritm number is stored?

Regards
Harish

Dipu_9999 · ‎08-02-2023

Number filed