ARI Soft - Sort by Hidden Column

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show Cart

Recent Events

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

more...
31/12/2023 New Year SALE

We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

Sort by Hidden Column

(1 viewing) (1) Guest

Page: 1

TOPIC: Sort by Hidden Column

Forum Tools

#13992

Sort by Hidden Column 13 Years, 7 Months ago	Karma: 5
Is it possible to sort and ARI Data Table by a hidden field? I have a field is_featured which populates with 0 for not featured and "1" for featured. I would like to sort the table with the featured rows at he top of the table. When I sort using the column index for "is_featured" with sort type numeric and decending it does exactly what I want but the column must be visable to work. thanks

trevor_stp

The administrator has disabled public write access.

#14007

Re:Sort by Hidden Column 13 Years, 7 Months ago Karma: 760

Hello,

It is not possible to sort by hidden column on frontend, but if you load data from SQL database you can sort data if add "ORDER BY is_featured DESC" clause to "SELECT" statement. For example:

Code:



SELECT

 *

FROM

 tbl

ORDER BY

 is_featured DESC

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#14022

Re:Sort by Hidden Column 13 Years, 7 Months ago	Karma: 5
thanks, that worked

trevor_stp

The administrator has disabled public write access.

Page: 1

Useful Links