Adding contexts

Contexts can only be added from a database level.

To add a new context, you need to execute the following scripts on a PostgreSQL BI Point database.

INSERT INTO rb."Contexts" ("CTX_Name") VALUES ('ContextName')

INSERT INTO rb."Parameters" ("PAR_Name") VALUES ('ParameterName')

INSERT INTO rb."ContextsParameters" ("CTP_ContextId","CPT_ParameterId") VALUES (1,1)

INSERT INTO [RB].[ContextsMappings]([CTM_ContextId],[CTM_ContextMapping],[CTM_MappingName])
VALUES (1,'ExternalContextName','ContextName')

After you execute the above code, the NewContext will be visible. The API will use the name ExternalContextName. You can optionally add translations for conexts:

INSERT INTO rb."ContextTranslations" ("CTL_Id", "CTL_ContextId", "CTL_LocaleId", "CTL_Translation") VALUES (1, 1, 'en-EN', 'Sale')

Czy ten artykuł był pomocny?