Filter Properties

Filter

A string value which is used to filter the content collected. To automatically use content posted to the page, can specify any number of parameters, "%...%", in the filter. If you use a parameter, you set up of the parameter in the Replace Parameters property.

Example (No parameters): [column1] >= 7

Example (Parameters): [column1] = %ID%

The Filter supports the functions listed below. The date functions are all relative to the current date, and can only be used if the filter is defined based on a date field.

•    [me] – The currently logged in user

•    [mei] – Includes the ID of the user along with their display name

•    [meid] – The currently logged in user ID

•    [mmeemail]- The currently logged  in user’s email

•    [meloginname] – the currently logged in user name (domain\user)

•    [today] – Today's date

•    [currentweekstart] – The first day in the current week

•    [currentweekend] – The last day in the current week

•    [currentmonthstart] – The first day in the current month

•    [currentmonthend] – The last day in the current month

•    [currentyearstart] – The first day in the current year

•    [currentyearend] – The last day in the current year

•    [quarter1start] – The first day in the first quarter of the current year

•    [quarter1end] – The last day in the first quarter of the current year

•    [quarter2start] – The first day in the second quarter of the current year

•    [quarter2end] – The last day in the second quarter of the current year

•    [quarter3start] – The first day in the third quarter of the current year

•    [quarter3end] – The last day in the third quarter of the current year

•    [quarter4start] – The first day in the fourth quarter of the current year

•    [quarter4end] – The last day in the fourth quarter of the current year

•    [oneWeekagostart] – The first day of the previous week

•    [oneweekagoend] – The last day of the previous week

•    [twoweeksagostart] – The first day of the week before last

•    [twoweeksagoend] – The last day of the week before last

•    [oneweekfromnowstart] – The first day of next week

•    [oneweekfromnowend] – The last day of next week

•    [twoweeksfromnowstart] – The first day of the week after next

•    [twoweeksfromnowend] – The last day of the week after next

•    [onemonthagostart] – The first day of last month

•    [onemonthagoend] – The last day of last month

•    [onemonthfromnowstart] – The first day of next month

•    [onemonthfromnowend] – The last day of next month

 

Replacement Parameters

XML used to control the collection of Post/Get content from the page for use within the filter.

Default

A string value that will be used if no content is collected from the Get/Post request.

Example

                <Replace>

                                <Item>

                                                <Request>ID</Request>

                                                <Default>1</Default>

                                </Item>

                </Replace>

Request

A string value that represents the Get/Post request name used to access content from the query string or host header.

Sort

Used to sort all content collected before it is rendered.

Example: Column1 ASC, Column2 DESC