Legacy DB Views generator
- Legacy DB Views generator
- Build database views for bizmodel classes
- PHP 8.0
Recreate database Views as they were before iTop 2.7.0.
Starting from iTop 3.0.0, there is no more Views out-of-the-box, this extension brings them back.
On iTop 3.0.0 and above, this extension creates at Setup one View per class of the Datamodel. The views are identical to those build before iTop 2.7.
On iTop 2.7.0 to 2.7.3 included, this extension restores the Views as they were before iTop 2.7 the out-of-the-box views have some columns badly named
On other version, this extension is useless
Use the Standard installation process as for most extensions.
Views are not performant for tables above 30 000 entries, because they are generic, join every External Key and do this recursively.
If you are facing the above performance issue, create you own views, more specific, doing just the required joins.
What this extension does at every Setup, Move To Production and Move To test:
Delete and rebuild the views according to the latest Datamodel