Row-Find 'Errors in criteria parser' on my expression

Kinetic ERP
1

I’m battling row-find in app studio, event handler, trying to get the expression syntax correct

I’m in order entry and set my row find properties to:

image

I’ve tried lots of combinations, things that typically work in other event handling widgets but not here

I keep getting:

Errors in criteria parser for expression: "undefined" = "" Errors: invalid token: ",invalid argument outside of criteria: undefined,invalid token: ""

As usual nothing in the application studio help related to row-find
and the tooltip just says “set the expression that will be used to find the row”…lame

I actually have two criteria I would like to use

OrderDtl.ZeroDollar_c, a string, is blank
AND
OrderDtl.DocTotalPrice, a decimal, is 0.00

Any examples out there from folks who have used row-find ?

thanks

2

Could you try changing the expression to the following without wrapping it in " "

{OrderDtl.ZeroDollar_c} = ‘’

1 Like
3

I’ve tried every variation I could think of with single quotes, double quotes, no quotes, with/without dataview name (since there is another parameter for DataView).

Note there are several other actions other than row-find where I have successfully used expressions or where clauseswith similiar syntax, this spot seems different for some reason

for a string field you typically use quotes (my UD field ZeroDollar_c is string)
e.g. ‘{OrderDtl.PartNum}’ == ‘MSC’

for a numeric or boolean you would not
numeric e.g. {OrderDtl.OrderLine} == 0
boolean e.g. {OrderDtl.OpenLine} == false

Thanks for taking a look though
I have opened a support ticket which they have forwarded to Development

Will post an update if anything develops

4

Sorry, could you try ZeroDollar_c = ‘’

We dont need to specify the epBinding just the column name here and also it is just a single operand value i.e. = <> etc

6

Is it because your missing the epBinding for where the count is intended to go?

This is an example of the raw code:

{
“type”: “row-find”,
“param”: {
“dataview”: “IntgValidationError”,
“expression”: “Company = ‘’”,
“mode”: “Count”,
“epBinding”: “TransView.ErrorCount”
}
},

7

I’m trying some variations for the syntax of the expression with epiBinding set,

It is putting the result in the epiBinding but so far still getting syntax errors on the expression. (result will be incorrect if expression has errors)

8

Was able to get an ok syntax, I’m using a non UD field for now
(just in case it has something to do with it, but it shouldn’t)

this:

image

gives me this:

image

No error on the expression syntax finally, but it’s not setting row count correctly
(I do have an OrderDtl row with PartNum = ‘CSDV’)

9

Use = instead of ==