Aloow and 'And' or 'Or' combination in BrowseDialog

Ger Cannoll — Fri, 24 Sep 2010 12:28:44 GMT

If you have multiple search fields in a BrowseDialog, the search seems to be based on 'Anding' the search conditions.What would be very nice would be to have bracketed conditions. e.g. I want say 3 search criteria (Name, Email1, Email2) and I want a list returned where 'Gerard' is contained in 'ANY' of the 3 columns as opposed to ALL 3 colums i.e.SearchCondition 1 And/Or Search Condition2And/Or SearchCondition3 etc There would also need to be a 'Bracket' facility to allow for nestinge.g.SearchConditon1And (SearchCondition2 Or SearcCondition3 )

RE: Aloow and 'And' or 'Or' combination in BrowseDialog

Greg McGuffey — Fri, 24 Sep 2010 12:28:44 GMT

I checked and this is on the enhancement list already. Currently it isn't a high priority, as the use of ORs in a WHERE clause can lead to performance issues on large tables. This is kind of like "giving enough rope to hang yourself" sort of feature. But as almost any feature, there are valid uses for it and it is on the list.

StrataFrame Forum » StrataFrame Application Framework - V1 » Enhancement Requests » Aloow and 'And' or 'Or' combination in BrowseDialog

Aloow and 'And' or 'Or' combination in BrowseDialog

RE: Aloow and 'And' or 'Or' combination in BrowseDialog