Question e-mail

Hello,
I have to send a message whenever I don’t find a specific file. So I tried to recuperate the name of each file in a variable and then test if exist or not, and here I got the error

The syntax "is not null" is a sql syntax, it cannot work on an execution condition.
Execution conditions are expressed with Javascript.

Example :
%{MY_VAR}% == 1 && '${~/doctype}$' == 'invoice'

Do you have any idea who can I solve the problem !!

How does your process detect the files ? Is it a FileWait action ?
What does the variable "Schenker_air" contain when the file is not found ?

yes I used a FileWait action and the variable "Schenker_air" get back the name of the file if exist from the table "ind_session_file_op_lst"

OK, how does this variable get data from "ind_session_file_op_lst" ?
What is the variable's value when the file was not found ?
Sorry for all the questions, but we cannot guess all this, please provide as much information as possible about how the process works and what you need to do

At first, I used the FileWait to implement the table (ind_session_file_op_lst) so that I can know the files that I did get.
Then I cried variables in which I put the name of the file by using “ select file_name from ind_session_file_op_lst where file_name like 'name of the file' ”
When the file was not found I think that the variable will get “null” as value, in that case I have to send a msg in order to declare that there is a missing file which is for example “schenker air”

OK, thanks.
Can you open the "Session Details" view, select the "Variables" tab, and check what is the Value of the Schenker_air variable ?

Here is it

OK, so it looks like an empty value.
Did you try an expression like this in the Execution condition :

%{Schenker_air}% != ''