Search() function Issue

nagapriyar over 7 years ago

Hi

I'm new to appian.Please help me out of this problem

"Requirement: When I receive an email with subject as "Hello World" I should delete the process.

So I applied a condition in xor node like "search("Hello World",pv!incomingSubject)>0"

If this condition satisfies it moves to deletion Process node.

but the problem is when the subject's length crosses above 70 it is not satisfying the above condition.

eg(XXXX YYYYYYY AAAAA BBBBBBBBBBBB: LMI Aerospace (USA): Hello World QQQQQQQQ SAMPLE SUBECT LINE)

The above subject contains "Hello World" but it is not working.

Note : incomingSubject (Text)

Discussion posts and replies are publicly visible

Parents

0 Mike Schmitt
Certified Lead Developer
over 7 years ago

Can you post what the exact value of pv!incomingSubject is when the subject exceeds 70 characters? It seems almost like some truncation is occurring but there's not enough detail provided to tell one way or the other.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nagapriyar over 7 years ago in reply to Mike Schmitt

pv!incomingSubject contains full subject line("XXXX YYYYYYY AAAAA BBBBBBBBBBBB: LMI Aerospace (USA): Hello World QQQQQQQQ SAMPLE SUBECT LINE") but when it passes to search("Hello World",pv!incomingSubject)>0 it returns false.

But when the same subject is applied like this search("Hello World","XXXX YYYYYYY AAAAA BBBBBBBBBBBB: LMI Aerospace (USA): Hello World QQQQQQQQ SAMPLE SUBECT LINE")>0 is returning true
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 nagapriyar over 7 years ago in reply to Mike Schmitt

pv!incomingSubject contains full subject line("XXXX YYYYYYY AAAAA BBBBBBBBBBBB: LMI Aerospace (USA): Hello World QQQQQQQQ SAMPLE SUBECT LINE") but when it passes to search("Hello World",pv!incomingSubject)>0 it returns false.

But when the same subject is applied like this search("Hello World","XXXX YYYYYYY AAAAA BBBBBBBBBBBB: LMI Aerospace (USA): Hello World QQQQQQQQ SAMPLE SUBECT LINE")>0 is returning true
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 aloks0189
Certified Lead Developer
over 7 years ago in reply to nagapriyar

Hi nagapriyar If possible, can you attach the snippet of Process Variable of running instance, because the same configuration is working here for me in both the cases, and of course generally that should work
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 harshav over 7 years ago in reply to nagapriyar

Hi,

Can you use this code and check

with(
local!a:split("XXXX YYYYYYY AAAAA BBBBBBBBBBBB: LMI Aerospace (USA): Hello World QQQQQQQQ SAMPLE SUBECT LINE"," "),
local!b:wherecontains({"Hello","World"},local!a),
local!b)

I am trying to split all the data with split and making it as an array and finding the indices in the array,

count the index values, if the index value count is >0 then route it to delete process.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 harshav over 7 years ago in reply to harshav

Or else you can also call the values which you wanted to search from a pv and that pv can also be split and used in wherecontains
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 nagapriyar over 7 years ago in reply to harshav

Harshav Thanks Surely will try now
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nagapriyar over 7 years ago in reply to aloks0189

Hi aloks176 Thanks for your comments will attach the snippet
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel