ARI Soft - how many rows/entries support this module ?

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

how many rows/entries support this module ?

(1 viewing) (1) Guest

Page: 12

TOPIC: how many rows/entries support this module ?

Forum Tools

#39465

Re:how many rows/entries support this module ? 11 Years, 7 Months ago Karma: 760

Search for "Server side pagination" mode doesn't work for query with calculated fields (in your case field where "CONCAT" is used). You can format columns with help of "Column settings -> Format" parameter. For example you can use the following SQL query:

Code:



SELECT 

 b.job_title AS JobTitle, 

 c.type AS Type, 

 a.first_name AS FirstName,

 a.last_name AS LastName,

 a.email AS Email, 

 a.tel AS Tel, 

 a.filename AS FileName,

 a.file_hash AS FileHash

FROM 

 dy849_jobboard_applicants a, 

 dy849_jobboard_jobs b, 

 dy849_jobboard_categories c 

WHERE 

 a.job_id = b.id 

 AND 

 b.category=c.id

and set "Columns settings -> ID" parameter to FirstName and "Columns settings -> Format" parameter to the following value:

{$columns:FirstName} {$columns:LastName}

set "Columns settings -> ID" parameter to LastName and "Columns settings -> Hidden" to "Yes".

set "Columns settings -> ID" to FileName and "Columns settings -> Format" to the following value:

<a href="www.jobinrwanda.com/{$columns:FileHash}_{$columns:FileName}">Download</a>

set "Columns settings -> ID" to FileHash and "Columns settings -> Hidden" to "Yes".

Regards,
ARI Soft

admin

The administrator has disabled public write access.