...
- Caption (required): The caption for the view.
- Entity (required): The name of the entity whose records will be displayed in the view.
- View Type (required): You can either load an existing view (View ID) or specify a SQL statement to define a temporary view (SQL View). This property defaults to SQL View.
- NewRecordParameterString: An administrator can configure this property to automatically populate fields in new records opened from within a list view. The format for passing new default values is as follows:
- PARAMS(FieldName1=Value1|FieldName2=Value2|FieldName3=Value3...)
- For example, to pass in the ID from the current record into the SampleServiceID for a new record in the related entity, you would enter -PARAMS(SampleServiceID=<%ID%>) as this property's Source.
- Note that the FieldName corresponds to fields in the entity whose records appear in the view. To specify multiple fields, separate the field/value statements with a vertical bar.
- If you want to pass in values from the current record, enclose the current record's field name with greater than/less than symbols and percentage signs.
- For example, if the related entity whose records are displayed in the view has a SampleServiceID field, the following string passes in the Sample Services record's ID when you open a new record from the view on the Sample Services form: PARAMS(SampleServiceID=<%ID%>)
- For example, if the related entity whose records are displayed in the view has a SampleServiceID field, the following string passes in the Sample Services record's ID when you open a new record from the view on the Sample Services form: PARAMS(SampleServiceID=<%ID%>)
- SQL: If you set View Type to SQL View, specify the SQL statement (including any applicable WHERE clause) to define a temporary view.
- ViewID: If you set View Type to View ID, enter the ID of the view that will be placed on the form.
- FilterSQL: If you are placing an existing view on the form (that is, View Type is set to View ID), you can use this property to filter the results of the view to display a sub-set of the records. The string that you enter for this property is appended as a WHERE clause to the selected view's SQL statement. Typically, you will use this property to display only the records in the related entity that are linked to the current record. For example, if a SampleLinks entity has a SampleServiceID field, you can add an existing list view of the SampleLinks entity to the SampleServices form. To filter the list results to display on those SampleLinks records linked to the current SampleServices record, you would enter SampleServiceID = <%ID%> as the Source for the FilterSQL property, as shown below.
- Enable Paging: Sets the paging behavior for the view. The default value is True enabling paging.
- Page Size: The number of records per page, when paging is enabled. The default value is 250.
- LabelCaptionCultureString: This string specifies the culture string used to localize the caption. For this input property, specify the base string for the applicable Culture String record. See "Working with Culture Strings" in the Admin Guie for for more details.
