BASIC HELP : MS4BI Designer by MS4script   
   2021 version 1       

INPUT QUERY

Definition

To declare a variable for querying a database (SQL) using a selection from a list of possible values

Query cycle: depending on the SQL command in the Query or Formula dialogue box

Constraint: only 1 Input Query cycle per transaction

Syntax

  	
	     <InputQuery  : type="text or number.."  name="name..var" like : table("name.. table")  class=standardMs4  placeholder="please select-MONTH-"   >; 
   	

KEYWORD :
BEGIN_FORM inputQuery...Submit()... END_FORM

  	
Begin_transaction ; nameTRS  
  cycle : query table xxxx .. 
  begin_form  
    inputQuery  var1 ..InputQuery var2..submit
   End_form ; 
       Chart or dashboard or image or grid....
  End_transaction ;  

Method and Settings option

DRAW INPUT + DECLARE

PROCESS

Example 1

  	   
 Begin_TransactionWeb : "75-InputQuery" , 
    Cycle :  
   Query : table "people" ;  
Begin_FormWeb ** QUERY  
  position:2442,313,53,187 :   <InputQuery:    type="text"    IDname="NAME"    like : table("people")  class=standardMs4   >; 
  position:2534,314,35,190 :   <InputQuery:    type="text"    IDname="FIRSTNAME"    like : table("people") class=standardMs4   >; 
  position:2608,316,43,194 :   <InputQuery:    type="text"    IDname="SEX"    like : table("people")  class=standardMs4   >; 
  position:2649,208,83,157 :    <InputQuery:    type=SubmitForm()      class="btn btn-lg btn-warning"   attrib="value='Submit Query' "  >; 
End_FormWeb ;
   ....	
 

IMPLEMENTATION