DataView condition expression

[Justas]

Hi,

Can anyone help with this. In DataView condition i want to compare two values Available_Users.LaborHed_EmployeeNum <> PmIdHolder.Team1PM. it is not working and probably because first value is a string and second is a number. How to write this condition properly, cast some how or what?

[dcamlin (David Camlin)]

Read through this thread. @hmwillett explains creating a function to do this kind of thing. That way you call the function to do the conversion when comparing Strings and Integers.

But even with the function, there was some good troubleshooting in this thread to find a solution. Hopefully something in here should get you in the right direction.

Application Studio - Disable Print Button

I would look at the Dev Tools as this point to check the values of the flow. Make sure the payload sent to your function has the proper value being sent. Validate the response is as expected. Dump the views (CTRL+ALT+V), expand System Views, and validate that actionResult has a value. It may show null here. Assuming you had debugging turned on (CTRL+ALT+8) check the console. You should see some events in there for your row-update showing the values of actionResult at the time.

[hmwillett (Hannah Willett)]

@Justas

Available_Users.LaborHed_EmployeeNum <> PmIdHolder.Team1PM

Try this:

#_'{Available_Users.LaborHed_EmployeeNum}' != '{PmIdHolder.Team1PM}'_#

[Justas]

i get this in console Errors: invalid argument outside of criteria: 415,invalid token: !,invalid argument outside of criteria: 173
Found that this works Available_Users.Selected = True AND {Available_Users.LaborHed_EmployeeNum} <> PmIdHolder.Team1PM. But then the issue is why if i select one record then it is ok no itteration is called but if i select multiple records looks like the condition evaluates only first row for this {Available_Users.LaborHed_EmployeeNum} <> PmIdHolder.Team1PM and all rows for Available_Users.Selected = True so in this case when multiple records selected it bypasses second condition and all selected rows are stored in result dataview, I dont understand why this happening?

[Justas]

this worked Available_Users.Selected = True AND Available_Users.LaborHed_EmployeeNum <> ‘{PmIdHolder.Team1PM}’. Thanks @hmwillett i was missing these fellas ‘{}’ . Thats a pain i have no clue when to use ‘’ when != when <> when {} or etc.

[hmwillett (Hannah Willett)]

Honestly, I really hate the dataview-condition widget.
It’s one of those where the syntax isn’t the same as everywhere else.

Like, take their tooltip for example:

Dataview.Column without curly braces (at minimum) or quotes.
Single equals sign, which to me means assignment, not equality.
Capital T on true when I’ve seen most of App Studio complain about that.

@Justas

True AND Available_Users.LaborHed_EmployeeNum

The use of AND when the other expression fields are using &&.

Hot. Mess.