How to handle NULL

[amit_saroha]

Hi,

I have the below expression but sometimes it can be NULL instead of ‘S’. Could you please suggest how to handle the NULL in the below expression?

$input0.final_document.Pipeline_Status==‘S’ && $input1.final_document.Pipeline_Status==‘S’ && $input2.final_document.Pipeline_Status==‘S’

[JensDeveloper]

Thank you @bojanvelevski for elaborating.

I forgot to say that NULL needs to be in null because that’s so in snaplogic and what bojan gave as a solution should work

[amit_saroha]

@JensDeveloper - I have used the expression but it error out as below -

Reason: com.snaplogic.cc.SnapCcException: Not starting pipeline as pipeline has prepare error. “{4a09e57e-fdc0-465f-9af9-2b8ed3314046={property_map.settings.routes.value[1].expression.value=[Expression parsing failed near – s != NULL >> ? << S : $inp (Reason: Mismatched input ‘?’ at line 1:143. Expecting one of: {, ‘||’, ‘&&’, ‘^’, ‘==’, ‘!=’, ‘>’, ‘<’, ‘>=’, ‘<=’, ‘+’, ‘-’, ‘', ‘/’, ‘%’, ‘instanceof’, ‘in’, ‘[’, ‘(’, ‘.’, PropertyRef}; Resolution: Please check expression syntax)], property_map.settings.routes.value[0].expression.value=[Expression parsing failed near – s == NULL >> ? << S : $inp (Reason: Mismatched input ‘?’ at line 1:143. Expecting one of: {, ‘||’, ‘&&’, ‘^’, ‘==’, ‘!=’, ‘>’, ‘<’, ‘>=’, ‘<=’, ‘+’, ‘-’, '’, ‘/’, ‘%’, ‘instanceof’, ‘in’, ‘[’, ‘(’, ‘.’, PropertyRef}; Resolution: Please check expression syntax)]}, 665a0695-e27a-425f-a665-c7de74c2f820={property_map.settings.routes.value[1].expression.value=[Expression parsing failed near – s != NULL >> ? << S : $inp (Reason: Mismatched input ‘?’ at line 1:143. Expecting one of: {, ‘||’, ‘&&’, ‘^’, ‘==’, ‘!=’, ‘>’, ‘<’, ‘>=’, ‘<=’, ‘+’, ‘-’, ‘', ‘/’, ‘%’, ‘instanceof’, ‘in’, ‘[’, ‘(’, ‘.’, PropertyRef}; Resolution: Please check expression syntax)], property_map.settings.routes.value[0].expression.value=[Expression parsing failed near – s == NULL >> ? << S : $inp (Reason: Mismatched input ‘?’ at line 1:143. Expecting one of: {, ‘||’, ‘&&’, ‘^’, ‘==’, ‘!=’, ‘>’, ‘<’, ‘>=’, ‘<=’, ‘+’, ‘-’, '’, ‘/’, ‘%’, ‘instanceof’, ‘in’, ‘[’, ‘(’, ‘.’, PropertyRef}; Resolution: Please check expression syntax)]}}”