Creating a named session

You can use macros to create named database sessions within which copies of related session assets are stored for the life of the session. This enables multiple users to interact with session assets at the same time without negatively impacting system performance.

  1. Add a macro to your app.
  2. Add a Check Named Session Exists action to the macro:
    1. In the Layout Designer pane, in the Projects section, select the macro.
    2. In the Logic Objects section, drag the Check Named Session Exists action onto the design surface.
    3. In the Check Named Session Exists Properties dialog box, on the Configure tab, type a name for the session that you will create.
    4. Click OK.
    5. Link the Start icon to the Check Named Session Exists action.

  3. Add a Start Named Session action to the macro:
    1. In the Logic Objects section of the Layout Designer pane, drag the Start Named Session action onto the design surface.
    2. Link the Check Named Session Exists icon to the Start Named Session icon.

  4. Make the link conditional so the action runs only if the session doesn't already exist:
    1. Click the link connecting the actions, and then click Edit the Link.

    2. In the Link Properties dialog box, for label, type a label to indicate that this conditional path through the macro will run when the session doesn't exist. For example, "Session doesn't exist".
    3. For Condition, choose Custom Condition.
    4. In the statement editor, click , and in Global Parameters, choose @@result.

    5. Click , and in Operators, choose =.

    6. Click , and in Parameters, choose Add Parameter or Constant.
    7. In the Parameter Setup dialog box, for Parameter Type, choose Constant Value.
    8. For Data Type, choose Integer.
    9. For Value, type 0.
    10. Click OK.

    11. Click OK to close the dialog box.

  5. Add a technology action to run a model or a Data Guru project:
    1. In the Technology section of the Layout Designer pane, drag an action onto the design surface.
    2. In the action properties dialog box, on the Configure tab, specify the connection.
    3. For Scope Type, choose Named.
    4. For Scope Name, specify the name of the session.
    5. Adjust other properties, as necessary.
    6. Click OK.

      While this topic shows how to run a technology action in a named session, designers can run any action that is needed, such as the Update or Insert actions.
  6. Link the Check Named Session Exists and the technology actions.

  7. Make the link conditional so the action runs only if the session already exists:
    1. Click the link connecting the actions, and then click Edit the Link.

    2. In the Link Properties dialog box, for label, type a label to indicate that this conditional path through the macro will run when the session already exists. For example, "Session exists".
    3. For Condition, choose Custom Condition.
    4. In the statement editor, click , and in Global Parameters, choose @@result.

    5. Click , and in Operators, choose =.

    6. Click , and in Parameters, choose Add Parameter or Constant.
    7. For Data Type, choose Integer.
    8. For Value, type 1.
    9. Click OK.

    10. Click OK to close the dialog box.

  8. If you want to record when an action is executed or send notifications, add Log Event or Notification actions to the macro.

  9. Click Save.
  10. Add an event to an app board or widget to run the macro.
  1. Add a macro to your app.
  2. Add an End Named Session action to the macro:
    1. In the Layout Designer pane, in the Projects section, select the macro.
    2. In the Logic Objects section, drag the End Named Session action onto the design surface.
    3. In the End Named Session Properties dialog box, on the Configure tab, type the name of the session that you will use the macro to end.
    4. Click OK.
    5. Link the Start icon to the End Named Session action.

  3. Click Save.
  4. Add an event to an app board or widget to run the macro.

Last modified: Friday May 12, 2023

Is this useful?