           BASIC HELP : MS4BI by MS4script   
   2022 version 1.10

Chapter 9: DIALOGUE FILTERS

KEYWORD : MS4_DIALOGFILTERS

CALL:FUNCTION

Definition
Calls a function within an MS4 script, creates a Windows query dialogue to select filters: fields and values are passed as an argument to the function by export to a display function: query, report..

Syntax 1

  
MS4_DIALOGFILTERS (  title :  " literal  your title  ")	
	 CALL:FUNCTION( MS4_script_name)
	  EXPORTING : DBNAME
	  EXPORTING : TABLE NAME
	  EXPORTING : VarSqlPredicat

Example INPUT : 3 output arguments

INPUT + CALL 1 : MS4_DIALOGFILTERS

The arguments that will be passed to the display function : the first 3 arguments are
MANDATORY

1st argument : The database
2nd argument : The table or view as loaded and filtered in the query
3rd argument : the sql script output by the query dialogue, filtered as per input

INPUT + CALL 1 : MS4_DIALOGFILTERS

Example OUTPUT : 3 input arguments \MandragorePlanete\MS4BI\zInclude\Call\function\ModelFilters_QueryOption.ms4

       	
#include  "#SYSPATHMS4BI+\zInclude\includeChart.h"
integer : no :=0, yes :=1;
Char :   zCube :255 ,zView:255,zSqlPredicat:1024;
 

GetInputArgument(1:zCube); 
 GetInputArgument(2:zView);
  GetInputArgument(3:zSqlPredicat);
   
 
DBconnect{ms4DB}(zCube);
	Ms4_Query: Web{ms4DB} Option  : 
		BEGIN 
           	Style :$BLACK ,
		 	height :1050,  
            pagesize:40,
 		 	ColumMenu :yes,
		 	Pageable  :yes,
		 	Resizable :yes,
		 	Sortable :yes,
			 ViewResult:yes,
	        filterable:yes 
		END  
        ("%s",zSqlPredicat);
 
Sql_DestroyEnv();

Example OUTPUT

OUTPUT + CALL + ARGUMENT : QUERY (for example)

Syntax 2

  
MS4_DIALOGFILTERS (  title :  " literal  your title  ")	
	 CALL:FUNCTION( MS4_script_name)
	  EXPORTING : DBNAME
	  EXPORTING : TABLE NAME
	  EXPORTING : VarSqlPredicat
	   EXPORTING FiltersField : "VarName1" ,  yes(1) or no(0) (input value : mandatory = yes else no) 
	   EXPORTING FiltersField : "VarName2" ,  yes(1) or no(0) (input value : mandatory = yes else no)

Example INPUT : 5 output arguments

INPUT + CALL 2 : MS4_DIALOGFILTERS

The arguments will be passed to the display function : the first 3 arguments are
MANDATORY

1st argument : The database
2nd argument : The table or view as loaded and filtered via the query dialogue
3rd argument : the sql script output by the query dialogue, filtered as per input
4th, 5th...arguments are the selection variables from the FILTERS dialogue box

INPUT + CALL 2 : MS4_DIALOGFILTERS

Example OUTPUT : 4 input arguments \MandragorePlanete\MS4BI\zInclude\Call\function\ModelFilters_ReportDesignLevel3

       	
 
float    :  totalPercent  dec(2);
Char     :  formaNum1:128,formatotalEdit:128,formatotalLevel:128,formatotalpercent:128, filestylecss:255;
INTEGER  :  Totalorders,TotalEmployee,totallevelNum,Sql_totalOrderId;
 Char :   zCube :255 ,zView:255,zSqlPredicat:1024,zField1:255;
 Text :    LpathMgPlanete;

GetInputArgument(1:zCube); 
GetInputArgument(2:zView);
GetInputArgument(3:zSqlPredicat); ** no need for this example!! 
GetInputArgument(4:zField1);
          	
          DBconnect{Ms4DB}(zCube);
          Ms4_query{ms4db} option : into  $MS4DBTMP 
 	("SELECT   DISTINCT a.orderID ,a.employeeid,a.LastName , a.CustomerID , a.ShipName, " +
        " a.ShipAddress,a.ShipCity,a.ShipRegion,a.ShipPostalCode,a.ShipCountry" +
        "   from  [%s] as a  where a.employeeid in(%s)  ",zView,zField1) ; 
  		Sql_DestroyEnv();
   
  GetDirSysPathMS4BI(LpathMgPlanete);
  Concatene  LpathMgPlanete,"\zInclude\css\StyleReportDesign\standardStyleReport.css" into fileStyleCss;
 
** ****************************************
** REPORT
** **************************************** 
 DECLARE SCHEMA_REPORT  :   ReportDesign 
 	{      integer : EmployeeID  ,OrderID    ;
           TEXT   :   LastName ,  CustomerID , ShipName, ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry ; 
        }  ;
Begin_Report 
  REPORTINPUT :  DBconnect { Ms4DB} ($MS4DBTMP) use View  ($ms4ViewDBtmp)    
  REPORTFORM:DESIGN  
  Group    Order   by  :  ReportDesign.EmployeeID 
                
 LinkCss :   fileStyleCss

Start_Design :
** ******************************
Report_Header 
 	Print  : "  ( update style Css : \MandragorePlanete\MS4BI\zInclude\css\StyleReportDesign\xxxxxxxxxxxx.css) " ;
  	
End_Report_Header 

Group_Header     : 01 ** level : 01 ,02,03 etc..
	 Print TD : " HEADER GROUP LEVEL :  
  ", $Level ," Employee ..:", ReportDesign.EmployeeID , ReportDesign.LastName;
 
END_Group_Header   


DETAIL ....
 
End_Report ;

Example OUTPUT

OUPUT + CALL + ARGUMENT : REPORT DESIGN (for example)

Prerequisites
All of the scripts must be located in the MS4BI system directory :
driver:\MandragorePlanete\MS4BI\zInclude\Call\function

Remarks
Examples : DRIVER:\\MandragorePlanete\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\21-FILTERS
Arguments are handled by the script that is being called.
See (without fail) GETINPUTARGUMENT..
Declare argument variables (CHAR,TEXT..)
Returns the variables content in the same order as CALL/EXPORTING 1, EXPORTING 2
The function name in the CALL is the name of the MS4 script in the directory:\MandragorePlanete\MS4BI\zInclude\Call\function **

See Also
GETINPUTARGUMENT , CALL:FUNCTION..

Interested in joining us? contact@mgplanete.com
The Mg Planete team

the official sites :
mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
ms4script.com

Download

official site :
getms4bi.com

Our purpose : Keep it simple !

written with ms4script

help 01.010.2022.8

MS4BI HELP 2022

Designer

BASIC HELP : MS4BI by MS4script

Chapter 9: DIALOGUE FILTERS

KEYWORD : MS4_DIALOGFILTERS

CALL:FUNCTION

Definition

Syntax 1

Example INPUT : 3 output arguments

INPUT + CALL 1 : MS4_DIALOGFILTERS

MANDATORY

INPUT + CALL 1 : MS4_DIALOGFILTERS

Example OUTPUT : 3 input arguments \MandragorePlanete\MS4BI\zInclude\Call\function\ModelFilters_QueryOption.ms4

Example OUTPUT

OUTPUT + CALL + ARGUMENT : QUERY (for example)

Syntax 2

Example INPUT : 5 output arguments

INPUT + CALL 2 : MS4_DIALOGFILTERS

MANDATORY

INPUT + CALL 2 : MS4_DIALOGFILTERS

Example OUTPUT : 4 input arguments \MandragorePlanete\MS4BI\zInclude\Call\function\ModelFilters_ReportDesignLevel3

HEADER GROUP LEVEL :

Example OUTPUT

OUPUT + CALL + ARGUMENT : REPORT DESIGN (for example)

Prerequisites

Remarks

See Also

Copyright 2022 by Mandragore Planete

Download

Our purpose : Keep it simple !

MS4BI in 5 minutes