Search Column
Search columns are the Field options for the search query builder. There are five available UI types for the search columns:
  • Date: Date value picker;
  • Lookup: Lookup value picker;
  • Record ID: Exact value match field;
  • Select: Dropdown box;
  • Text: Free text entry;
Common Search Column Attributes
  • Search Form: Parent record;
  • Column Title: Text displayed in the Field dropdown box;
  • Column Type: UI type of the search column;
  • DB Column: Database column name, passed to stored procedure through parameters @field1 and @field2;
  • Display Order: Display sequence in the Field dropdown boxes;
Special Search Column Attributes
Lookup Type
  • Lookup: Reference key to the lookup value picker;
Select Type
  • Host Database: Database where the SelectBox pulls data from;
  • SQL Type: Command type of the SQL Statement, select statement or stored procedure;
  • SQL Statement: Select statement or stored procedure name. For select statement, if it contains string @userId, user login id will be passed to it as a parameter. For stored procedure, the user login id is always passed to it; template to create the stored procedure is like:
    CREATE PROCEDURE [dbo].[prod_name]
    (
    	@userId VARCHAR(50)
    )
    AS
    	SELECT statement ...