Hello,
I would like to have a possibilty to offer a user a choice of all fields available in a table. Since not all “fields” are residing in the physical table (calculations and aggregations), I see no way to dynamically retrieve all possible dataproviders.
A method like controller.getDataProviderNames would help a lot in that.
Thanks
Patrick
just curious if you had such a thing what would you do with them?
Do you just want the names? Or also some kind of type information? (db column,calc or aggregate)
I came across that when I wanted to offer a user to dynamically choose a dataprovider (one user wants to see “Sales”, the other “last contact” …). I was able to retrieve the column names but had no access to unstored calculations.
So for a first approach, the names would be sufficient
why don’t you create a valuelist containing the dataproviders names you want to show to the user and use controller.getDataProviderValue(dpName) to retrieve the value?
the thing is that I didn’t want to type in the dataproviders of several tables in a valuelist myself but generate it through a method. That was the original question: can I have access to all defined dataproviders of a table?
not possible, only column names can be retrieved.