I was so excited to see the new "between" and "not_between" operators in the service configuration editor, but I'm having trouble using it. For example, I want to search for records where Date is between a specified start and end date, but I can't map both the start and end date to the Date field in the service (see attached image). I know I could create a service by URL that does this same thing, but it would be great to use the "out of the box" functionality.
I believe this is a limitation in the UI and we will investigate it.
Thanks for checking this out, Chris. Do you know if there is a setting that needs to be enabled to use the Service Configuration URL service? When I enter the form's data URL (https://{location.hostname}/forms/secure/org/data/50bc2e4c-7aaa-4bb0-8a09-4540e238ae25/F_Form1?format=application/json) it gives me an "Unauthorized" response.
You can see that kind of response if you are using the 'fetch' operation. You may need to set an Authorization header in the request. There have been times where even that fails and I have to copy/paste the sample request content from somewhere else. But the run-time (when the form is launched) should work.