Any suggestion

For this i have used search ordering plugin to order the

We have student portal.. all the students have their pass out and ongoing year enrolled with them. What we are looking for to filter the students by year .. like if student joined the institute on 2015 when we search it will come first... the student enrolled in 2014 it will show the list of student who were enrolled in 2014.

i only want when i select fields like student year then according to that field year should be shorted in "asc" or "desc" matter accordinglly here i attached some screenshot for better understanding.

1st screenshot--  http://screencast.com/t/adSQhgNXbhG

2nd screenshot-- http://screencast.com/t/RuDEH36EfZz

3rd screenshot-- http://screencast.com/t/W4D5kZjZlb4

Any buddy Here Please help me

Thanks

Create another field in your SEARCH/LIST type.

Type of Field: SELECT DYNAMIC

First see if the following works:

Replace #__content with table of your Form (eg: #__cck_store_form_yourformname)

Replace Options Name with the storage field name of your year field

Replace Options Value with the storage field name of your year field

For storage field enter exactly the same field as you have for your year field (GAB Radio Talent Institute)

Now place this field in your search. You will find some years duplicated, which can be fixed by using  the SQL Query option with DISTINCT or GROUP BY.

Thanks for your reply but in my case i have total 4 diffrent fields and i want to select those fields into dropdown and sort by order then how can i manage those fields

i have attached screenshot below

1st screenshot: http://screencast.com/t/BdKg99bAjT

2nd screenshot: http://screencast.com/t/oo1YMju8e83j

Thanks

You can only add one column in the SELECT DYNAMIC - OPTIONS NAME : confer_radio_talent_institute

The OPTIONS VALUE should also be confer_radio_talent_institute

And your STORAGE FIELD should be the same

You can of course create a separate dropdown for each field/column in your database.

The alternative that  you are looking for to have 4 columns/fields together may require you to create a separate dropdown with dates (seb_datefield) and then use that search field with an advanced SQL query  using the SEARCH QUERY  product www.seblod.com/products/19157

something based on this :

SELECT fieldname, fieldname2, fieldname3 FROM #__yourtablename WHERE [MATCH]firstcolname|| $uri->getValue('seb_datefield')[/MATCH]

OR  [MATCH]2ndcolname|| $uri->getValue('seb_datefield')[/MATCH]

OR ...

If there is a simpler way perhaps someone else can point it out...but I am sure you can do it with the solution I proposed above.

Thanks for your reply but i already buy a new plugin search ordering plugin and above plugin not in my budget ..so please give me some suggation that how can i sort the years using search ordering plugin

Thanks

Hello abhijoomdev,
and thank WebOne for your help.

I thing we have two notions here :
filtering => get only content matching your search type query
ordering => order the results after the search is done

For "Filtering" you must have the field "GAB radio talent Institute" in your search form, with the match "Permissive" or "Exact" depending on the format of the data in this field.
So like that, if you enter "2014", only the corresponding content will be returned.


Now, to sort the result, you must use the plugin field "Search Ordering" with options :
Date Ascending=confer_radio_talent_institue (Attr : ASC)
Date Descending=confer_radio_talent_institue (Attr : DESC)


Normally, with that you will be able to filter and to sort.

regards.
Lionel

Here is my field 

gab radio talent institute=gab_radio_talent_institute                          (ASC)

confer radio talent institute year=confer_radio_talent_institute           (ASC)

kba wku radio talent institute years=kba_wku_radio_talent_institute    (ASC)

kellar radio talent institute years=kellar_radio_talent_institute             (ASC)

It's search but i have an editor field and i have not add any editor field in search ordering plugin.  my ordering is sort according to editor not which field i have added above.

This is not search properly what i am doing wrong.

Thanks

> It's search but i have an editor field and i have not add any editor field in search ordering plugin. my ordering is sort according to editor not which > field i have added above.

Some pointers:
Set the ordering field as the first field (above CCK field)
Add any fields which you want to ORDER BY in this field
Set it as a FILTER - then choose which sort order you want.
Check MODE - NUMERIC/TEXT
Check that in the fields your editor is not inserting any characters in the field (like paragraph tags etc - as the ordering field won't sort properly then)
Remember the ordering plugin will only SORT (ASC or DESC) by the field you specify in the dropdown, nothing more.

Regarding your search generic plugin :

What field are you searching on in this plugin? And have you added anything else (any other fields etc) in your search form?

Also when i search using SEARCH GENERIC PLUGIN like (sale)

But there were some sql error has occured

http://screencast.com/t/z3uTTQhuE1

Any one Help me on above issue

Thanks