I am stuck with an API query again....
This works fine:
......./api/v1?table=pricelist&action=list&q=(name~contains~ibuprofen)(price~contains~200)(packsize~contains~24)
this produces the correct number of filtered records, but this doesnt
......./api/v1?table=pricelist&action=list&q=(alldetails~contains~ibuprofen)(alldetails~contains~200)(alldetails~contains~24)
instead produces a wild selection of results
Is there a way of searching on the same column multiple times, or is it necessary to duplicate the column for each search pair like this...
......./api/v1?table=pricelist&action=list&q=(alldetails1~contains~ibuprofen)(alldetails2~contains~200)(alldetail3~contains~24)
which I havent tried as I am not keen to do if I can avoid it...
Many thanks for any advice!
David
