serviceNow REST API sysparm_query fields that are not null

TL;DR: [Joey (accepted answer)]: Assuming the column name for "Business Application" is ubusinessapplication: sysparmquery=incident=true^ubusinessapplicationISNOTEMPTY Context: Stack Overflow #34344024 (accepted answer, 7 votes, 1 answers): sysparmquery for rows that only have data in a specified column For example: I want data for incidents that are active and have a business application defined sysparm_query=active=true^??????

Fix

1. [Joey (accepted answer)]: Assuming the column name for "Business Application" is ubusinessapplication: sysparmquery=incident=true^ubusinessapplicationISNOTEMPTY Context: Stack Overflow #34344024 (accepted answer, 7 votes, 1 answers): sysparmquery for rows that only have data in a specified column For example: I want data for incidents that are active and have a business application defined sysparm_query=active=true^?????? Expected: this specific failure stops.

Details

[Joey (accepted answer)]: Assuming the column name for "Business Application" is ubusinessapplication: sysparmquery=incident=true^ubusinessapplicationISNOTEMPTY Context: Stack Overflow #34344024 (accepted answer, 7 votes, 1 answers): sysparmquery for rows that only have data in a specified column For example: I want data for incidents that are active and have a business application defined sysparm_query=active=true^??????

When to use

You hit exactly this: serviceNow REST API sysparm_query fields that are not null in serviceNow.

When not to use

A different error, or the same symptom in a different tool. This page only covers the failure above.

Compatibility

serviceNow.

Source: Stack Overflow #34344024 (accepted answer, 7 votes, 1 answers): sysparmquery for rows that only have data in a specified column For example: I want data for incidents that are active and have a business application defined sysparmquery=active=true^??????

Verified resolution: [Joey (accepted answer)]: Assuming the column name for "Business Application" is ubusinessapplication: sysparmquery=incident=true^ubusiness_applicationISNOTEMPTY

Source URL: https://stackoverflow.com/questions/34344024