Dynamic filtering option

DibyaratnamS
Tera Contributor

I have created a dynamic filter option for sys id type field but when i go to the list to apply the filter via this dynamic filter option, i don't see the operator is(dynamic) which we usually see while selecting the dynamic options. I am doing something wrong here please answer if anyone has idea.

 

DibyaratnamS_0-1786613297650.png

DibyaratnamS_1-1786613328059.png

 

4 REPLIES 4

Lakshmi888888
Kilo Guru

Hi @DibyaratnamS ,

 

Dynamic Filter Options are generally intended for reference-type fields. In your screenshot, the Dynamic Filter Option is configured for a Sys ID (GUID) field, and when filtering directly on the Sys ID field, the is (dynamic) operator may not be available because sys_id is not a reference field.

Could you confirm:

  1. Which table field are you trying to filter on?
  2. Is the target field a reference field or the actual sys_id field?
  3. Is Available for filter checked on the Dynamic Filter Option record?

If you're trying to filter records based on a dynamic set of sys_ids returned by a script, you may need to apply the Dynamic Filter Option against a supported reference field rather than the sys_id field itself.


Please mark this response as Helpful or Correct if it helped.

i wanted to filter the records via sys id so i wrote it on the sysid field type.

Ankur Bawiskar
Tera Patron

@DibyaratnamS 

dynamic filter won't work with sysid field

It primarily works with reference fields

AnkurBawiskar_0-1786616105688.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

In PDI i see multiple dynamic filter options of different field types but don't see any for the sys id field type. doc should mention it clearly on which types are supported and which are not.

DibyaratnamS_0-1786616288347.png