ARI Soft - Ari Data Table filter Data

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

Ari Data Table filter Data

(1 viewing) (1) Guest

Page: 1

TOPIC: Ari Data Table filter Data

Forum Tools

#57074

Ari Data Table filter Data 10 Years ago	Karma: 0
Hello I'm new in the forum and i want to know before i buy Ari Data table is there is any way for ari data table to filter data. What i mean is that if i have for example data from 2 warehouses with one combobox filter the data of the warehouse. Or with one datepicker to filter the data displayed on ari data table from date x to date y Is this possible with Ari Data Tables?

Lipe

The administrator has disabled public write access.

#57075

Re:Ari Data Table filter Data 10 Years ago	Karma: 766
Hello, It is possible to enter a search string in a input box. If want to use custom filters, it is possible to create a HTML search form outside the module and use request variables in "WHERE" clause of SQL query (if data is retrieved from a database). Regards, ARI Soft

admin

The administrator has disabled public write access.

#57076

Re:Ari Data Table filter Data 10 Years ago

Karma: 0

Form is like this
but i don't know where to add "Where" clause

<HTML><HEAD><SCRIPT type="text/javascript">
function searchSel() {
var input=document.getElementById('realtxt').value.toLowerCase();
var output=document.getElementById('realitems').options;
for(var i=0;i<output.length;i++) {
if(output[i].value.indexOf(input)==0){
output[i].selected=true;
}
if(document.getElementById('realtxt').value==''){
output[0].selected=true;
}
}
}
</SCRIPT></HEAD><BODY>
<FORM>
Search <input type="text" id="realtxt" onkeyup="searchSel()">
<SELECT id="realitems">
<OPTION value="">Select...
<OPTION value="afghanistan">Afghanistan
<OPTION value="albania">Albania
<OPTION value="algeria">Algeria
<OPTION value="andorra">Andorra
<OPTION value="angola">Angola
</SELECT>
</FORM></BODY></HTML>

Lipe

Last Edit: 2016/03/02 11:25 By Lipe.

The administrator has disabled public write access.

#57077

Re:Ari Data Table filter Data 10 Years ago	Karma: 766
It is possible to use value from this drop-down into SQL query. Regards, ARI Soft

admin

The administrator has disabled public write access.

#57078

Re:Ari Data Table filter Data 10 Years ago

Karma: 0

Can i display Views like this?

CREATE VIEW dbo.viewH
AS
SELECT dbo.FatureHRel.ArtikujId, dbo.FatureHRel.Sasia, dbo.FatureHRel.skonto, dbo.FatureHRel.cmimi, dbo.FatureH.kod_fature,
dbo.FatureH.skonto AS SkontoTotale, dbo.FatureH.shenime, dbo.VIEWArtikujt.Kod, dbo.VIEWArtikujt.Emertim, dbo.VIEWArtikujt.NjesiMatesePershk,
dbo.FatureH.data_regj, dbo.VIEWArtikujt.FurnitoriKod, dbo.VIEWArtikujt.FurnitoriEmri, dbo.VIEWArtikujt.FurnitoriQyteti, dbo.VIEWArtikujt.FurnitoriAdresa,
dbo.FatureH.date_fat
FROM dbo.FatureHRel INNER JOIN
dbo.FatureH ON dbo.FatureHRel.FatureHId = dbo.FatureH.FatureHId INNER JOIN
dbo.VIEWArtikujt ON dbo.FatureHRel.ArtikujId = dbo.VIEWArtikujt.ArtikujId

Lipe

The administrator has disabled public write access.

#57081

Re:Ari Data Table filter Data 10 Years ago	Karma: 766
You can create the view in your database (via PHPMyAdmin or other similar tool) and then use "SELECT" SQL query to retrieve data from it (like from table). Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links