Gliderecord Query when field is blank (null)

[Sam Ogden]

I've written the below code which looks up producer.more_details_answer against u_csm_question_value in the u_incident_assignment_rule table and then sets the category, subcategory and assignment group on the Incident form.   If producer.more_details_answer is blank (has no value in it) then it is checking against the table for a blank value in the u_csm_question_value and then assigning the logs to the first blank record in the table.

I require that when producer.more_details_answer is blank then the code does not run and therefore leaves category and subcategory and assignment group blank.   I've tried various ways around this with not success so any help would be greatly appreciated.

Thanks

[Mihir Mohanta · Accepted solution]

Before the GlideRecord query(line 48) add an if statement like :

if(producer.more_details_answer !=''){

and close the if statement after line 61   using }