As always...I'd like to have some directions from you guys since once again I'm a little bit lost in the jungle and have no stars leading in the right way.
Here's my story...
I'm using a custom list template, a tpl_basic_list.zip with some html & css to have a list of my contents, I'd like to order the list according to a specific field (a numeric value) but...though I've specified it into the search list options I don't see the results as I should.
Is there something else I have to do? I see that in the menu link option there is something about the default order but selecting CUSTOM and writing the name of the field (ranking) in the space just drives my search in no results at all.
the actual order it's like 9-1-8-5-4 etc etc... totally incorrect.
I've tried your suggestion and found out another problem though, the value I pass through the form was not being saved! Inserting the values directly into the database allows me to see that this way the list display as it should...
i think you should have this storage setting for your field "ranking": standard > article > ranking
can you enable the debug mode for your search type? And send us the resulted query. To enable the debug mode, you can click on button "configuration" in your search type. You will find setting debug. Please, select option "everyone" or "superadmin".
I premise that I'm almost ok with the manual solution of inserting the right values from the database, but for the sake of research I guess it's could be good to understand this strange behaviour.
As a first thing I've deleted the previous ranking field, in some way it was "corrupted" since whenever I was trying to change the storage method in standard or custom mode... this was never be saved. Now I've created another field, at the moment it's a text field and the storage method it's like Mehdi suggested, the problem though remains the same
20-19-2-5, is an example of the order I'm getting now and this is the debug query 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 `#__content` AS t1 ON t1.id = t0.pk
LEFT JOIN `#__cck_core_types` AS tt ON tt.name = t0.cck
WHERE t1.state = 1 AND t1.access IN (1,1,2,3) AND ( t1.publish_up =
'0000-00-00 00:00:00' OR t1.publish_up <= '2013-07-30 08:36:15' ) AND
( t1.publish_down = '0000-00-00 00:00:00' OR t1.publish_down >=
'2013-07-30 08:36:15' ) AND t0.cck = 'cloud_storage_provider'
GROUP BY t0.pk
ORDER BY t1.ordering ASC
Can you share with us the configuration of your menu link?
In the resulted query from the search type, i see ORDER BY t1.ordering ASC. This means that your articles is oredered based the ordering data not based on your numeric field. This caused by the configuration of your menu link.
Thank you very much, with this post you just solved the problem.
Like I was saying I have already selected the custom option in the ordering and the right field but all I had was an empty list of results, this was due to the fact that previously the field was "corrupted", like I was saying...
With the fresh one it just work as it should! thank you very much guys :) It's great to work with you.