API_DoQuery: How do I code where a field value is one of a series ?
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)
Forum Discussion
log the xml response:
console.dirxml(xml);
this will reveal the tag for the record is <record_id_> not <rid>
console.dirxml(xml);
this will reveal the tag for the record is <record_id_> not <rid>
You have to request "structured xml" like this:
Note your query will always contain just one record so you can shorten the selectors to just asking for those nodes where the <f> element has an id attribute or 6, 7 or 8 respectively.
$.get(dbidcalendar, {
act: "API_DoQuery",
query: "{3.EX.178}",
clist: "3.6.7.8",
fmt: "structured"
}).then(function(xml) {
console.dirxml(xml);
var fid6 = $("f[id=6]", xml).text();
var fid7 = $("f[id=7]", xml).text();
var fid8 = $("f[id=8]", xml).text();
});Note your query will always contain just one record so you can shorten the selectors to just asking for those nodes where the <f> element has an id attribute or 6, 7 or 8 respectively.