Data Table Configuration




The Data Table module allows for the configuration of custom attributes in addition to standard module attributes.


For settings common to all modules please see the modules settings topic.  Settings specific to this module are detailed below.


Settings specific to this module are detailed below:


Rows Per Page: The number of rows of data that can be visible on the module before the paged navigation feature is enabled that allows a user to jump around by clicking page numbers.  The default is zero which disabled paging.

Special Action Text: The name that will appear on a button in the module used to execute a stored procedure named in the Special Action Command attribute.

Special Action Command: This is the fully-qualified name of a SQL Server stored procedure that can process the data in the table or take some other action.  To protect against SQL injection attacks only stored procedures may be used.  The stored procedure itself takes a single parameter, @ModuleID, which can be used to locate the data table contents in the database.  Use of this attribute requires coordination with support staff who will provision and secure the stored procedure. 

Module ID: To assist developers in writing Special Action Command stored procedures the ID of the module is displayed here.


Additionally, users can press the Export button which will generate an XML file that contains the data in the table and download it.  The file can be opened with most text editors and even Microsoft Excel.


Defining Data Tables


Prior to using the Data Table module, the schema for the table must be defined.


Users with Add permissions on the tab can click the  button to open the new column editor.  Users with Edit permissions on the tab can click the  button to edit an existing column.  Be sure to click the  button to save your changes when adding or editing content.  Users with Delete permissions on the tab can click the  button to remove the column from the system and all the data that exists in that column.


The following attributes are available in the editor:


Column Rank: Relative order in which the column will appear

Column Type: Data type of the column.

Column Name:  Name of the column.  May not be blank and must be unique within the table.


Copyright © 2023 pasUNITY, Inc.


Send comments on this topic.