Using Filters Trend, Time and Text

[Erasmo]

Good Afternoon

I would like to know:

1 - What is a "Trend filter" and what application for it?

2 - What diference between "Relative" and "Between"? and what application for it

3 - What diference between "Is Empty" and "Is String Empty".

Thanks

Erasmo

[Onkar Pandav]

Hi,

Trend is something like On Monday, or On Friday and returns all records in the table that fits that. So you can say, give me a list of all incidents created on a Monday (any Monday), and that would be trend.

Check Trend reports for more info.

Relative gives you the ability to say give me all data related to a time period ago, and the data before or after it, etc.   So, relative would be asking for all incidents created in the past 15 hours, and would be a sliding 15 hours, so if you ran it at 3am, it would go from 12 pm - 3am and if you ran it at 12pm, it would give you 9pm - 12pm.

Relative is all the gs.xxxAgo() script actions. So, gs.minutesAgo(), gs.daysAgo(), gs.monthsAgo(),etc.

"is empty" refer to the value NULL of the field i.e. short description has NULL value.

"is empty string" refer to the value EMPTY of the field i.e. short description has EMPTY value (" ").

Refer Operators available for filters and queries also.

--

Please, remember to mark Correct or Helpful if you find my response useful.

Regards

Onkar

[Onkar Pandav · Accepted solution]

Hi @Erasmo ,

Please mark my answer as correct so as to close this thread that can helpful to others also to learn.

Thank you.

[Indrajit]

Hey Erasmo,

refer below servicenow docs will help you to understand the details of it

https://docs.servicenow.com/bundle/orlando-platform-user-interface/page/use/common-ui-elements/refer...

mark correct and Helpful if contents are useful.

Regards,

Indrajit.

[Swapnil Soni1]

Hi,

Please go through the links-

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/co...

TREND is a DATEPART it contains (year,month,day,hour, minutes). RELATIVE is a REALTIVE it also contains (year,month,day,hour, minutes).

Looking at the results, it looks like trend is something like On Monday, or On Friday and returns all records in the table that fits that.   So you can say, give me a list of all incidents created on a Monday (any Monday), and that would be trend.

Relative gives you the ability to say give me all data related to a time period ago, and the data before or after it, etc.   So, relative would be asking for all incidents created in the past 15 hours, and would be a sliding 15 hours, so if you ran it at 3am, it would go from 12 pm - 3am and if you ran it at 12pm, it would give you 9pm - 12pm..

is empty	[Short description][is empty]	ISEMPTY	short_descriptionISEMPTY	All records in which there is no value in the Short description field.
is not empty	[Short description][is not empty]	ISNOTEMPTY	short_descriptionISNOTEMPTY	All records in which there is any value in the Short description field.
is anything	[Short description][is anything]	ANYTHING	short_descriptionANYTHING	All records in which the Short description field is one of the following: any value empty NULL
is empty string	[Short description][is empty string]	EMPTYSTRING	short_descriptionEMPTYSTRING	All records in which there is no value in the Short description field.

Please mark correct or helpful if this helps.

Thanks

Swapnil