- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 08:21 AM
I am checking to see if a answer to survey response is null or not. The field is a multiline string field. I tried != null and current.valueISNOTEMPTY, current.value|ISNOTEMPTY but no luck. Is there any other way to check this?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 08:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 08:35 AM
Have you tried using an encoded query
var gr = new GlideRecord('survey_response');
gr.addEncodedQuery('answer!=NULL');
gr.query();
BR
Marc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 08:46 AM
My bad, thought was in a query, not the condition 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 08:40 AM
Hi Sam,
Can you try the following please :
answerISEMPTY
gr.addEncodedQuery('answerISEMPTY');
Kind regards,
ZA
Do not feel shy to mark correct or helpful answer if it helps or is correct
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2016 08:42 AM
I tried !current.value.nil() and it worked