This module requires specific configuration prior to use in the Module Settings editor. Please see the Web Query Configuration page for configuration instructions.
This module functions outside the realm of the normal permissions hierarchy. It can be viewed only by a user with membership in Site Administrators site-level roles with no regard to permissions assigned to the tab on which the module is placed. For more information on the roles referenced in this section please see the role based security topic. Administrative users can configure additional module settings by clicking the button.
•SQL Script: This is the Transact-SQL syntax to submit to the server. Any valid SQL statements can be issued but the code will not recognize the batch terminator keyword GO in the script.
•Wrap Cell Contents in Results: When checked cell contents can wrap. The default behavior is to not wrap which may cause the results to scroll very wide.
•Use Integrated Security: When checked the hosting credentials for the interactive user will be used instead of the application pool identity (which is very low powered with extreme limitations).
•Encode Results: When checked the contents of any results will be HTML encoded prior to display to prevent HTML markup in the results from being displayed or scripts from being executed.
•Allow Sorting: When checked the user can sort the results of any data table returned by clicking column names in the data table.
Copyright © 2023 pasUNITY, Inc.
Send comments on this topic.