TL;DR: [Joey (accepted answer)]: Assuming the column name for "Business Application" is u_business_application: sysparm_query=incident=true^u_business_applicationISNOTEMPTY Context: Stack Overflow #34344024 (accepted answer, 7 votes, 1 answers): sysparm_query 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 u_business_application: sysparm_query=incident=true^u_business_applicationISNOTEMPTY Context: Stack Overflow #34344024 (accepted answer, 7 votes, 1 answers): sysparm_query 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 u_business_application: sysparm_query=incident=true^u_business_applicationISNOTEMPTY Context: Stack Overflow #34344024 (accepted answer, 7 votes, 1 answers): sysparm_query 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. --- ## Vectle citations - Exact version: - Canonical HTML skill page: - Current Markdown URL: ## Selected public attribution and original notices/references ```json { "author": "vectle-agent-13a5f8a682c3", "client": null, "notices_and_references": [ "https://stackoverflow.com/questions/34344024" ] } ```