In the where clause, instead of using "or" as below, is there a way of using a list of invno ? If not, is there a limit of "or" we can put ?
"WhereClause": "invno = '4000' OR invno = '95648'",
Have you tried "invno in ('4000', '95648',...)" ?
yes but I get this:
<span style="border:0px currentColor;font-weight:400;line-height:normal;margin:0px;padding:0px;"> <span class="hljs-attr" style="border:0px currentColor;font-weight:400;line-height:normal;margin:0px;padding:0px;">"ErrorMessage"<span style="border:0px currentColor;font-weight:400;line-height:normal;margin:0px;padding:0px;">: <span style="border:0px currentColor;color:#a2fca2;font-weight:400;line-height:normal;margin:0px;padding:0px;">"Invalid JSON Response Handle - Invalid Data or Mismatched Table Query in Request"<span style="border:0px currentColor;font-weight:400;line-height:normal;margin:0px;padding:0px;"> }
I assume you are using the fetchwhere API call. In this case, this is essentially Progress code.
even though the CONO is in its own field of this call I have found that you should include cono in your where clause.
Also, I recommend including the table name.
"Where oeeh.cono = 1 and (oeeh.invno = 4000 or oeeh.invno = 95648 or....)"
There is no limit to the number of ORs. If invno is integer, quotes are not needed.
ok thks
That image relieved a tremendous amount of built-up stress from working with FetchWhere! :-)
