SAP Signavio Process Intelligence will not accept the SQL request under "SQL Filter"

[CLThomas]

Hello, 

I have been trying to filter <null> statements in a certain column from a table that I have extracted from ServiceNow. I am in SAP Signavio Process Intelligence, Source Data>Tables>Configuration Under SQL Filter. I put in the following SQL query.

"SELECT * FROM sc_request WHERE closed_at IS NOT NULL"

Something went wrong

Error: GENERAL_ERROR

Error Id: df52c106-37e5-43f8-b68d-2cc9a649f506
Landscape: prod_cloud_os_us
Must be a valid Select SQL query.

Why doesn't SAP Signavio Process Intelligence accept this query?

Attached screenshot of page.

[chemmerich]

Hello Thomas, 

thanks for your question. 

The error you're encountering indicates that SAP Signavio Process Intelligence doesn't fully support standard SQL syntax in the SQL Filter section. The filter configuration often expects just a conditional expression, not a full SQL query.

Try this instead:

In the SQL Filter section, use only the condition itself, like this:

closed_at IS NOT NULL

Why this works:

• The filter expects a condition rather than an entire SELECT statement.
• SAP Signavio internally handles the data retrieval, so you only need to specify what rows to filter.

Let me know if this resolves the issue! Otherwise please open a ticket in SAP for Me so that our SAP Signavio Support Team can take a look. 

Many thanks, 
Cäcilia