ADMINEDITABLE_Search_Search

 Show all Hide all

Deprecated.

From version 5.4.019 this editable procedure will not be called automatically. Instead of using it, you write your own procedure and put the name of the procedure in the application variable "SavedSearchSearchProcedure".

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 he can see.

Type: Stored procedure
Area of use: Editable

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

Repeat mode: 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
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

Repeat mode: repeated exactly once
Row count: exactly one row

Columns:

RowCount mandatory int
Row count