Ask Your Question
0

Query using multiple fields

asked 2021-04-12 04:41:34 -0500

updated 2021-04-12 04:45:41 -0500

Hi,

I would like to make query based on multiple fields like city, state and rest other searchable fields.. Kindly let me know.

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2021-04-12 10:47:08 -0500

updated 2021-04-12 10:50:31 -0500

Probably the easiest way to learn how to query would be to download a tool like RETS Connector.
http://www.retsconnector.com/
You can use it to build queries and with logging on you can see what the queries look like in the logs.
Generally it would take the form of "(L_State=FL),(L_City=Jacksonville)"
Where comma (",") = AND and pipe ("|") = OR and tilde ("~") = NOT.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-04-12 04:41:34 -0500

Seen: 23 times

Last updated: Apr 12