Formatted Search Query in SAP B1

[joseih]

I have this querry
SELECT DISTINCT CURRENT_DATE AS "Current_Date" FROM ORDR
That i will put in a date type field.
But i want only this querry to trigger when she's empty. How do i do that?

[CharlesFeng]

Hi joseih,

I tried to understand your questions by reading it multiple times, but it is still not clear to me.
Could you please explain it in more details? Maybe an example will be helpful for us to understand.

Best regards,
Charles

[joseih]

Sorry Charles!
Basically i created a field in SAP B1 that indicates the month of the document, here in Brasil is a crucial thing to have. But, everytime i open a marketing documment, this field is empty, so, i wanted to have a querry that will give me the current date.
Thank you!

[yogananda · Accepted solution]

joseih

You can use an IF statement in your SQL query to check if the date field is empty. If it is empty, then the query will execute, otherwise it won't.

Example:

IF NOT EXISTS (SELECT CURRENT_DATE FROM ORDR WHERE date_field IS NULL) 
    SELECT DISTINCT CURRENT_DATE AS "Current_Date" FROM ORDR;