"*" select in the table should replace *in the select query with column names.
I have some selected fields in the XML to generate metadata. While designing the query, if I use * selector for the query, it fetches all column from the database.
Instead, on selecting *, I want to put the column name list in the query. So the user does not get all the columns from the database. Only the columns that are in the design query pane, gets fetched
I don't want to run a loop. Is there a function / option that will replace * with output columns.
I tried QueryTransformer .AlwaysExpandColumnsInQuery = True. Even after selecting all the columns, if I click * it adds all the columns again. Let me know how to avoid this
Is there a way to disable / hide the * option in the table.
Looking forward to your reply.
This is possible using the QueryBuilder.DataSourceFieldAdded event. I will provide the sample tomorrow.
Meanwhile, you can review the QueryUIEventsDemo project included in the installation project and available on the GitHub.