pick

Nonsense d3 pick syntax error


I made the following queries in d3 and got the following results:

:list      product-master with qoh > 99 and with categ eni
[401] no items present.
:list      product-master with qoh > 9 and with categ eni
[4] syntax error

Why does the query with the 99 parse, while the query with the 9 generates a syntax error?


Solution

  • The default MD has an item called '9', rather than regarding that value as a literal, it's seeing a definition after the ">", which isn't legal. If you put your literals in quotes it'll work for you.

    Similarly, your reference to eni is ambiguous. Do you intend to find a category = "eni", or are you searching for any item that has a non-null category, with a display of the field called ENI? Quotes eliminate all of this ambiguity.

    Please flag this as an Answer after you've verified it. Thanks.