Tag et Ordre

ggppdk
Offline
Administrator

12 years 11 months ago #20778 by ggppdk

Replied by ggppdk on topic Tag et Ordre

Kim, i have added support for ordering the tag view in the SVN, but tested only the ordering by core fields,

I only tested a little , the ordering by custom field (text),

I had no time to test more, did you use a custom --text-- field for ordering ?

The select fields store the their --id-- value in the database so the current code will not work if you try to order by a select / selectmultiple field.

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

kim
Topic Author
Offline
Elite Member

12 years 11 months ago #20780 by kim

Replied by kim on topic Tag et Ordre

Yes i use a custom text field.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 11 months ago #20782 by ggppdk

Replied by ggppdk on topic Tag et Ordre

This is new code ...

Kim i hope i can test on Monday.

I have opened an issue not to forget:
code.google.com/p/flexicontent/i ... ail?id=281

Regards

Please Log in or Create an account to join the conversation.

kim
Topic Author
Offline
Elite Member

12 years 11 months ago #20789 by kim

Replied by kim on topic Tag et Ordre

Ok, it's very cool !
I will try to patience my client.
But thanks a lot for your help.

Kim.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 11 months ago #20797 by ggppdk

Replied by ggppdk on topic Tag et Ordre

# In r999 , fixed the the recently added, custom field ordering for tags

You can get the new files here (v1.5.6 preRC2):
code.google.com/p/flexicontent/s ... tail?r=999

Take care not to take the files for FC v2.0

Please Log in or Create an account to join the conversation.

kim
Topic Author
Offline
Elite Member

12 years 11 months ago #20814 by kim

Replied by kim on topic Tag et Ordre

the ordering doesn't work...
And i have this error, when i click in tagcloud,

Code:

SELECT i.id, i.title, i.*, ie.*, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie ON ie.item_id = i.id INNER JOIN #__flexicontent_tags_item_relations AS t ON t.itemid = i.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid LEFT JOIN #__categories AS mc ON mc.id = i.catid WHERE t.tid = 142 AND i.state IN (1, -5) AND i.sectionid = 5 AND mc.access <= 0 AND i.access <= 0 GROUP BY i.id ORDER BY f.value + 0 ASC, i.title
Unknown column 'f.value' in 'order clause' SQL=SELECT i.id, i.title, i.*, ie.*, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM jos_content AS i LEFT JOIN jos_flexicontent_items_ext AS ie ON ie.item_id = i.id INNER JOIN jos_flexicontent_tags_item_relations AS t ON t.itemid = i.id LEFT JOIN jos_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jos_categories AS c ON c.id = rel.catid LEFT JOIN jos_categories AS mc ON mc.id = i.catid WHERE t.tid = 142 AND i.state IN (1, -5) AND i.sectionid = 5 AND mc.access <= 0 AND i.access <= 0 GROUP BY i.id ORDER BY f.value + 0 ASC, i.title LIMIT 0, 20

Please Log in or Create an account to join the conversation.