Field Query Options
Note: Field Query Options is available for Super Users and users in the Administrators Role only.
- Connection String: The connection string is optional, and when left blank the Query Engine will use the default DotNetNuke Connection string defined in the Web.Config. The Query Engine will accept any Valid Connecton string which is Suported by ADO.NET. ConnectionsStrings.com is a great resource for connection string syntax. Connection Strings are Encrypted when stored for later use hiding any login information which might be used. It is advised that when defining a connection string with login information, the login be allowed only the premissions requred to execute the Query.
- SQL Query: This is where the Query is Entered. Execution of Stored Procedures is supported. Writing Queries and Structured Query Language usage is beyond the scope if this user guide.
- Query Tokens: Replacable Tokens from Membership can be used in Queries. Place the cursor where the Token should be inserted in the Query, Select the Token, and click on the "Insert Token" button. Tokens must be used Unchanged to work. Session and URL variables can also be used in the Query and can be inserted from the Query Tokens Dropdown List the Syntax is: #URL:YOURURLPARAMETERNAME# and #SESSION:YOURSESSIONPARAMETERNAME#
- The Query Engine will display the results of the Query or an Error Message when "Test Query" is clicked as shown in the Grid of Frequencies
- Text Column: When using a List Item type Control, the Query Column name is entered here which will be the data shown to the user
- Value Column: When using a List Item type Control, the Query Column name is entered here which will be the data used for the Value part of the List Control
- Test Query: Click this Link to test the Query entered in the "SQL Query" field.
See also