Database View - Where Clause
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-06-2019 05:07 PM
Does anyone know the script to filter on records created 90 days or 3 months ago within the Where Clause of a Table within a Database View?
Below is the javascript command I have applied but this does not work. Note 'sa_timestamp' is the field that displays the date I want to filter on.
sa_timestamp>=javascript:gs.beginningOfLast90Days()
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-11-2019 11:06 PM
Hi Mark,
Did you find anything useful for this anywhere so that you can share here?
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-28-2019 11:45 PM
Hi Mark,
Any update on this?
Can you mark my answer as ✅ correct, 👍 helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2022 11:42 PM
If we have huge data more 25 lakh then this reporting filter is not working. that Why I am looking for date filter in database view