DNN Custom Forms by OnyakTech
OnyakTech Custom Forms DNN Module
by OnyakTech

Custom Forms Search Plugin

The Search Plugin uses the values entered into your form to search the data you define and display the results in a data grid with an optional popup displayed for row details and Google Map information. The Search Plugin also includes an optional Export feature to download the results to the users computer.

Search Plugin Settings in Display Setup

These are the Search Plugin settings in Display Setup. In order to use the Search Plugin you must add the SEARCH button token [SEARCH::Text=Search] to your form and configure these options in Display Setup.

Direct Main Search Table/View : Table or View that contains the data you will search on. Column names must match control names in your Form.

Direct PopUp Table/View : Enter the table name or View that contains the data to be displayed when a user clicks the "View Details" button for a specific row in the search results.

Direct Export Table/View : Enter the table name or view that contains the data to be exported when the user clicks the button to download the results. The data is filtered based on the search.

Direct Primary Key: Enter the primary key or unique value for the data that will be searched. :

Connection String : Leave empty to use the DNN database connection or if you will be referencing the database objects through code (ex: select * from asmn.dbo.vsASMNMainSearchView). If you leave the connection string empty then the solution will use the existing DNN connection string.

Display Columns : Indicate the column names to be displayed delimited by a semi-colon. Example: Column1;Column2;

Pop-Up Columns : Indicate the column names to be displayed delimited by a semi-colon. Example: Column1;Column2;

Export Columns : Indicate the columns names to be exported to Excel delimited by a semi-colon. Example: Column1;Column2;

Detail Template : Template content to use when rendering the detailed view of the data on row click. Surround data column names with brackets (as tokens) to indicate where information should be displayed.

Alternate Search : Alternate Search will execute a different SQL statement if the control name you specify here is a checkbox and is checked when the user submits the search query on your form.

Alternate Search Table : When Alternate Search is enabled this is the Table or View that will be searched.

Alternate Search Columns : Indicate the column names to be displayed for the alternate execution delimited by a semi-colon. Example: Column1;Column2;

Search Reslut Limit : Set to -1 to return all results. Set to a positive value to limit the number of records returned from search.

Map Location : Location is set by using tokens from your data. Example: [Address] [City], [State]

Map Title: This is the text to be displayed in the title of the marker when clicked. You can use data tokens in this value.

Map Content: This is the content of the marker when clicked. You can use data tokens in this value. [OWNER] - [CITY] [STATEPROVINCE], [COUNTRY]

Search Plugin Screen Shots