question

rakeshjadhav80 avatar image
rakeshjadhav80 asked

Get Details from dynamic table fields in a View

Every time a new field add from UI, it creates a new table, column, and value in that table. All metadata capture in a static table 'DYM_Data' I want to develop a view that can give all dynamic fields details. Example: Add a new field Headphone then new table will be created as tbl_headphone and column will be column1. After that value will be added to that table in column1 If adding headphone as a dynamic field with value as 'ABC' DYM_Data - table structure for metadata ------------------------------------------------------- table name | field name ------------------------------------------------------- Headphone | column1 -------------------------------------------- Headphone -- table structure for dynamic table ------------------------------------------------------- column1 ------------------------------------------------------- ABC Is it possible or any workaround would be helpful
queryviewdynamic-sql
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

"Every time a new field add from UI, it creates a new table, column, and value in that table." This isn't going to be a good database to work in! Let's say headphone is a product and then you have 1000 products, that's a lot of tables! Rather than building a view that queries all these tables, I'd suggest looking at creating a properly normalised/ OLTP database and you'll then reap all the benefits that come with it.
1 Like 1 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.