Question Re: Data Filter based Date in Signal Query in Technology Q&A

Data Filter based Date in Signal Query

shravanr — Mon, 27 Jan 2025 13:23:06 GMT

Hello All,

Please let me know how to implement , how to get the data based on Date filter in Signavio.

Example:

I want to get the data where cases are got after 2024 jan 1st.

We have date column like BLDATE.

SELECT CASEID,USERNAME FROM THIS_PROCESS

WHERE BLDATE >'2024/01/10'

Getting error. I tried multiple ways but no luck.

Requesting you suggest pls.

Regards,

Shravan R.

JessicaK — Fri, 31 Jan 2025 13:49:58 GMT

Hi Shravan,

Thank you for your question. Could you please try WHERE BLDATE > DATE '2024-01-10' with the date being in YYYY-MM-DD format?

Until the User Guide on value comparison has been updated with an example, please refer to this page where the date literal is described.

In case you have further questions, do not hesitate to reach out!

Best regards

Jessica