Parameters example 1

These parameters can be added directly to the query in Example 1:

  • page.property.userGroupId
  • page.property.userId
  • page.property.employeeId

Example 1

source='SELECT DISTINCT VWT.WBT_ID, VWT.WBT_NAME, VWT.WBT_LOC_NAME,
VWT.WBT_LOC_DESC FROM VL_WORKBRAIN_TEAM vwt, (SELECT DISTINCT WBT_ID
FROM sec_workbrain_team WHERE WBU_ID = #page.property.userId#)'