|
Ari Data Table filter Data 8 Years, 8 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?
|
|
|
|
|
|
|
Re:Ari Data Table filter Data 8 Years, 8 Months ago
|
Karma: 760
|
|
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
|
|
|
|
|
|
|
Re:Ari Data Table filter Data 8 Years, 8 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 11:25 By Lipe.
|
|
|
Re:Ari Data Table filter Data 8 Years, 8 Months ago
|
Karma: 760
|
|
It is possible to use value from this drop-down into SQL query.
Regards,
ARI Soft
|
|
|
|
|
|
|
Re:Ari Data Table filter Data 8 Years, 8 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
|
|
|
|
|
|
|
Re:Ari Data Table filter Data 8 Years, 8 Months ago
|
Karma: 760
|
|
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
|
|
|
|
|
|
|
