Sidebar

Combodo

iTop Extensions

Legacy DB Views generator

name:
Legacy DB Views generator
description:
Build database views for bizmodel classes
version:
1.0.0
release:
2020-12-21
itop-version-min:
2.7.0
code:
combodo-views
state:
Stable
php-version-max:
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.

Features

  • 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

Revision History

Version Release Date Comments
1.0.0 2020-07-08 First version

Installation

Use the Standard installation process as for most extensions.

Limitations

  • 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.

Usage

What this extension does at every Setup, Move To Production and Move To test:

  • Delete and rebuild the views according to the latest Datamodel

Legacy View

This is the way iTop Views should look like for the class Person

Buggy views

This is the way views look like with an iTop 2.7.0 to 2.7.3 included:

The column names on Blob are different:

extensions/combodo-views.txt ยท Last modified: 2022/12/20 12:08 (external edit)
Back to top
Contact us