10 years ago
5
Topic
Hi, first of all thanks for the effort done with seblod
I have been using for more than a year and I find it an amazing app.
I bought the ordering pluging, but It doesn't work. I follow the instructions but It doesn't order the content when you select in the frontend.
thanks
Get a VIP membership
4229 Posts
Kadministrator
10 years ago
0
Level 1
Hi,

you mean this plugin http://www.seblod.com/products/919 ?  You will need to be a bit more specific than "it doesn't work"  - does the ordering dropdown appear in your search form? If yes, what happens when user select an option? Please enable debugging in search type to see sql query that gets executed and try using dropdown to see if query changes.
10 years ago
0
Level 1
Dear Klas
Sorry for the lack of precision. 
Yes I meant this plugin http://www.seblod.com/products/919
The dropdown button appear in the frontend and when I select any options it show the same results that showed before I installed and set up the plugins. There is not any change in the order of the results:
I have enabled debug and query doesn't show any changes
For ordering by date of cretion it shows

SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias FROM `#__cck_core` AS t0 LEFT JOIN `#__cck_store_form_precios` AS t1 ON t1.id = t0.pk LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck WHERE t2.state = 1 AND t2.access IN (1,1,2,3) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2014-05-05 16:22:29' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2014-05-05 16:22:29' ) AND t0.cck LIKE '%precios%' AND t1.provincia LIKE '%Madrid%' AND t1.tipo_de_inmueble LIKE '%Piso%' AND t1.piso LIKE '%0-50 m2%' GROUP BY t0.pk ORDER BY t2.created DESC

0.045 seconds (+0.045); 18.58 MB (+18.581) - afterSearch [Cache=OFF]
0.483 seconds (+0.438); 20.73 MB (+2.151) - afterRender [Cache=OFF]

And for ordering by price, it shows the same

SELECT t0.id as pid, t0.pk as pk, t0.pkb as pkb,t0.cck as cck, t0.storage_location as loc,tt.id AS type_id, tt.alias AS type_alias FROM `#__cck_core` AS t0 LEFT JOIN `#__cck_store_form_precios` AS t1 ON t1.id = t0.pk LEFT JOIN `#__content` AS t2 ON t2.id = t0.pk LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck WHERE t2.state = 1 AND t2.access IN (1,1,2,3) AND ( t2.publish_up = '0000-00-00 00:00:00' OR t2.publish_up <= '2014-05-05 16:23:32' ) AND ( t2.publish_down = '0000-00-00 00:00:00' OR t2.publish_down >= '2014-05-05 16:23:32' ) AND t0.cck LIKE '%precios%' AND t1.provincia LIKE '%Madrid%' AND t1.tipo_de_inmueble LIKE '%Piso%' AND t1.piso LIKE '%0-50 m2%' GROUP BY t0.pk ORDER BY t2.created DESC
0.023 seconds (+0.023); 18.58 MB (+18.581) - afterSearch [Cache=OFF]0.352 seconds (+0.329); 20.73 MB (+2.151) - afterRender [Cache=OFF]

Thanks for your time


4229 Posts
Kadministrator
10 years ago
2
Level 1
Hi,

I just tried the plugin on user list (I did add it to Search form tab and configured 2 fields to sort on with asc direction) and it works ok, perhaps you missed that you need to click on Search again to see the difference?
10 years ago
1
Level 2
Thanks
I have been trying for two weeks and I couldn't do it works properly.
Does it works with items or only with lists?
I access to list& search Type and I create a nwe filed in search form, señecting the field type ordering, I select add a field, for example: name. Then I write  Name=name  and I select direction: asc or desc and I write: asc. I repeat the process with other fileds and I keep.
I try in the site and nothing changes.
Are there any post in the forum where somebody explain step by step how to set up this plugin?
Thanks for your help
4229 Posts
Kadministrator
10 years ago
0
Level 3
Hi,

it works only on lists. For configuration see scrrenshots on the product page http://www.seblod.com/products/919 - you just need to use dropdown, don't add fields manually unless you know the syntax exactly.
Get a VIP membership