Search of Properties to use OR (optionally) not just AND > Product Forums

Unanswered Active Topics

Forums Search Members

Forums > Modules > Property Agent

Subject: Search of Properties to use OR (optionally) not just AND

Prev Next

You are not authorized to post a reply.

Author

Messages

Richard Cook User is Offline

Gold Membership

Nuke Super Newbie
Posts:18

9/05/2008 3:33 PM
I know we have a wildcard search which is excellent. However, I need to have each custom field in the search specified, but would like this to relaxed so that we can search by: field1 = X OR field2 = Y OR field3 = Z At the moment we have search based on: field1 = X AND field2 = Y AND field3 = Z This could be specified as 'Relaxed' or 'Strict' in the Layout Settings.

Scott McCulloch User is Offline

Administrators

Nuke Master
Posts:12446

9/08/2008 8:49 AM
I can add an option in for this.

Scott McCulloch Site Administrator

Richard Cook User is Offline

Gold Membership

Nuke Super Newbie
Posts:18

9/16/2008 7:44 AM

Also Scott, if you were to implement that sort of functionality, would it be possible to implement another option:

field1 LIKE X

field2 LIKE Y

field3 LIKE Z

If you take the AND/OR combination with the LIKE/EQUALS combination, this will give you 4 search cases, LIKE/AND, LIKE/OR, EQUALS/AND, EQUALS/OR (5 if you include your wildcard search)

That would give the property agent the greatest search flexibility.

Regards,

Richard

Scott McCulloch User is Offline

Administrators

Nuke Master
Posts:12446

9/16/2008 9:15 AM
I see what you mean, I'll put it with the original todo item.

Scott McCulloch Site Administrator

You are not authorized to post a reply.

Forums > Modules > Property Agent > Search of Properties to use OR (optionally) not just AND

ActiveForums 3.7