Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Connection: Trigger: Run If - search substring in context value

******NEVERMIND******
of course, after trying everything i could think of for like an hour, I figure it out right after I post the problem:

StringHandling.INDEX(context.FileMask,"Option")>0
Labels (2)
2 Replies
Anonymous
Not applicable
Author

******Original Post(s)******
I want to search a context variable value for a substring, and run a job if the substring exists in the context variable value. But I'm having trouble getting the right logic to make that happen
The only thing that allowed tRunJob_2 or tRunJob_8 ran both of them (see pic #5)

Relational.NOT(Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option")))


Related Topics
1006
2112

Here is a list of other things I have tried, and the errors I've gotten:
StringHandling.INDEX(context.FileMask,"Option")

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Type mismatch: cannot convert from int to boolean
Type mismatch: cannot convert from int to boolean
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)


StringHandling.INDEX(context.FileMask,"Option") != null

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator != is undefined for the argument type(s) int, null
The operator != is undefined for the argument type(s) int, null
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)


Relational.NOT(Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))) = TRUE

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The left-hand side of an assignment must be a variable
The left-hand side of an assignment must be a variable
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)


Relational.NOT(Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))) == TRUE

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
TRUE cannot be resolved
TRUE cannot be resolved
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:432)


Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))!=0

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator != is undefined for the argument type(s) boolean, int
The operator != is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)


Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))>0

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator > is undefined for the argument type(s) boolean, int
The operator > is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)


Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))<0

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator < is undefined for the argument type(s) boolean, int
The operator < is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)


Relational.ISNULL(StringHandling.INDEX(context.FileMask,"Option"))==1

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
The operator == is undefined for the argument type(s) boolean, int
The operator == is undefined for the argument type(s) boolean, int
at bbfiletransform.bbdatatransform_convertfile_0_4.BBdataTransform_ConvertFile.tRunJob_1Process(BBdataTransform_ConvertFile.java:431)


0683p000009MCfg.jpg0683p000009MCar.jpg0683p000009MCfl.jpg0683p000009MCfv.jpg0683p000009MCCW.jpg

Anonymous
Not applicable
Author

error