12 views

Description

Spotlight gets collected for records which do not suffice to satisfy the spotlight criteria. The problem occurs also when using the big OR in the criteria condition query.

Steps to Reproduce

1) Login a pre-London instance.

2) Create a spotlight group similar to this:

3) Create a spotlight criteria similar to this:
 


4) Run the spotlight job (/nav_to.do?uri=/sysauto_script.do%3Fsys_id%3Dd84fb547f3331200eaae19d854612b37)

Observe the spotlight is also collected for incidents which do not pass the spotlight criteria set in step 3 (/incident_list.do?sysparm_offset=&sysparm_query=active%3Dtrue%5Eassigned_toISNOTEMPTY%5ENQopened_at%3C%3Djavascript:gs.endOfToday()%5Estate%3D2&sysparm_list_mode=grid)

Workaround

This problem was fixed in London. For earlier releases, there are two possible workarounds applicable.

  1. You can use the small 'or' instead of the big 'OR' in the criteria condition, as bellow:




  2. You can split the part of the condition in the big OR into its own spotlight sub-criteria.

 


Related Problem: PRB1297441

Seen In

There is no data to report.

Fixed In

London

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-10-12 06:11:33
Published:2018-10-12