Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your 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.

  • 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.


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?

Possibility to use a filter only if not empty?
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Possibility to use a filter only if not empty?
#54797
Possibility to use a filter only if not empty? 8 Years, 10 Months ago Karma: 0
I'm going to find a solution to show an ARI Data Table based on a SQL statement with a filter, a selection with a type (content of one field). Easy to do.

But I'd like to show all records of the table if the selection ends with an empty table!

Is there any solution to manage this inside the ARI Data Table parameters or is it necessary to do this 'outside'?

Thanks for any ideas!
HeinzP
Don't believe everything you think!
User Offline Click here to see the profile of this user
Gender: Male Location: Lutzenberg Switzerland Birthday: 09/24
The administrator has disabled public write access.
 
#54802
Re:Possibility to use a filter only if not empty? 8 Years, 10 Months ago Karma: 747
Hello,

Could you specify what SQL query do yo use?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#54805
Re:Possibility to use a filter only if not empty? 8 Years, 10 Months ago Karma: 0
Hello

The solution is not yet implemented - it would be a table with the fields:

ID (key / index)
JobTitel (Text)
Kategorie (Auswahl)
Region (Text)
Anstellungsart (Text)
Pensum (Text)
Start (Text)
Aufgaben (Langtext)
Anforderungen (Langtext)
Angebot (Langtext)
Kontakt (aktuell frei)

and it should be a select on the field "Kategorie" (category). If there is at least one record of the selected category (example: architecture) then all records with this category should be the content of the ARI data table. If there is no record with the selected category then all records of the table should be in the displayed ARI data table.

And therefore the question:
Would it be possible to set a filter on the selected category and configurate to show all records if the query ends "empty"?

Regards
Heinz
HeinzP
Don't believe everything you think!
User Offline Click here to see the profile of this user
Gender: Male Location: Lutzenberg Switzerland Birthday: 09/24
The administrator has disabled public write access.
 
#54806
Re:Possibility to use a filter only if not empty? 8 Years, 10 Months ago Karma: 747
The extension doesn't support this ability.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#54807
Re:Possibility to use a filter only if not empty? 8 Years, 10 Months ago Karma: 0
Thanks for your answer - good to know it and ready to look for a workaround

Regards,
Heinz
HeinzP
Don't believe everything you think!
User Offline Click here to see the profile of this user
Gender: Male Location: Lutzenberg Switzerland Birthday: 09/24
The administrator has disabled public write access.
 
Go to topPage: 1