Skip to main content
Solved

Database View - UIV?

  • November 22, 2019
  • 2 replies
  • 1073 views

Forum|alt.badge.img+11

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

Best answer by Savinda Suvimal

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. 

View original
Did this topic help you find an answer to your question?

2 replies

Savinda Suvimal
Hero (Employee)
Forum|alt.badge.img+11
  • Hero (Employee)
  • 73 replies
  • Answer
  • November 22, 2019

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. 


chanaka-shanil
Superhero (Employee)
Forum|alt.badge.img+15
  • Superhero (Employee)
  • 165 replies
  • November 25, 2019

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings