Search Form
A search form consists of a query builder to accept search criteria and a grid view to present the search result. Search Columns are database columns end users can search into; Search In dropdown is an additional search filter for the query builder. Grid view in a search form is the special grid view that its parameters are configured to accept data from query builder. The search logic is built in the grid view's SQL Statement. Logicweb Studio comes with a useful T-SQL function to assist you to build the dynamic SQL in search stored procedure:
[dbo].[lwfnSearchCondition]
For code example, see stored procedure lwspSearchUserObjectView. The best way to link a search form into application main page is through a module's navigation bar.
Search Form Attributes
  • Title: Name of the search form;
  • Reference Key: Reference key to this search form; it must be unique for each search form;
Search In SelectBox
This section configures a SelectBox as an additional search criterion. It also informs the end user what he or she is searching for.
  • SQL Type: Type of the SQL Statement: Select Statement or Stored Procedure;
  • Parameter: Indicate if the login user id (@userId) is used by SQL Statement;
  • Default Value: SelectBox's default value;
  • SQL Statement: Select statement or stored procedure name;
Grid view Settings
  • Grid View: Grid view to present search result;
Search Columns
  • List of the search columns.