I am having some issues designing a solution to a feature that I need to create.
I have a data set with a specific field that needs to be modified when a condition true is passed in from the web service and not modified when a condition false is passed in from the web service. This modification MUST occur on the server, not the client. Example (not my exact problem, but I am using it for simplicities sake): I have a name field which I would like to order "last, first middle" when I pass true to a specific field of the web service. But when I pass false to a specific field in the web service, I want the order to be "first middle last".
My solution to this problem was to add a "boolean" mock field to the selection of the data set in my service view. Then, expose that mock field in the webservice that will query the data set. However, this method does not appear to be working as whenever I pass in false to the mock field, it does not return any results. This makes sense as I am querying the data set with false on the mock field and there are no values in that field.
Is there a way to add logic to the vql of the JOIN view that can change the query based on whether I pass a specific value to the web service that references the JOIN view?
Any help would be appreciated.