Adding a Trend encoded query to a Business Rule
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-09-2023 01:27 AM
In a Business Rule, I'm wanting to add the following Trend search:
When I right click on the query and select 'Copy Query', it appears as:
sys_created_onDATEPARTMidnight hour@javascript:gs.datePart('hour','0','GE')^sys_created_onDATEPART8 am hour@javascript:gs.datePart('hour','8','LT')
I'm wanting to copy this query and apply it in a Business Rule as a condition. However, I get the following error:
If somebody could please explain what I need to do, that would be great.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 02:03 AM - edited 10-10-2023 02:03 AM
Which table this rule is running on? Is it a custom one which extends Task table?
If that so, you need to set the Order of your Business Ruler greater than the Order of the OOTB rule below.
Name: Set Closure Fields
URL: https://<instance_name>/sys_script.do?sys_id=59f3ba850a00070416e9c50e6215a8d1
It is because we need the "Closed at" field get populated to get its value. So the Order of your Business Rule should be 11000 for example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2023 02:12 AM