Type:
Stored procedure
This is the underlying procedure for the grid that lists saved searches.
You can edit it to control what searches a user is allowed to use, and what columns they can see.
Parameters
@MenuItemId
mandatory
int
Show only searches belonging to this menu item.
@OrderBy
mandatory
varchar
@SearchGroupId
mandatory
int
Show only searches belonging to this search group.
@UserIdSearching
mandatory
int
User viewing the grid.
Resultsets
Resultset: Grid data
Table count:
repeated exactly once
Row count:
zero or more rows
Columns
CanDelete mandatory bit
If user is allowed to delete search.
CanEdit mandatory bit
If user is allowed to edit search.
SearchId mandatory int
The search ID.
SearchName optional string
Name of saved search.
UsernameFull optional string
Name of user who saved search.
xxx optional string
Add as many extra columns as you need.
Resultset: Row count
Table count:
repeated exactly once
Row count:
exactly one row
Columns
RowCount mandatory int
Row count