dinsdag 24 april 2018  |  Inloggen  
postcodestraatplaats
1000AAPostbusAmsterdam
1000ABPostbusAmsterdam
1000ACPostbusAmsterdam
1000ADPostbusAmsterdam
1000AEPostbusAmsterdam
1000AGPostbusAmsterdam
1000AHPostbusAmsterdam
1000AJPostbusAmsterdam
1000AKPostbusAmsterdam
1000ALPostbusAmsterdam
1000AMPostbusAmsterdam
1000ANPostbusAmsterdam
1000APPostbusAmsterdam
1000ARPostbusAmsterdam
1000ASPostbusAmsterdam
1000ATPostbusAmsterdam
1000AVPostbusAmsterdam
1000AWPostbusAmsterdam
1000AXPostbusAmsterdam
1000AZPostbusAmsterdam
1000BAPostbusAmsterdam
1000BBPostbusAmsterdam
1000BCPostbusAmsterdam
1000BDPostbusAmsterdam
1000BEPostbusAmsterdam
1000BGPostbusAmsterdam
1000BHPostbusAmsterdam
1000BJPostbusAmsterdam
1000BKPostbusAmsterdam
1000BLPostbusAmsterdam
1000BMPostbusAmsterdam
1000BNPostbusAmsterdam
1000BPPostbusAmsterdam
1000BRPostbusAmsterdam
1000BSPostbusAmsterdam
1000BTPostbusAmsterdam
1000BVPostbusAmsterdam
1000BWPostbusAmsterdam
1000BXPostbusAmsterdam
1000BZPostbusAmsterdam
1000CAPostbusAmsterdam
1000CBPostbusAmsterdam
1000CCPostbusAmsterdam
1000CDPostbusAmsterdam
1000CEPostbusAmsterdam
1000CGPostbusAmsterdam
1000CHPostbusAmsterdam
1000CJPostbusAmsterdam
1000CKPostbusAmsterdam
1000CLPostbusAmsterdam
1000CMPostbusAmsterdam
1000CNPostbusAmsterdam
1000CPPostbusAmsterdam
1000CRPostbusAmsterdam
1000CSPostbusAmsterdam




About TableDisplay Minimaliseren

Description



This module can display all the records from a predefined database table or custom query on your website as a DataTable. You can select which columns to display and set the default sort order. Options like sorting, paging etc. are available.
The module can also connect to an external database to get data there (MS SQL and MySQL).


Module settings



Connection string:
Input the connection string to connect to an external database. If the external database is MySQL, check the corresponding checkbox first when inputting the connection string. Leave this empty to use the default DNN database. A connection string should look something like this: Data Source=192.168.0.55; Initial Catalog=DotNetNuke; User ID=DnnUser; Password=1A2b3C4d

Source table:
Select the source table to export the records from. If a connection string is entered, the module will retrieve a list of tables from the external database.

Custom query:
Input your custom query here. This will be used to export the data instead of a predefined source table.

Allow sorting:
If enabled, users can click the column title to sort the table.

Display sort direction arrow:
Shows a little arrow indicating the sort direction of the column.

Display export to Excel link:
If enabled, users can click an export link to get the table data into Excel.

Use Paging:
Enable this option to use paging of the rows with the selected number of items per page.

Rows per page:
You can define the number of rows shown per page.






Column Display Settings



Default sort column:
Select the column for the default sort order of the table.

Columns to display:
Uncheck a column if you do not want it to be displayed in the table.






Which version to install



TableDisplay comes in 2 versions. Normal installation and a HostOnly installation because the module does NOT take Portal ID’s into account. This could potentially be a security risk on shared hosting solutions so when the HostOnly version is installed, only Host account users can change the settings of the module.



Tokens



These are the available tokens that can be used in the Custom Query.

[USER_ID]
[USER_USERNAME]
[USER_FIRSTNAME]
[USER_LASTNAME]
[USER_DISPLAYNAME]
[USER_EMAIL]
[PORTAL_ID]
[PORTAL_NAME]
[PORTAL_EMAIL]
[PORTAL_ALIAS]
[TAB_ID]
[TAB_TITLE]
[TAB_NAME]
[MODULE_ID]