https://www.servicenow.com/community/employee-slate-and-employee/how-to-check-comma-seperated-field-values-in-gliderecord-query/m-p/3058138#M10384 <P>hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/681032">@Ssinha4</a>&nbsp;</P><P>To check for comma-separated field values in a GlideRecord query, you need to properly parse the values from the field and compare them against your criteria. Check bellow script once and let me know its working or not:</P><LI-CODE lang="markup">var gr = new GlideRecord('your_custom_table'); // Replace with your actual table name gr.addEncodedQuery('u_recipient=' + recipient); gr.addNotNullQuery('u_vendor'); gr.query(); while (gr.next()) { var vendors = gr.u_vendor; if (vendors) { // Split the vendors into an array var vendorArray = vendors.split(','); // Trim whitespace and check if the sender is in the vendor array for (var i = 0; i &lt; vendorArray.length; i++) { if (vendorArray[i].trim() === sender) { // Match found - remaining code here gs.info('Match found for sender: ' + sender + ' in vendors for record: ' + gr.sys_id); // Add your additional logic here break; // Exit loop if match is found } } } }</LI-CODE><P>&nbsp;</P><P>i hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.</P><P>thank you</P><P>rajesh</P> Fri, 27 Sep 2024 14:21:14 GMT Rajesh Chopade1 2024-09-27T14:21:14Z https://www.servicenow.com/community/employee-slate-and-employee/how-to-check-comma-seperated-field-values-in-gliderecord-query/m-p/3058102#M10382 <P>Hi All,</P><P>We have field on our custom table where we store comma separated values in string type field.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ssinha4_0-1727444765626.png" style="width: 400px;"><img src="https://www.servicenow.com/community/image/serverpage/image-id/389957i1DD15A5F99719ACE/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Ssinha4_0-1727444765626.png" alt="Ssinha4_0-1727444765626.png" /></span></P><P>We have a inbound action email script&nbsp; but not working.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Ssinha4_1-1727444911132.png" style="width: 400px;"><img src="https://www.servicenow.com/community/image/serverpage/image-id/389958i302322801C804F61/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Ssinha4_1-1727444911132.png" alt="Ssinha4_1-1727444911132.png" /></span></P><P>Let me know how can we achieve this?</P><P>&nbsp;</P><P>Thank you in advance</P> Fri, 27 Sep 2024 13:49:46 GMT https://www.servicenow.com/community/employee-slate-and-employee/how-to-check-comma-seperated-field-values-in-gliderecord-query/m-p/3058102#M10382 Ssinha4 2024-09-27T13:49:46Z https://www.servicenow.com/community/employee-slate-and-employee/how-to-check-comma-seperated-field-values-in-gliderecord-query/m-p/3058138#M10384 <P>hi&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/681032">@Ssinha4</a>&nbsp;</P><P>To check for comma-separated field values in a GlideRecord query, you need to properly parse the values from the field and compare them against your criteria. Check bellow script once and let me know its working or not:</P><LI-CODE lang="markup">var gr = new GlideRecord('your_custom_table'); // Replace with your actual table name gr.addEncodedQuery('u_recipient=' + recipient); gr.addNotNullQuery('u_vendor'); gr.query(); while (gr.next()) { var vendors = gr.u_vendor; if (vendors) { // Split the vendors into an array var vendorArray = vendors.split(','); // Trim whitespace and check if the sender is in the vendor array for (var i = 0; i &lt; vendorArray.length; i++) { if (vendorArray[i].trim() === sender) { // Match found - remaining code here gs.info('Match found for sender: ' + sender + ' in vendors for record: ' + gr.sys_id); // Add your additional logic here break; // Exit loop if match is found } } } }</LI-CODE><P>&nbsp;</P><P>i hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.</P><P>thank you</P><P>rajesh</P> Fri, 27 Sep 2024 14:21:14 GMT https://www.servicenow.com/community/employee-slate-and-employee/how-to-check-comma-seperated-field-values-in-gliderecord-query/m-p/3058138#M10384 Rajesh Chopade1 2024-09-27T14:21:14Z