dspConduct

Content WebApp: Examples for dspConduct™ to Call boa (Add/Edit/Delete) Functions

The bit flag “Exists” must always have a 0 or 1 value and depicts if the data already exists in the system(s) of record.

In the examples below, “ControlView” refers to any control view that the WebApp Designer wants to use. These are commonly the Data or Page Control Views that can be generated from the Scenario Role Task Page in dspConduct™.  Refer to Create Tables and Views for Content WebApp Pages Overview for more information.

 

DGE.dbo.apiSecurityScenarioEdit([PageTable].Exists, ControlView.ScenarioID) * DGE.dbo.apiRoleEdit(ControlView.RoleID, ControlView.TaskID)

as boaEdit

 

DGE.dbo.apiSecurityScenarioDel(PageTable.Exists) * ISNULL(DGE.dbo.apiRoleEdit(ControlView.RoleID, ControlView.TaskID), 0)

as boaDel

 

ISNULL(DGE.dbo.apiSecurityScenarioEdit(pt.Exists, dbo.ttRequest.ScenarioID), 0) * ISNULL(DGE.dbo.apiRoleEdit(dcv.RoleID, dcv.TaskID), 0) AS boaAdd