Versions Compared

Version Old Version 9 New Version 10
Changes made by

kiran.kumari@intellectdesign.com

kiran.kumari@intellectdesign.com

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you are not using the $ALL keyword for the entitlement criteria, use the default source type V and specify the possible values in the SOURCE VALUE column. Ensure to provide the same source values in the OD_USER_FUNCTION_MB table as well. If you specify let's say three source values in the OO_CRITERIA_TYPE_MASTER table but only two in the OD_USER_FUNCTION_MB table, Canvas will filter data respecting the values provided in the OD_USER_FUNCTION_MB table.
For more information on the entitlement criteria, please read the upcoming sections.

VIEW_COLUMN_DEFINITION

...

Info

This table is used by the Canvas framework to store the view level information. The table has been explained just for your understanding.


To create apps in different formats, you have to link the appropriate view to the app in Canvas Studio. The best view for a particular purpose depends on the information the user needs.
When you create a view in Canvas Studio, the details of the view including the entitlement criteria mapping for the view columns/fields gets stored in the VIEW_COLUMN_DEFINITION table. Please note that Canvas currently enables you to define entitlement criteria at the database level only. However, the defined criteria can be mapped to the View columns in the App Designer or Create View Definition screen in Studio. For more information on configuring Views and Apps, refer the App Configuration section in the Expert Studio Dev Guide or the App Designer document available in Unmail > Canvas Technology > Documents > Release 18.1.0.0.
Following is a sample screen shot of the VIEW_COLUMN_DEFINITION table. In this table, the entitlement criterion (for example, LOAN_CRI) is mapped to the column LOAN_TYPE for the CT_LOAN_SUMMARY_VIEW.

...

Column Name

M / O

Type

Purpose

CRITERIA_TYPE

M

String

The criteria type (key) against which the data level entitlement is captured as part of profiling.
For example, LOAN_CRI.

DESCRIPTION

O

String

This is a column provided to the developer for storing any meaningful comment for quick identification of the entitlement criteria. For example, Loan type criteria.
Though this is an optional column, providing a meaningful description of the criteria will help you in future to understand the purpose of the defined criteria.

SOURCE_TYPE

M

String

Indicates how the possible values for the criterion can be fetched. The default source type is V.
Possible source types when the $ALL keyword is used are as follows:

  • V – Product or service values whose data is to be fetched based on the criteria defined. This is the default source type and can be used without the $ALL keyword also.
  • Q – Indicates that the source is the result of a query.
  • C – Indicates that the source is through a Java class.

SOURCE_VALUE

M

String

Provides the actual value corresponding to the source type.
If the SOURCE_TYPE is V, this is the product or service values whose data is to be fetched based on the criteria defined. To provide multiple values separate the values with comma. For example, Home Loan, Personal Loan.
If SOURCE_TYPE is Q, this is the query to be fired. For example, select LOAN_TYPE from LOAN_TYPE_MASTER where LAUNCHED='Y'.
If the SOURCE_TYPE is C, this is the class that should be invoked. For example, com.intellectdesign.modelhouse.LoanTypesEntitlmentProvider.
This source type is recommended if you want to apply some logic to filter data in a scenario or if the source is a Web service, database, Excel file, text file, and so on. There is no restriction with respect to the data source when you use a Java class.

PRODUCT_CODE

M

String

This is the product code that is recognized by Canvas and is used as part of its internal storage of profiles, etc.

SUBPRODUCT_CODE

M

String

This is the sub product under the provided product that is to be used. This is the code that is recognized by Canvas and is used as part of its internal storage of profiles, etc.


OD_USER_FUNCTION_MB

Info

...

This is the default user entitlement table provided by Canvas. You can use your own user entitlement table. However, you must make necessary changes in the EntitlementsHelper class for the framework to read the table.


In this table, the entitlements defined in the OO_CRITERIA_TYPE_MASTER table must be mapped to the user. Following is a sample screen shot of how the entries can be provided in the OD_USER_FUNCTION_MB table:

...