Thanks to @jordan.johnson 's answer yesterday, I got my table query working.
Today though I am working on another section of my model, and I need to query some lists of tokens:
- // See if there is a line for this SKU on this side of the sorter
- query("SELECT labelOrderNum FROM listLinesWaitingToBePicked AS LinesToChoose, listMLO_OrdersOnSorter AS OrdersToChoose \
- WHERE LinesToChoose.labelSKU = $1 \
- AND LinesToChoose.labelOrderNum = OrdersToChoose.labelOrderNum \
- AND OrdersToChoose.labelEvenOdd = $2 \
- ORDER BY labelOrderNum ASC LIMIT 1", getlabel(token,"labelSKUJustPicked"), getlabel(token,"labelEvenOdd"));
I tried it with the lists as local, and again using global lists, and in both cases I made fields for the labels being used in the query. (The code is in a Custom Logic activity.) But I always get this error:
time: 429.349220 exception: Exception caught in flexscript execution of MODEL:/Tools/ProcessFlow/ProcessFlow/Try to find a requirement on this side of sorter>variables/codeNode line 13 instruction 13. Discontinuing execution. time: 429.349220 exception: Exception caught in TreeNode::callMemberFunction() flexscript execution MODEL:/Tools/ProcessFlow/ProcessFlow/Try to find a requirement on this side of sorter>variables/codeNode c: /Tools/ProcessFlow/ProcessFlow/Try to find a requirement on this side of sorter>variables/codeNode i: /Tools/ProcessFlow/ProcessFlow/Try to find a requirement on this side of sorter>variables/codeNode theclass: /Tools/ProcessFlow/ProcessFlow/Try to find a requirement on this side of sorter>variables/codeNode
Any suggestions?
Thanks for your help-
Craig