Solved

Database View - UIV?

  • 22 November 2019
  • 2 replies
  • 855 views

Userlevel 5
Badge +10

Hi

We understand a view ending in _CFV is a custom field view used when we’ve customised a screen or table. However we see views with uiv_cfv. 

Does anyone know the difference and what these views are for?

A quick look of the construct of the view doesnt show any obvious differences.

Regards

Shaun

icon

Best answer by Savinda Suvimal 22 November 2019, 11:45

View original

2 replies

Userlevel 5
Badge +11

Hi,

There are 3 types of views in IFS Application

  • Base
  • Alternative
  • Report

Base:

Usually, the base view is the view that fetches all the columns. If we have a table ABC_TAB, then the base view will be ABC. The base view doesn't have any conditions it is just select data from the table.

 

Report:

These views are connected to reports in the IFS Application. Any view created using a table or joining table and views with the name like _REP will be a report type of view.

 

Alternative:

Views created by adding new columns, conditions or joining multiple tables/views will put into this category. Custom field views _CVFand other views ending with _UIV, _PUB, _BI, _LOV, _LIST, etc; will be considered as an alternative view. Becuase these views are usually created to achieving specific functionalities. 

Userlevel 6
Badge +15

UIV views are special user interface views which are created for pages where the usual view can’t be used. 

When a view is enabled for custom fields/attributes, a new view is created with _CFV (Custom Fields Views). 

So if you enable a _UIV view for Custom, the resulting view will be suffixed with both hence the _UIV_CFV

Reply