I gave this in Expression:
($DIFF_REC_COUNT<0)==true &&
(_PIPELINE_NAME.contains(‘PERSON_TYPE_ODS’,‘PERSON_CITIZENSHIP_ODS’,‘PERSON_LANGUAGE_ODS’,‘OCF_US_ODS’,‘OCF_MEXICO_ODS’,‘OCF_NETHERLANDS_ODS’,‘OCF_COSTA_RICA_STG’)==true)
And got this error… JSON o/p
[
{
“reason”: null,
“failure”: “Unexpected error occurred while evaluating expression: SC@3ce966fb”,
“resolution”: “Please check your expression”,
“sub-expression”: {
“0: $DIFF_REC_COUNT”: [
-2
],
“1: 0”: ,
“2: <”: [
true
],
“3: true”: ,
“4: ==”: [
true
],
“5: _PIPELINE_NAME”: [
“DI_AVT_DH_OCF_COSTA_RICA_STG”
],
“6: ‘PERSON_TYPE_ODS’”: ,
“7: ‘PERSON_CITIZENSHIP_ODS’”: ,
“8: ‘PERSON_LANGUAGE_ODS’”: ,
“9: ‘OCF_US_ODS’”: ,
“10: ‘OCF_MEXICO_ODS’”: ,
“11: ‘OCF_NETHERLANDS_ODS’”: ,
“12: ‘OCF_COSTA_RICA_STG’”: ,
“13: (‘PERSON_TYPE_ODS’,‘PERSON_CITIZENSHIP_ODS’,‘PERSON_LANGUAGE_ODS’,‘OCF_US_ODS’,‘OCF_MEXICO_ODS’,‘OCF_NETHERLANDS_ODS’,‘OCF_COSTA_RICA_STG’)”: [
{
“_snaptype_arguments”: {
“searchString”: “PERSON_TYPE_ODS”,
“position”: “PERSON_CITIZENSHIP_ODS”,
“ignored”: “OCF_COSTA_RICA_STG”
}
}
]
}
}
]
can you use the exact expressions which I provided in my previous comments, and see if that works for you, I dont think you can pass multiple arguments in contains method
I solved this issue actually…
I gave this exp and it worked.
($DIFF_REC_COUNT<0) && (_PIPELINE_NAME.contains(‘PERSON_TYPE_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_CITIZENSHIP_ODS’)|| _PIPELINE_NAME.contains(‘PERSON_LANGUAGE_ODS’) )
THanks for your quick response though… 🙂
Great, issue was passing multiple arguments in contains fucntion.
u r right!
