How to set the invalid queries into empty result sets in ServiceNow?

[Mohd Arif Khan]

How to set the invalid queries into empty result sets in ServiceNow

[GlideFather]

Hi @Mohd Arif Khan 

can you please better explain your requirement?

[Nikhil Bajaj9]

Hi @Mohd Arif Khan ,

Although your question is incomplete but i am replaying as per my understanding of the question:- 

To ensure that invalid GlideRecord queries in ServiceNow result in empty result sets, the glide.invalid_query.returns_no_rows system property must be set to true.

Please let me know in case you were asking about same or soemthing else. 

If my answer helped you in anyways, please amrk it as Solution accepted.

Regards,

Nikhil Bajaj

[RAMANA MURTHY G]

Hello @Mohd Arif Khan ,

We have a sys_property glide.invalid_query.returns_no_rows

please take a look on it

[leaschmidt]

You could use the property glide.invalid_query.returns_no_rows

In our instance we did not have the property, the solution was:

Create a New Property:
-> In the Filter Navigator, type and enter sys_properties.list.
-> Click on New to create a new property.

Populate the Fields:
-> Name: glide.invalid_query.returns_no_rows
-> Type: true | false
-> Value: true