I have the below req.
i want to update the value of a column only if it’s null else leave as it is.
ex: raw_table.date_joined will be populated only if it’s null, if it’s already have a value leave it.
how to do this.
You can do this by using the ternary operator. Check this out:
$date == null ? Date.now() : $date
This translated means, get me the ‘date’ field, but if it’s null, than get the current datetime. If you want to add current datetime even if the field doesn’t exist, than try the following:
$.get('date') == null ? Date.now() : $date
@karthik_dhina: The solution has been provided by @bojanvelevski - trust me it works. If at all you do not want to use a mapper then you can always leverage some snaps like
router for the same but you’ll have to use a mapper after the results are filtered and assign the default value.
Alternatively, you can also use
Conditional snap to achieve similar use cases.