Conditional Sorting

[maverick]

What is the best way to implement Google "sponsored results" type of search. I use that term very loosely just to explain my point.

I have a search form which returns search records and sorts them based on price - which is embedded within the record. I would like to sort them in a way where I can give preferential treatment to some records and list them higher than others. In other words, preferred records should be sorted higher than non-preferred even if their price is higher than non-preferred. (Almost like a 2-tier sort).

I was thinking that I might have to add a field to the record table like "preferred" and use that somehow.

Any ideas/suggestions?

Thanks.

[ShWolf]

Hi,

Yes, you can add a "Preferred" column to the source table. For the records you want to see at the top of results, insert value "1". For all other records put value "2".

Edit your DataPage and on the 'Search Results Options' page select "Preferred" field in the first sort order dropdown (set sort order from A to Z) and in the second dropdown select your field with price (set sort order from Z to A)

Let me know if this helps.

[maverick]

Thanks ShWolf! Great suggestion.

I will try this out tonight and let you know how it works!

[MayMusic]

How did that go?

[maverick]

I totally forgot about this suggestion until today morning when I logged back in to the forum.

I just tried it out and it works great. Thanks again ShWolf!

[MayMusic]

Thank you for updating us !!