vLookup filter with multiple conditions

[Travis Goodman]

I’m having an issue with vLookup where it’s not working when I try and use an and statement.

In my parent item I have a LoginMin and LoginMax field. In my child list I have a field for just Login. In my parent list, I create Logins associated to the parent item where the child item’s login must be between the min-max range of the parent.

I am needing to do a vLookup filter to return all items where the Login value is ge LoginMin and Login is le LoginMax.

It works if I do just one of these parameters, but that’s not good enough. I need both.

Here’s the setup that fails: Login ge ‘[[fieldValue:LoginMin]]’ and Login le ‘[[fieldValue:LoginMax]]’

That same query works fine if I do it manually in my RESTED application.

[Alexander Bautz]

What kind of error are you seeing? – If it does not throw an error that you can see directly you must open the developer tools and look at the console or the network tab.

Alexander

[Author]

Posts