ARI Soft - Server side pagination - search

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

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...
21/11/2023 BLACK FRIDAY 23 is coming

BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.

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

Server side pagination - search

(1 viewing) (1) Guest

Page: 1

TOPIC: Server side pagination - search

Forum Tools

#31803

Server side pagination - search 11 Years, 9 Months ago

Karma: 0

I am having trouble getting the search field to work when using server side pagination on a simple query where there is no CONCAT in the query.

Here is the query:
SELECT `Item Code` as 'Item Number', ` Description`
FROM repinventory
WHERE 1

There are no column settings at all (formats/alias etc)

You can see the page here:
logochairs.com/product-lines/what-do-you-make

Simply search for something you see in the data. It returns no data.

Please advise the correct procedure to make the search field work with SSP.

Thank you!

timtenn

The administrator has disabled public write access.

#31804

Re: Server side pagination - search 11 Years, 9 Months ago	Karma: 0
Nevermind. I suppose I can't use "AS" in my query either. Hmm..

timtenn

The administrator has disabled public write access.

#31805

Re: Server side pagination - search 11 Years, 9 Months ago	Karma: 748
Hello, Use "Columns settings -> Alias" parameter if you want to change column header. It is possible to use "AS" in SQL query, but without spaces in quotes. Regards, ARI Soft

admin

The administrator has disabled public write access.

#31911

Re:Server side pagination - search 11 Years, 9 Months ago Karma: 0

Hello,

I am new to ARI and wondering if you can help.

I am using ARI SQL to extract data out of a table.

How do I make it so that it is searchable and pageinated?

I am currently putting the ARI codes inside an Article as follow

Code:

{arisqltable}

{arisqltablecolumns}

{arisqltablecolumn id="name" alias="Case Name" width="30%"}

{arisqltablecolumn id="file_number" alias="Our File#" width="15%"}

{arisqltablecolumn id="claim_number" alias="Claim#" width="10%"}

{arisqltablecolumn id="attorney" alias="Our Attorney" width="15%"}

{arisqltablecolumn id="open_date" alias="Open Date" width="10%"}

{arisqltablecolumn id="close_date" alias="Close Date" width="10%"}

{arisqltablecolumn id="disposition" alias="Disposition"width="10%"}



{/arisqltablecolumns}

{arisqltablequery}

SELECT name,file_number,claim_number,attorney,

DATE_FORMAT(open_date,'%m/%d/%Y') As open_date,

DATE_FORMAT(close_date,'%m/%d/%Y') As close_date,

disposition

FROM case_masterlist_closed WHERE 1

{/arisqltablequery}

{/arisqltable}

thuaung@waiconnor.com

The administrator has disabled public write access.

#31912

Re:Server side pagination - search 11 Years, 9 Months ago Karma: 748

Hello,

This code for "ARI Smart Content", not for "ARI Data Tables" module. You can wrap "ARI SQL Table" with "ARI JDataTable" plugin. The code will look like:

Code:



{arijdatatable}

  {arisqltable}

    {arisqltablecolumns}

      {arisqltablecolumn id="name" alias="Case Name" width="30%"}  

      {/arisqltablecolumn}

      {arisqltablecolumn id="file_number" alias="Our File#" width="15%"}

      {/arisqltablecolumn}

      {arisqltablecolumn id="claim_number" alias="Claim#" width="10%"}

      {/arisqltablecolumn}

      {arisqltablecolumn id="attorney" alias="Our Attorney" width="15%"}

      {/arisqltablecolumn}

      {arisqltablecolumn id="open_date" alias="Open Date" width="10%"}

      {/arisqltablecolumn}

      {arisqltablecolumn id="close_date" alias="Close Date" width="10%"}

      {/arisqltablecolumn}

      {arisqltablecolumn id="disposition" alias="Disposition"width="10%"}

      {/arisqltablecolumn}

    {/arisqltablecolumns}

    {arisqltablequery}

SELECT name,file_number,claim_number,attorney,

DATE_FORMAT(open_date,'%m/%d/%Y') As open_date,

DATE_FORMAT(close_date,'%m/%d/%Y') As close_date,

disposition

FROM case_masterlist_closed

    {/arisqltablequery}

  {/arisqltable}

{/arijdatatable}

Regards,
ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links