I created a view from SQL and I noticed that contrary to a view from Filter I do not have the ability to filter the records with the filtering mechanism present for example in the classes. I had to create a view from SQL because I need the info of n tables in JOIN between them. How can you filter a view from SQL? Is there an alternative method? In version 3.0 will this limitation be exceeded? Thanks a lot.
Good morning.
To "compose" the join logics of the SQL view with the filtering logic of CMDBuild we should implement a generalized and very sophisticated mechanism for parsing and automatic writing of SQL code.
This is not possible in CMDBuild 2.x and will not even be possible in CMDBuild 3.x.
In a CMDBuild 3.x version after 3.0 and 3.1 it will be possible to define joins visually in the filter views, and in this case it will also be possible to apply filters.
CMDBuild Team
1 Like