Innov-AI
    Documentation | MentDB Weak Server
Generate MQL to PARSE_AND_ACTION on table

  • To generate MQL to PARSE_AND_ACTION on table:
  • Right click on the table 'apps' and select 'GEN HANDLE > PARSE_AND_ACTION'
  • script create exe "MENTDB.apps.parse_and_action" false 1
      (param
      )
      "Execute MQL action on the table 'apps'."
    {
    	
    	try {
    		
    		#Connection ...;
    		sql connect "session1" {cm get "MENTDB"};
    		
    		-> "[json_result]" (sql parse "session1" "T" (concat 
    			"SELECT  
    				app_id,
    				title
    			 FROM public.apps
    			 LIMIT 0, 100;") {
    			
    			#Here the fields ...;
    			[T_app_id];
    			[T_title];
    			
    			#Here your MQL code ...;
    			
    		
    		});
    		
    		#Disconnection ...;
    		sql disconnect "session1";
    		
    		# Return the json;
    		[json_result]
    		
    	} {
    
    		#Close the connection;
    		try {sql disconnect "session1"} {} "[sub_err]";
    
    		#Generate an error;
    		exception (1) ([err]);
    		
    	} "[err]";
    	
    } "Return a JSON result with all return lines.";
  • Update the script and save:
  • Execute buttons
Services     Supporters     Contact     About     Legal notice © 2024