Skip to main content
Question

API_DoQuery: How do I code where a field value is one of a series ?


Forum|alt.badge.img+1

 E.g. query={6.EX.1 OR 3 OR 7 OR 24 OR 2}.

In SQL - select * from xyz where [6] in (1,3,7,24,2)


This topic has been closed for replies.

Like this:

{6.EX.1}OR{6.EX.3}OR{6.EX.7}OR{6.EX.24}OR{6.EX.2}

Forum|alt.badge.img+1
Thanks. I was hoping there was something similar to the HAS/XHAS list, but OR'ing.

Hi Dan,

I'm testing the API_DoQuery with the following code and I'm not getting any result. Could you help me?

var promise = $.get(dbidcalendar, {

act: "API_DoQuery",

          query: "{3.EX.178}",

          clist: "3"

});

$.when(promise).then(function(xml){

var recordid = $("rid", xml).text();

});


I use something similar for API_AddRecord and API_EditRecord and it works very well. The APP does not have APPTOKEN

log the xml response:

console.dirxml(xml);

this will reveal the tag for the record is <record_id_> not <rid>

Awesome. Thanks Dan.