Welcome Guest! Log in

Topic-icon Question e-mail

More
08 Jun 2015 13:33 #1 by J.M
e-mail was created by J.M
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
Attachments:

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 15:04 #2 by Thomas BLETON
Replied by Thomas BLETON on topic e-mail
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'

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 16:06 #3 by J.M
Replied by J.M on topic e-mail
Do you have any idea who can I solve the problem !!

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 16:31 #4 by Thomas BLETON
Replied by Thomas BLETON on topic e-mail
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 ?

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 16:39 #5 by J.M
Replied by J.M on topic e-mail
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"

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 16:45 #6 by Thomas BLETON
Replied by Thomas BLETON on topic e-mail
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 :)

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 17:02 #7 by J.M
Replied by J.M on topic e-mail
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”

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 17:20 #8 by Thomas BLETON
Replied by Thomas BLETON on topic e-mail
OK, thanks.
Can you open the "Session Details" view, select the "Variables" tab, and check what is the Value of the Schenker_air variable ?

Please Log in or Create an account to join the conversation.

More
08 Jun 2015 21:11 #9 by J.M
Replied by J.M on topic e-mail
Here is it
Attachments:

Please Log in or Create an account to join the conversation.

More
09 Jun 2015 09:26 #10 by Thomas BLETON
Replied by Thomas BLETON on topic e-mail
OK, so it looks like an empty value.
Did you try an expression like this in the Execution condition :

%{Schenker_air}% != ''

Please Log in or Create an account to join the conversation.