Glide record query with and operator

[jared_wentzel]

Hi all!

I am having trouble with the following code. I have a table with 3 columns (product, subcategory, assignment group) and I am trying to build a client script to query that table when there is a change to the incident subcategory field where the product and subcategory fields match that of the current record then return the assignment group information. Basically it will serve as a assignment group help for the helpdesk. But it is not working. I have never had to use two conditions for a glide record query before so I think that's where I'm goofing it up.

function onChange(control, oldValue, newValue, isLoading, isTemplate)

{

      if (g_form.getValue('caller_id') != "")

              {

              var subcat = g_form.getValue('subcategory');

              var prod = g_form.getValue('u_product');

              g_form.setValue('u_assignment_assistance', getAssignment(subcat));

              }

      else

      {

              g_form.setValue('u_assignment_assistance', "");

      }

function getAssignment(subcat)

      {

      var gr = new GlideRecord('u_assignment_assistance');

      gr.addQuery('u_product', prod);

      gr.addQuery('u_subcategory', subcat);

      gr.query();

      if(gr.next())

              {

              return gr.u_assignment_group;

              }

      }

}

[jared_wentzel]

I got it working now... Geez it was a combination of a lot of helpful posts but in the end, it was an issue with the field I was trying to populate it into. Thank you everyone for all your help!