Qommentary
Qommentary Writeback
Qommentary Writeback
  • Welcome
  • Getting started
  • Setting up a connection
  • Defining a primary key
  • Adding data to your table
  • WORKING WITH INPUT DATA
    • Adding input columns
      • Text
      • Number
      • Checkbox
      • Dropdown
      • Rating
      • Color picker
      • Date picker
      • Switch
    • Conditional input control
    • Saving and reverting
  • Writeback Actions
    • Refreshing data
    • Clearing data
    • Reloading data
    • Exporting data
  • Bulk updates
    • Single Column
    • Advance Bulk
  • CUSTOMIZATION
    • Table settings
    • Themes
  • Share
    • Sharing data with your team
    • Customizing email template
  • Advanced
    • Audit Trails
      • File audit trailing
      • Database audit trailing
        • SQL Server example
    • Concurrency
  • Support
    • Submit a ticket
Powered by GitBook
On this page
  • Enabling app reloads
  • Reload triggers
  • Reload types
  • Reload security rules

Was this helpful?

  1. Writeback Actions

Reloading data

PreviousClearing dataNextExporting data

Last updated 2 years ago

Was this helpful?

The Qommentary Writeback extension allows you seamlessly reload writeback data and update your application in real-time.

There is 3 ways of reloading data:

  1. Triggering reloads manually using Qommentary Writeback

  2. Triggering reloads automatically when you save data using Qommentary Writeback

  3. Setting up a reload Task using the QMC

If you wish to trigger reloads using the Qommentary Writeback extension, first you need to enable app reloads.

Enabling app reloads

1. Edit your sheet 2. Expand the Reload section

3. Click on the switch control to Enable app reload

Reload triggers

When app reload is enabled, saving data will automatically trigger an application reload.

If you wish to disable automatic trigger and allow users to manually reload the application when desired, please follow these steps:

1. Edit your sheet 2. Expand the Reload section

3. Click on Manual button

A Reload app button will now be visible in the actions bar:

Reload types

When reloading writeback data, there's two (2) types of data reloads: partial and full.

By default, a partial application reload is executed. A partial reload keeps all tables in the data model and then executes only Load and Select statements preceded by an Add, Merge, or Replace prefix.

If instead you wish to execute a full application reload, just check the Full option:

Reload security rules

By default, Qlik Sense users do not have permission to trigger application reloads. To ensure a seamless user experience when working with Qommentary Writeback, security rules need to be setup granting users permissions to access the load script on the published application.

In order for this feature to function correctly, users will need access to all data connections used in the application.

Reload Access Writeback (App)

Name

Reload Access Writeback (App)

Resource filter

App_*

Actions

Read, Update

Conditions

resource.stream.HasPrivilege("read") and user.roles="WritebackUser"

Reload Access Writeback (App Script)

Name

Reload Access Writeback (App Script)

Resource filter

App.Object_*

Actions

Read

Conditions

resource.app.HasPrivilege("read") and resource.objectType = "app_appscript" and user.roles="WritebackUser"