This is a filter option where the resource can customize the view of the activities in the activity list. The criteria can be saved as a query and it retrieves data from SWActivityList table based on the search criteria.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Unique identifier which identifies the search list |
|
SAVELISTNAME |
NVARCHAR |
200 |
|
|
Y |
Name by which the criteria are saved |
|
VIRTUALUSERID |
INTEGER |
4 |
|
|
Y |
Id of the resource which maps SWVirtualUser table |
|
SAVEQUERY |
NVARCHAR |
1000 |
|
|
Y |
The criteria are saved as a query string which takes data from the Activity list. |
|
DATETIMESEARCH |
NVARCHAR |
50 |
|
|
Y |
Date and time on which the search criteria is created |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated time of the search list |