"Select Data Provider" dialog on runtime

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

"Select Data Provider" dialog on runtime

Postby Roberto Blasco » Thu Sep 20, 2018 1:34 pm

Hi all.

Is there any way of showing the "Select Data Provider" dialog on runtime?

Best regards. Roberto Blasco.
Un saludo. Roberto.

Madrid - Spain
Tfno: (+34) 625653066
E-mail: roberto.blasco.serrano@gmail.com
User avatar
Roberto Blasco
007
 
Posts: 355
Joined: Tue Apr 08, 2008 7:18 pm
Location: Madrid / Spain

Re: "Select Data Provider" dialog on runtime

Postby mboegem » Thu Sep 20, 2018 5:19 pm

Hi Roberto,

No default option, but you can of course get the table, get the columns, create a valuelist and show that.
Don't know exactly what you have in mind, but at least it is possible to expose the columns that way.

Hope this helps
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: "Select Data Provider" dialog on runtime

Postby Roberto Blasco » Fri Sep 21, 2018 11:24 am

Thanks for your answer mboegem.

No default option, but you can of course get the table, get the columns, create a valuelist and show that.
Don't know exactly what you have in mind, but at least it is possible to expose the columns that way.


That's what I am doing :D

The final goal is to add "filters" features in my tables in order to make the clients possible to find any data through fields and relations. With the possibility of grouping that filters and store those groups as custom searchs.

Best Regards. Roberto Blasco.
Un saludo. Roberto.

Madrid - Spain
Tfno: (+34) 625653066
E-mail: roberto.blasco.serrano@gmail.com
User avatar
Roberto Blasco
007
 
Posts: 355
Joined: Tue Apr 08, 2008 7:18 pm
Location: Madrid / Spain

Re: "Select Data Provider" dialog on runtime

Postby mboegem » Fri Sep 21, 2018 3:23 pm

Roberto Blasco wrote:The final goal is to add "filters" features in my tables in order to make the clients possible to find any data through fields and relations. With the possibility of grouping that filters and store those groups as custom searchs.


I don't know the level of knowledge your clients have on databases and/or table structures, but since tables always hold pk/fk and probably one or more other technical fields, I would never expose all columns to my users.
This functionality could have a better UX by creating tables for a data dictionary. In these tables you could store tablenames, column names (with user-friendly labels) and also relations between tables.
Another advantage is that you decide what columns will be available to search on, columns lacking indexes could have poor performance when searching for content.

Just an idea to make things little easier overall.
Although it involves more tables/UI, the possibility to limit the number of columns means you don't have to catch specific errors your clients would make otherwise.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: "Select Data Provider" dialog on runtime

Postby Roberto Blasco » Tue Sep 25, 2018 12:32 pm

Thanks for your answer mboegem.

My "clients" are users of a forensic computer departament, lol :D :D :D

Anyway in my develpment I have done my own dialog showing fields names from a table "table_field_names" where the there is a human readable description of the fields and a check show/not show in a search ...

Best regards. Roberto Blasco
Un saludo. Roberto.

Madrid - Spain
Tfno: (+34) 625653066
E-mail: roberto.blasco.serrano@gmail.com
User avatar
Roberto Blasco
007
 
Posts: 355
Joined: Tue Apr 08, 2008 7:18 pm
Location: Madrid / Spain


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 12 guests