B4J Question [BANanoVuetifyAD3] BananoDatasource how to use SELECT_WHERE ,ORDER_BY

joulongleu

Active Member
Licensed User
Longtime User
Hi::)[BANanoVuetifyAD3] BananoDatasource Is a very powerful function,But because I don’t know how to use it, I would like to ask
1.[BANanoVuetifyAD3] BananoDatasource how to use SELECT_WHERE ,ORDER_BY ,Now only select_all will be used?
2.VueTable very good ,There are too many functions ,Won't use,Are there more examples ?
:pThank You.
 

Mashiane

Expert
Licensed User
Longtime User
DataSource

Q1. Remember there are various modes that you can use the data-source. These are:

(a) php (sqlite, mysql, mssql)
(b) bananosql
(c) direct (sqlite, mysql, mssql)
(d) jrdc
(e) banano-relax
(f) firestore

So you need to provide more clarity about your question in terms of which mode you are using so that I can provide you the right response.

VueTable

A1. Thanks for your kind words. Yes, the VueTable compared to the v-data-table is rather one of the most complex components. Most of the functionality of the VueTable has been explored and there are examples in the kitchen sink. The nice thing is, the look and feel of your VueTable can all be set using the abstract designer / code and the only thing you do is to .Reload your data and everything is done for you, re-actively too.

One can also add their own buttons both to the toolbar / action buttons which can be coded on what to do. Also there is inline editing that one can use.

The question rather is, how would you like to use it and if there is no example that meets your needs, that can be made available. If it does not suit your needs, perhaps you can find another component that does.

You can also check the Vuetify documentation on the various options they have in their examples, https://vuetifyjs.com/en/components/data-tables/
BANanoVuetifyAD3 is just a wrapper of the already existing Vuetify API with some enhancements of course.

Above all else, the VueTable property bag is very well commented, just like the Data-Source

Example 1

This is a simple example of how to (a) add records at run-time (via a timer), (b) change text color of a row column (c) change the background color of a row.

1640362673123.png


Example 2

1640362723578.png


1640362749049.png


1640362775317.png


1640362794188.png


Example 3


A Simple Table

1640362903582.png
 
Upvote 0
Top