Download IndooGrid module for DNN User Guide

80. Scroll down and click »Update«.
I first row we show the UserID of user who has maximum number of entries in the database.
In second row we are displaying the number of entries of this user. In last row we are also
showing number of entries made by this user but only those who are contained in the grid
(with all grid filters applied).
In module footer we have used two special tokens to retrieve values: <command> token and
[indoogrid:gridViewWhereClause] token. For more information on how to use tokens
please read the »Working with tokens« section of this document.
In last part we will just define default sort order. Normally default sort order can be defined
by checking »Default sort order« checkbox of the column we want to be sorted by default. In
this case we will manually define sort order. The grid will be sorted descending by Date.
81. Click on »Table settings« link.
82. Enter »DateTime DESC« in »GridView ORDER BY part of the sql statement«
textbox.
83. Scroll down and click »Update«.
Forms
In this example we will show how to create simple custom form. It will allow users to
comment our site. First, we will create new table named Comments (if you want to use one of
existing tables, enter table name in »Table (or view)« field and go directly to step 11).
1.
2.
3.
4.
5.
6.
Click on »Table Settings« link.
Click on »Table (or view)« wizard icon.
Select »Create table« radio button and click »Next«.
Enter »Comments« in »Create table name« field.
Enter »ID« in »Unique key column« field.
In first row of the column list enter »userID« in »Column name« field and select
»Integer« in list box.
7. In second row of the column list enter »fullName« in »Column name« field, select
»Text (specific length)« in list box and enter »50« in »Length« field (default value is
MAX).
8. In third row of the column list enter »email« in »Column name« field, select »Text
(specific length)« in list box and enter »50« in »Length« field (default value is MAX).
9. In fourth row of the column list enter »rating« in »Column name« field and select
»Integer« in list box.
28