Versions Compared

Version Old Version 12 New Version Current
Changes made by

kiran.kumari@intellectdesign.com (Unlicensed)

Ravikumar Babu CTOO (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Removed references to legacy app/view screens.

...

For the descriptions of the three source types that can be used for the $ALL keyword refer source type and source value fields.
Note: When new products or services get added or removed, ensure to update the source values against the entitlement criteria in the OO_CRITERIA_TYPE_MASTER table. This is a mandatory step when the $ALL keyword is used for the entitlement criteria. 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.

...

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.0refer Designing Apps using App Designer.

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.

Image Removed Image Added

OO_CRITERIA_TYPE_MASTER

Info

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

...

Following is a sample screen shot of how the entries can be provided in the OO_CRITERIA_TYPE_MASTER table:

Image RemovedImage Added

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.

...


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:

Image RemovedImage Added

Column Name

M / O

Type

Purpose

OD_USER_NO

M

String

Unique ID provided to the user.
Example, 201206000010

OD_ACC_NO

M

String

Product or service values whose data is to be fetched based on the criteria defined. Example, Home Loan.
Note: You cannot provide multiple values with comma separation in this column. You will have to add a row to specify the possible values for the defined entitlement criteria.

CRITERIA_TYPE

M

String

In this column, specify the entitlement criteria to be respected for the view fields/columns in App Designer or Create View Definition screen in Studio.

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

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

...