Servoy Forum

Hi all.

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

Best regards. Roberto Blasco.

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

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

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.

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.

Thanks for your answer mboegem.

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

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