Forum Discussion

JohnBarulich1's avatar
JohnBarulich1
Qrew Cadet
7 years ago

JavaScript API_DoQuery failing to give the proper xml response

function getAndSetList() { var url = "blahblah"; getPerm(); $.get(url, { act: "API_DoQuery", query: "{66.IR.'last wk'}", clist: "66" }).then(function(xm...
APIs and custom code
UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
7 years ago
What type of field is  [End Mileage] ? is it a text field, or numeric, or date? If it is not a text field, then it will never return anything, since you are searching for text: 'last wk'.
If it is a text field, then maybe last week, there were no records. I would test this by putting in other text, like 'last month' or 'two weeks' or any other responses this field may have. It may be possible that it isn't returning anything due to that. 
UrsulaLl's avatar
UrsulaLl
Qrew Assistant Captain
7 years ago
I was hoping that was not the case. I have had many issues with duration and date fields when running do_query, I had to do some funky stuff to get it to pull back correctly. I will be following this question to see if anyone comes up with a solution. Good luck!