Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.

  • 14/04/2017 Happy Easter

    Wish a Happy Easter and give 30% discount for all our WordPress and Joomla! extensions. Use EASTER17 coupon code. The offer is valid till 17 April.


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




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Ari Data Table filter Data
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Ari Data Table filter Data
#57074
Ari Data Table filter Data 1 Year, 7 Months 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?
The administrator has disabled public write access.
 
#57075
Re:Ari Data Table filter Data 1 Year, 7 Months ago Karma: 667
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
The administrator has disabled public write access.
 
#57076
Re:Ari Data Table filter Data 1 Year, 7 Months 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>
Last Edit: 2016/03/02 04:25 By Lipe.
The administrator has disabled public write access.
 
#57077
Re:Ari Data Table filter Data 1 Year, 7 Months ago Karma: 667
It is possible to use value from this drop-down into SQL query.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#57078
Re:Ari Data Table filter Data 1 Year, 7 Months 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
The administrator has disabled public write access.
 
#57081
Re:Ari Data Table filter Data 1 Year, 7 Months ago Karma: 667
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
The administrator has disabled public write access.
 
Go to topPage: 1