Functional documentation Cheetah v_4.5.0

SOAQL classes

SOA Query Language

ContainerProjectSchedulerStackStoreAddonsLogParamServerSoaqlTmpAtomConstantDateMathOperatorStringTypeEnvStatementExceptionCpmDbAggregTransactionResultsetImapPop3MailPdfExcelExcelxWordWordxXmlJsonFileQlikviewSshFtpFtpsSftpRs232CertRsaUserGroupSoapWswindevRestWebserverContextPortVhostWebsocketWebHtmlParallelClusterNodeAgentTunnel30TreeCompressOsJavaenvHardware

Container
ping_container_moduleexamplesmergeaddexecutecallincludeexistis_loadedpullpushloadedunloadunload_allgenerate_set_condgenerate_addgenerate_executegenerate_execute_javagenerate_execute_restgenerate_execute_rest_from_argsgenerate_updategenerate_mergegenerate_deletegetgrant_groupis_granted_to_groupis_user_grantedlistclclistlist_in_groupset_conditionactivate_emailis_email_activatedset_log_levelungrant_groupupdatedelete
Project
ping_project_moduleadddeleteexistlist
Scheduler
ping_scheduler_moduleintroductionexamplesactivatemerge_in_dbadd_in_dbmerge_in_dbadd_in_dbcountcount_in_ramdelete_in_dbdesactivateexist_in_dbgenerate_updategenerate_mergeexportis_patternlist_in_dblist_in_ramreloadrowupdate_in_dbupdate_in_db
Stack
ping_stack_moduleexemplesexeadd_varadd_stateadd_state_if_not_existexistexist_varexist_stateget_varget_stateget_statescount_in_stacklistloadedcount_runningis_loadedlist_closedlist_errlist_varprocessprocess_limitupdate_varupdate_stateconcat_statelogretention_dayset_process_limitdelete_vardelete_statedeleteset_retention_dayis_directreplayremove_with_retentionreset_container_in_errorreset_all
Store
exampleping_store_modulelistget_download_statusset_download_statusinstalldownloadhelp
Addons
exampleping_addons_moduleshortcutslistuninstallhelpclasspathclass_path
Log
current_idcpu_memsave_cpu_memget_cpu_avgget_cpuget_mem_avgget_memget_endmax_sizeping_log_moduleset_max_log_sizeset_verbosetraceshowwritetrace_functiontrace_log_stdverbose
Param
ping_param_moduleaddcountcurrent_pool_sizedeleteexistexportconfig_fileset_config_fileget_paramis_paramlistlistlist_poolmax_pool_sizemergeset_max_pool_sizeunloadunload_allupdateget_seq
Server
ping_server_moduleloaded_modulesmsgboxwaitaboutallow_remote_connectauthordatabasedefault_portsoaqldisconnecteditionevalexitgood_to_knowhellohelpmancmansearchidin_editorin_containeris_embeddedis_manageris_securekilllocal_hostlocal_iplocal_portresetmajor_versionmax_sessionminor_versionnamename1name2nb_agentsnb_connectionsnb_exceeded_sessionsnb_sessionsprocess_idpidremote_hostremote_ipremote_portreset_nb_exceeded_sessionsrestartsession_cnt_read_timeoutsession_idsession_timeoutsessionsset_max_sessionset_session_cnt_read_timeoutset_session_timeoutset_verboseuuidshaset_versionshutdownstart_timestamptypeverboseversionyear
Soaql
count_exprhtmlis_args_stringis_valid_connectionping_soaql_module
Tmp
countdelete_alldelete_processlistretention_dayset_retention_day
Atom
before_excludbefore_includcountcount_distinctcount_lrtrimcount_lrtrim_distinctdistinctdistinct_lrtrimdistinct_lrtrim_1sbeforefindfind_lrtrimgetget_firstget_first_lrtrimget_lastget_last_lrtrimget_lrtrimlrtrimping_atom_modulepositionposition_lrtrimsize
Constant
math_four_pimath_half_pimath_pimath_pi_squaremath_two_piphysics_a0physics_amuphysics_bohr_magnetonphysics_cphysics_c_squarephysics_ephysics_ehphysics_fphysics_fine_structurephysics_gphysics_g0physics_kphysics_lpphysics_m_deuteronphysics_m_electronphysics_m_muonphysics_m_neutronphysics_m_protonphysics_magn_flux_quantumphysics_mpphysics_nphysics_newtonian_gphysics_nuclear_magnetonphysics_perm_vac_electricphysics_perm_vac_magneticphysics_planckphysics_planck_over_two_piphysics_rphysics_rinfphysics_stefan_boltzmannphysics_tpphysics_z0ping_constant_module
Date
addaddtcurdatecurrent_datecurrent_timecurrent_timestampcurtimecurtimestampdateadddateaddtdatediffdatedifftts_to_longdt_to_longday_of_monthday_of_weekday_of_yeardaynamediffdifftfull_systimestamphouris_valid_dateis_valid_dateis_valid_timeis_valid_timestampis_valid_timestampformatminutemonthmonthnameping_date_modulesecondesysdatesystimesystimestampsystimestamp_mintimeyear
Math
absacosasinatanatan2bit_andbit_orbit_xorcbrtceilceilingcoscoshcotdecimal_formatdeg_to_radeexpexpm1floorhypotloglog10log1pmaxminmodpiping_math_modulepowpowerrad_to_degrandomrintroundsignsignumsinsinhsqrttantanhulp
Operator
addandand_forcedivequalgreatergreater_or_equalis_emptyis_not_emptyis_not_nullis_nullis_null_or_emptylessless_or_equalmulnotnot_equalnot_numequalnumequaloror_forceping_operator_modulesubxor
String
asciibinbit_lengthcharchar_lengthchar_to_intconcatcountsha1encode_b64decode_b64del_char_before_each_lineends_withfirst_letter_uppergenerate_random_strhexhex_to_inthex_to_strindentinstrinstrint_to_charint_to_hexint_to_octis_emptyis_letteris_alpha_num_udsis_alpha_numis_not_emptyis_number_charis_soaql_stringitrimlcaseleftlengthlikelike_builder1like_builder2locatelocatelowerlpadlrtrimlrtrim0ltrimmatchesmidmidnot_likenot_regexpoctoct_to_intping_string_modulepositionpositionregexprepeatrepeat_insert_strreplacereverserightrpadrtrimspacestarts_withstr_to_hexstrcmpstrposstrpossublrcharsubstrsubstrsubstringsubstringto_stringencodefind_mailempty_if_nullnull_if_emptydo_csv_valueundo_csv_valuetrimtxttxt2ucaseunhexuppervaluezero
Type
is_boolis_charis_dateis_decimalis_emailis_houris_timeis_hour_without_secis_integeris_numberis_byteis_small_intis_medium_intis_intis_big_intis_floatis_doubleis_timestampis_valid_dateis_valid_dateis_valid_timeis_valid_timestampis_valid_timestampis_varcharping_type_module
Env
ping_env_moduleset_varconcat_vardel_vardesc_varerr_msgexist_varload_var_from_tableget_varget_var_if_existincr_varis_varlistlist_varsize
Statement
envcaseexceptionexceptionexeforfor_eachfor_each_csvfor_each_jsonififif_forceping_statement_modulerepeattryerr_msgwhile
Exception
generateon_emptyon_nullon_null_or_emptyping_exception_module
Cpm
add_dbadd_ftpadd_imapadd_sftpadd_scpbuild_jdbccpm_valid_timeoutdeleteexistcountgenerate_updategetget_jdbc_stringis_loadedjdbc_connect_timeoutlist_dblist_ftplist_imaplist_scplist_sftploadedloaded_distinct_idnb_call_connectionsnb_free_connectionsnb_loaded_connectionspingping_cpm_moduleping_queryset_cpm_valid_timeoutset_jdbc_connect_timeoutunloadupdate
Db
dmldmldml_selectdmldml_cntdml_cnt_selectencodedecodeget_valueget_valuesget_valueget_valuesget_value_cntget_values_cntping_db_moduleprepareselectindex1index2table_to_csvtable_to_jsontable_to_xmlcreate_indexcsv_to_tabletabletabletable_cntunion
Aggreg
avgavg_distinctbit_andbit_orbit_xorbool_andbool_orcountcount_distinctcount_distinct_ifcount_ifcount_valuecount_value_iffirstgroup_concatlastmaxmaxstrminminstrping_aggreg_modulestddev_popstddev_sampsumsum_distinctsum_distinct_ifsum_ifvariance_popvariance_samp
Transaction
ping_transaction_moduleclosecloseallcommitdmlexistget_valuelistopenopen_cntrollbacktable
Resultset
ping_resultset_moduleopennextclosecloseall
Imap
ping_imap_moduleread
Pop3
ping_pop3_moduleread
Mail
ping_mail_moduleadd_in_dbadd_in_dbadd_in_dbadd_in_dbcount_closedcount_in_errorcount_to_sendeco_msgerr_msgexistis_initializedjavamail_cnt_timeoutjavamail_timeoutlist_closedlist_in_errorlist_to_sendgenerate_smtp_updatemax_attemptprocessprocess_limitreload_configremoveremove_all_closedremove_with_retentionresetreset_all_in_errorretention_daysendsendsendsendset_eco_msgset_javamail_cnt_timeoutset_javamail_timeoutset_max_attemptset_process_limitset_retention_dayset_smtp_authset_smtp_configset_smtp_passwordset_smtp_portset_smtp_senderset_smtp_serverset_smtp_start_tlsset_smtp_usersmtp_authsmtp_configsmtp_passwordsmtp_portsmtp_sendersmtp_serversmtp_start_tlssmtp_usertot_closedtot_closed_cur_nodetot_in_errortot_in_error_cur_nodetot_to_sendtot_to_send_cur_node
Pdf
ping_pdf_moduleget_text_from_fileget_html_from_fileget_text_from_fileget_html_from_fileget_text_from_urlget_html_from_urlget_text_from_urlget_html_from_url
Excel
ping_excel_modulenewexistadd_sheetcount_sheetdelete_sheetsheetsset_cell_valueget_cellexportclosecloseallimporttable
Excelx
ping_excelx_modulenewexistadd_sheetcount_sheetdelete_sheetsheetsset_cell_valueget_cellexportclosecloseallimporttable
Word
ping_word_moduleextract
Wordx
ping_wordx_moduleextract
Xml
ping_xml_moduleloadexistcountselectselect_textselect_attributexpathfieldsupdateinsertinsert_blockset_attrdelete_attrdeletedocclosecloseall
Json
ping_json_moduleloadformatloadedcountselectis_objis_arrayis_loadedfieldsainsertainsertasetoinsertaupdateoupdateadeleteodeletedocunloadunloadall
File
ping_file_modulemeta_dataexample1example2example3appendb_reader_closeb_reader_closeallb_reader_existb_reader_listb_reader_openb_reader_readb_writer_addbinb_writer_closeb_writer_closeallb_writer_existb_writer_flushb_writer_listb_writer_openb64readb64writeconf_valueconfd_valuecopy_dircopy_filecount_linescount_lines_in_dircount_lines_in_dircreatecreatecreatecur_abs_dircur_canonical_dirdeletedir_listdir_listexistformatis_directoryloadloadmkdirpwdreader_closereader_closeallreader_existreader_getlinereader_listreader_opensizelast_modifiedwriter_addstrwriter_closewriter_closeallwriter_existwriter_flushwriter_listwriter_open
Qlikview
ping_qlikview_moduleqvx_from_dbqvx_from_dbqvx_from_csv
Ssh
exampleping_ssh_moduleconnectexecscp_fromscp_toexec_one_cmddisconnectdisconnectall
Ftp
exampleping_ftp_moduleset_global_timeoutconnectset_typeset_compressionactivepassivecdpwdmkdirlsstatrenameputgetrmrmdirdisconnectdisconnectall
Ftps
exampleping_ftps_moduleconnectparse_pbszexec_protactivepassiveset_file_typecdpwdmkdirls_filesls_filesls_dirsrenameputgetrmrmdirdisconnectdisconnectall
Sftp
exampleping_sftp_moduleconnectcdlcdpwdlpwdmkdirlsstatlstatrenamegethomegetversionputgetrmrmdirdisconnectdisconnectall
Rs232
ping_rs232_moduleis_openconnectdisconnectdisconnect_allsendlist_port
Cert
ping_cert_moduleadd_dnadd_dnalt_host_namescount_all_cucount_cacount_cudelete_cadelete_cudelete_dndelete_dnexist_caexist_cuexist_dnexist_dngenerate_cagenerate_cugenerate_update_dngenerate_update_dnget_dnget_dnget_dn_rowget_dn_rowintegrate_calist_calist_culist_dn_for_calist_dn_for_cursa_key_sizeset_alt_host_namesset_rsa_key_sizeupdate_dnupdate_dn
Rsa
ping_rsa_moduledelete_authorityexist_authoritygenerate_key_pairgenerate_key_pair_clientintegratekey_idkey_sizeoverwrite_in_dboverwrite_trusted_authprivate_keyprivate_key_from_dbpublic_keypublic_key_from_dbpublic_key_from_trusted_authreload_key_pairset_key_idset_key_sizetrusted_authorities
User
ping_user_moduleaddadd_restrictedcount_usercur_is_restrictedcurrentdeleteexistget_user_from_tokenget_tokenget_cur_fullnameget_fullnameget_pwdget_typeget_cur_hcodeget_new_hcodeis_macip_requiredis_valid_macipgrant_groupis_granted_to_groupis_loginis_pwdis_restrictedis_systemlogin_infolistlist_by_groupset_pwdtesttest_for_http_protocolconnectungrant_groupupdate_fullnameupdate_pwdreset_tokenreset_all_tokenupdate_typeupdate_macip_requiredupdate_cur_hcodewho
Group
ping_group_moduleaddcountdeletedescriptionexistfor_cur_usergrant_containergrant_useris_granted_to_containeris_granted_to_useris_granted_to_user_cnxis_validlistlist_by_containerlist_by_userungrant_containerungrant_userupdate
Soap
ping_soap_modulestopget_operationcreate_requestexecute
Wswindev
send_soapping_wswindev_module
Rest
ping_rest_modulehttp_exehttps_exe
Webserver
restartstartstopping_webserver_modulehttp_sessionsidle_thread_in_ramidle_timeout_in_dbidle_timeout_in_ramis_startedkillmax_thread_in_dbmax_thread_in_rammin_thread_in_dbmin_thread_in_ramnb_http_sessionssession_timeoutset_idle_timeout_in_dbset_max_thread_in_dbset_min_thread_in_dbset_session_timeoutthread_in_ram
Context
ping_context_moduleadddeleteexistlistget_project_id
Port
ping_port_moduleactivateactivate_alladdadd_securecount_activatedcount_alldeactivate_alldeleteexistis_activatedis_sockettarget_listlistlist_activatedset_socketset_target_list
Vhost
ping_vhost_moduleaddcountdeleteexistlistlist_all
Websocket
ping_websocket_modulenb_sessionsmax_sessionsessionsset_max_sessionnb_exceeded_sessionsreset_nb_exceeded_sessionssession_timeoutset_session_timeoutkill
Web
get_http_pageis_valid_urlping_web_module
Html
load_formping_html_moduledecodeencode_urlencode
Parallel
ping_parallel_moduleexeexe_no_wait
Cluster
ping_cluster_moduleexamplecluster connection typesadd_agent_in_dbadd_node_in_dbadd_redirection_in_dbadd_redirection_in_ramagent_hostnameagent_portclose_all_redirections_in_ramdelete_agent_in_dbdelete_node_in_dbdelete_node_in_ramdelete_redirection_in_dbdelete_redirection_in_ramexist_agent_in_dbexist_node_in_dbexist_node_in_ramexist_redirection_in_dbexist_redirection_in_ramgenerate_update_nodegenerate_update_agentget_agent_in_dbget_node_in_dbset_cpulist_agent_in_dblist_node_in_dblist_node_in_ramlist_redirection_in_dblist_redirection_in_ramload_node_in_ramload_redirection_in_ramnb_nodes_in_dbnb_nodes_in_ramnb_redirects_in_ramget_node_idget_node_idsnode_hostnamenode_portredirect_destinationserver_redirection_in_errupdate_agent_in_dbupdate_node_in_dbupdate_redirection_in_db
Node
ping_node_modulestartstart
Agent
ping_agent_modulestartstart
Tunnel30
closeclose_clustercloseallexecuteexecute_clusterexecute_cluster_hotexecute_hotexecute_hot2execute_hot3execute_hot4execute_hot5execute_immediateexecute_immediate2execute_immediate3execute_immediate4execute_immediate5execute_node_hotexecute_tree_group_hotexecute_tree_groups_hotexecute_tree_hotexistexpelled_hostlistlist_allnb_expelled_hostopenopen_clusteropen_cluster_hotopen_hotopen_hot2open_hot3open_hot4open_hot5open2open3open4open5ping_tunnel_modulereset_expelled_hostsend_var
Tree
ping_tree_moduleaddcount_clusterdeleteexist_clusterget_end_usergenerate_updateget_server_listget_userget_grouplistfirstis_grantedcluster_in_groupupdate
Compress
jarjar_inping_compress_moduleunjarunzipungzip_filezipzip_in
Os
archexecmdhostnamenametypeping_os_moduleuser_diruser_homeuser_languser_nameuser_timezoneversion
Javaenv
ping_java_moduleall_memory_bytesall_memory_mbytesclasspathclass_pathfile_encodingfile_separatorfree_memory_bytesfree_memory_mbyteshomeio_tmpdirline_separatormax_memory_bytesmax_memory_mbytespath_separatortot_memory_bytestot_memory_mbytesused_memory_bytesused_memory_mbytesvendorvendor_urlversion
Hardware
ping_hardware_modulecpu_countcpu_infoipip_listmacmac_listcpu_idle_usagecpu_sys_usagecpu_user_usagedrive_listfree_memoryfree_memory_mbfree_spacefree_space_gbfree_space_mbtot_spacetot_space_gbtot_space_mbtotal_memorytotal_memory_mbused_memoryused_memory_mbused_spaceused_space_gbused_space_mb




© 2017 - Data-Prisme.