Welcome Guest! Log in
×

Notice

The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

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:
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'
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 !!
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 ?
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"
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 :)
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”
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 ?
More
08 Jun 2015 21:11 #9 by J.M
Replied by J.M on topic e-mail
Here is it
Attachments:
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}% != ''