Login or create new account.

By registering on joomprod.com, you will have immediate access to all our free products and to the public side of our support forum.

Enjoy our subscriptions.

Each of our subscriptions allow you to enjoy the private side of the support forum and all the update of our products for a period ranging from 3 months to 1 year.

Payment And immediate download.

After subscribing to one of our subscription, the products are immediately downloadable.

Accueil / forum / Public Forum / Main Forum / adsmanager select list field sorting

Support Availability Because we must sleep sometimes

Working days: Monday to Friday.
Reply time: Depending on the complexity of your support issue it's usually between a few hours to 48 hours.

Support is only guaranteed to paid subscribers

AdsManager - End of life

It is with great regrets that we have chosen to end the developpement of Adsmanager and its other associated components.

AdsManager is born 10 years ago and, as of today, the number of new subscriptions and downloads have fallen and we cannot maintain the component anymore.

All active subscribers will be able to continue enjoying support until the end of their subscription.

The components will be free and no support will be provided anymore for the other users.

Notice

The forum is in read only mode.

× OLD Forum post could be checked here : forum.joomprod.com

adsmanager select list field sorting

Start
Prev
1
Next
End

apapaioannou@gmail.com
Topic Author
Offline
Gold

8 years 7 months ago #21633 by apapaioannou@gmail.com

adsmanager select list field sorting was created by apapaioannou@gmail.com

Examle
We have a single select list with car makes. The values are in an external table:
Coloumn names (id - Description)

id Descritpion

1 - Alfa romeo
2 - Citroen
3 - Volvo

We must add a new row line with value
id Descritpion
4 - Mercedes.

The new values after this new row are as below and the user see the new value (Mercedes) Last)
1 - Alfa romeo
2 - Citroen
3 - Volvo
4 - Mercedes.

The question is :
Could i sort the selext list values by Description?
Because i would like to show to the user the list as below

1 - Alfa romeo
2 - Citroen
4 - Mercedes.
3 - Volvo

juloaadmin
Offline
Gold

8 years 7 months ago #21661 by juloaadmin

Replied by juloaadmin on topic adsmanager select list field sorting

There is no option to select the order in the code
so it's the "insert" order
if you want to change that you will have to change helpers/field.php
and change SQL requests like :
$sql = "SELECT `$name` as fieldtitle,`$colvalue` as fieldvalue FROM $dbname";
You should add some ORDER BY ...

there is several location for this SQL in this file

apapaioannou@gmail.com
Topic Author
Offline
Gold

8 years 7 months ago #21677 by apapaioannou@gmail.com

Replied by apapaioannou@gmail.com on topic adsmanager select list field sorting

Thanks a lot.
The only question i have is, what will happen with the adsmanager version upgrades? It needs to do this change every time i upgrade the adsmanager?

juloaadmin
Offline
Gold

8 years 7 months ago #21693 by juloaadmin

Replied by juloaadmin on topic adsmanager select list field sorting

Yes curretnly you will have to do it. Except if we found time to add a option to "set order BY "in the select field option.

apapaioannou@gmail.com
Topic Author
Offline
Gold

8 years 7 months ago #21705 by apapaioannou@gmail.com

Replied by apapaioannou@gmail.com on topic adsmanager select list field sorting

If you find the time to add this option in a next adsmanager version it will be perfect. Till then i will make the changes you described me.
Thanks a lot.

juloaadmin
Offline
Gold

8 years 7 months ago #21710 by juloaadmin

Replied by juloaadmin on topic adsmanager select list field sorting

Start
Prev
1
Next
End

Moderators: perry

Time to create page: 0.120 seconds