Add and Edit Group Item Link Forms
Listing Specific Records with Group Item Links
Use the Group Item Link framework to create links that will allow your users to list specific records without first accessing a Find or Query form. By using DynamicLink.aspx, a Group Item Link can open a set of records filtered by a SQL WHERE clause. When DynamicLink.aspx loads, the the system will automatically redirect to the List page and the WHERE clause will be applied to the results. By using DynamicList.aspx and setting the Query parameter to the key for an existing Query, a Group Item Link can open a List page with the query results. This allows for the use of more complicated WHERE clauses for more advanced filtering and allows your users to specify what data elements they want to display in the results. When DynamicList.aspx loads, the the system will run the Query and display on the List page only those records that met the query conditions.
When your users click on the Forms > List Sub Forms Group Item Link, the List Dynamic Forms page shows only sub forms.
The List Sub Forms Group Item Link form was completed as follows
The specific parameters in the Querystring are
Parameter | Value | Notes |
---|---|---|
ListWhere | dyn_sub_form_flag=1 | The SQL Where clause used to filter the list results. |
DFormKey | 4cdb590a-ed8b-4e42-894c-338cd03d799b | The destination form. |
FormKey | 4cdb590a-ed8b-4e42-894c-338cd03d799b | The List Table setup to display the results. Notice that the parameter value is the same as the parameter value for DFormKey |
When your users click on the List - **Active Events .
Group Item Link, the List page shows only Active Events. The page title shows the name of the Query:The **Active Filter Query Conditions comprise the filter that is applied to the list results.
The List Active Events Group Item Link form was completed as follows
The specific parameters in the Querystring are
Parameter | Value | Notes |
---|---|---|
QueryKey | 8b8652e0-925a-45e8-932e-64ba27c02db8 | The query used to filter the results and determine what data elements are shown. |
Event Details is the name of the form that opens when your users click on one of the Events listed.
DynamicList.aspx or DynamicQuery.aspx?
DynamicLink.aspx is easier to create and deploy, but linking to a Query by using DynamicList.aspx is more powerful because you and your users can specify more advanced filtering and select what data elements to display in the results. If you have only one or two conditions in your SQL WHERE clause, then use DynamicLink.aspx. If your criteria is more complicated, if you want your users to be able to input their own values for the criteria, or if you want your users to control what data is shown on the list results, then use DynamicList.aspx.
Note: From a user experience perspective, take care not to overuse this feature! You might overwhelm your users with links and generate confusion about which links do what. It is best to use this feature only for very frequently used queries.