Is there a way to do a search where a comma is not treated as an "or" condition but is instead treated as part of the string?

Derek Morrocco

November 01, 2016 01:43

When I type "Wells Fargo, Advisors" in my find field and click search my inquire service is called twice, once with the criteria "Wells Fargo" and again with "Advisors". What I would like is for there to be one service call with the criteria "Wells Fargo, Advisors".

Thanks

Have more questions? Submit a request

2 Comments

Date Votes

0

smilliken August 01, 2012 18:39

Hi Derek,

I know in SQL if you were to search for "Wells Fargo, Advisors" you would see in the AppStudio logs an entry similar to this: '('Wells Fargo','Advisors ')' .

This does not mean that there are two separate parameters being called. The AppStudio logs actually uses this format to show that this is one parameter using the parenthesis instead of two separate parameters. If you were to actually search in your backend using this parameter in SQL: '('Wells Fargo','Advisors ')' you would see an incorrect syntax error. The SQL plugin does not actually use the parenthesis it is just formatted this way in the logs.

Thanks,

Scott

Permalink
0

Derek Morrocco August 01, 2012 19:31

We use .net Web Services for our backend and we are using the wsdl plugin.

Thanks,

Derek

Permalink

Please sign in to leave a comment.