Client Script - addEncodedQuery

[Daryll Conway]

I have an onSubmit client script that I am trying to run the following code in ...

function onSubmit() {
       var modelMatch = false,
       curModel = g_form.getValue('u_discovered_model'),
       ciList = [],
       encQuery = "nameLIKE" + String(curModel) + "^ORmodel_numberLIKE" + String(curModel),
       gr = new GlideRecord("cmdb_model");
       gr.addEncodedQuery(String(encQuery));
       gr.query();
       alert('pre query');
       while (gr.next()) {
               ciList.push(String(gr.name));
               modelMatch = true;
       }
       if(modelMatch){
               var listModels = '';
               for(i=0;i<ciList.length;i++){
                       listModels = listModels + ' : ' + String(ciList[i]);
               }
               if(confirm('Are you sure this model does not already exist?\nThese models are already in Service Now : ' + listModels + '\nClick CANCEL if you would like to change to one of these')){
                       return true;
               }
               else{
                       g_form.showErrorBox("u_discovered_model", 'Please Change the model to an existing one. Such as : ' + listModels);
                       return false;
               }
       }
}

I reach line 6 but it falls over on the encoded query (line 7).

I've checked my query and it is as expected and works when I use it to query the table directly (in list view).

Can anyone see where I'm going wrong?

[ganeshb_]

Well in that case , you need look upon the field - "u_discovered_model. What is it? is it   a reference field?

If yes, then it won't work

[Daryll Conway]

It is not a referenced field it is a string. I've checked my g_form.getValue() returns and I get the string that was typed.

[Daryll Conway]

Has anyone managed to get an .addOrCondition() to work?

I've seen it in the wiki but any time I've tried it it falls over.

[edwin_munoz]

Hi Daryll,

Unfortunately you rare limited to use only the method listed here:

http://wiki.servicenow.com/index.php?title=Client_Side_GlideRecord

You will need to use an encoded query by using the addQuery method

[Daryll Conway]

I've tried adding the encoded query in to an addQuery() but I get very odd results with the or condition in the encoded query string and it's definitely not matching the conditions given.