Start Time : 20/05/2025 12:53:29 Loading Structure. Get Struct from Cache Manager. User: rekhancia Role: default Calling webservice to get Structure from DB ASB XE3/32/64 DLL running [Compiled on 23/10/2024 5:01:00 AM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(260724)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 16 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 0 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 0 Db Manager Connection ends Connection to DB Successful Web App Name : Executing GetStructure webservice --------------------------------- Received XML : tstructsausrsdbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuatdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFgmyjcxxozanv2o1zo21ssfafdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/20/2025 12:14:18 pm*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*5/20/2025 12:14:18 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=gmyjcxxozanv2o1zo21ssfaf ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 0 Reading Structure from DB Sql : select props from tstructs where lower(name)= :name order by blobno Paramval : ausrs ParamTYpe : c Param List : name select props from tstructs where lower(name)= :name order by blobno uXDS\dopen\ Check intransaction Time elapsed = 0 Step5 select ' '::varchar(250) as lval Time elapsed = 0 Evaluating { and a1.username <> 'admin' } Result = and a1.username <> 'admin' Evaluating recordid recordid = 0 Result = 0 Evaluating {axusr} Result = axusr Evaluating {12345} Result = 12345 Evaluating iif( recordid = 0, convertmd5(pwd), ppassword) recordid = 0 pwd = 1 ppassword = 1 Calling function convertmd5 Result of convertmd5 = c4ca4238a0b923820dcc509a6f75849b Calling function iif Result of iif = c4ca4238a0b923820dcc509a6f75849b Result = c4ca4238a0b923820dcc509a6f75849b Evaluating {12345} Result = 12345 Evaluating username username = rekhancia Result = rekhancia Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {F} Result = F Evaluating {T} Result = T Evaluating actflag actflag = 1 Result = 1 Evaluating {T} Result = T Evaluating getallvalues({axusergroup},{F}) Calling function getallvalues Result of getallvalues = Result = Evaluating {T} Result = T Evaluating {None} Result = None Evaluating {F} Result = F Evaluating {T} Result = T Evaluating {F} Result = F Evaluating {Portal} Result = Portal Evaluating pusername pusername = 1 Result = 1 Evaluating date() Calling function date Result of date = 20/05/2025 Result = 20/05/2025 Evaluating iif(isempty(axusergroup)={F},{T},{F}) axusergroup = 1 Calling function isempty Result of isempty = F Calling function iif Result of iif = T Result = T Evaluating Date() Calling function date Result of date = 20/05/2025 Result = 20/05/2025 Check print forms Check Attachments Check track changes Executing SetViewControl procedure Executing SetDcAccess Executing AddBtnList Executing SetBtnAccess End of SetViewControl procedure Executing AddSQLResult Field Name : ausrs Field Name : dc1 Field Name : viewfilter Field Name : recid Field Name : transid Field Name : pusername Field Name : nickname Field Name : pwd Field Name : ppassword Field Name : axuser Field Name : usertype Field Name : groupno Field Name : email Field Name : mobile Field Name : build Field Name : manage Field Name : workflow Field Name : send Field Name : importstruct Field Name : isfirsttime Field Name : pageaccess Field Name : reportingto Field Name : webskin Field Name : logintry Field Name : pwdexpdays Field Name : language_access Field Name : language Field Name : exportstruct Field Name : axpertmanager Field Name : accesscode Field Name : appparams Field Name : appmanager Field Name : tools Field Name : actflag Field Name : active Field Name : allusergroup Field Name : tflag Field Name : dhomepage Field Name : homepage Field Name : global_displaytext Field Name : reset_update_flag Field Name : client_details Field Name : otpauth Field Name : pwdauth Field Name : client_details1 Field Name : portal_general_chk Field Name : dc2 Field Name : axusername Field Name : axusergroup Field Name : startdate Field Name : enddate Field Name : validrow2 Field Name : FillRole Field Name : dc3 Field Name : charts Field Name : chartgroup Field Name : graphtypeflag Field Name : tmp_graphtype Field Name : graphtype Field Name : piecolor Field Name : titlelinkname Field Name : filterlinkname Field Name : sqltext Field Name : hyptext Field Name : dc4 Field Name : client_code Field Name : client_name Field Name : client_start_date Field Name : client_end_date Field Name : scripts Field Name : axpconfigs_ausrs Field Name : comps Field Name : iframes Executing AddSQLResult Completed Select configname,cvalue from axpconfigs_ausrs CDS Open Error Msg : csd query : Select configname,cvalue from axpconfigs_ausrs $ Error msg : relation "axpconfigs_ausrs" does not exist uXDS\open\ Exceptio relation "axpconfigs_ausrs" does not exist SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE,A.STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'SINGLE' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND structname = :sname AND A.STRUCTNAME not in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a, axuserlevelgroups b WHERE A.USERROLES IN ('default') AND B.AXUSERNAME = :uname AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') UNION SELECT A.STYPE, :sname STRUCTNAME,A.CONTEXT,A.SFIELD,A.ICOLUMN,A.SBUTTON,A.HLINK,A.PROPS,A.PROPSVAL,A.PROPVALUE2,'ALL' as APPLYON FROM axpstructconfig a WHERE coalesce(USERROLES, 'ALL') = 'ALL' AND lower(a.stype) = :structure_type AND A.STRUCTNAME in('ALL Reports','ALL Forms') order by STYPE,STRUCTNAME,PROPS,APPLYON DESC uname=rekhancia structure_type=tstruct structure_type=tstruct sname=ausrs sname=ausrs uname=rekhancia structure_type=tstruct sname=ausrs structure_type=tstruct Time elapsed = 14 Select names from templates where lower(iviewid) = 'ausrs' Time elapsed = 2 sname=ausrs select content from AX_LAYOUTDESIGN where lower(transid)= :sname and module= 'TSTRUCT' order by created_on desc sname=ausrs Time elapsed = 4 Select * from axrulesdef where lower(transid) = 'ausrs' order by rulegroup,rulename Time elapsed = 3 Select * from axrulesdef_conmsg where lower(btnstransid) = 'ausrs' order by btnname Time elapsed = 11 select errcode,errmsg from axpdef_errcodes where lower(errlang) = 'english'and ((lower(applicabletransid) = 'ausrs') or (lower(applicabletransid) like '%,ausrs,%') or (lower(applicabletransid) like 'ausrs,%') or (lower(applicabletransid) like '%,ausrs')) order by errlang , applicabletransid Time elapsed = 3 CheckAxProcessDef starts... CheckAxProcessDef starts... select * from AxProcessDef where lower(transid)='ausrs' and lower(active)='t' and lower(tasktype)='make' Time elapsed = 6 SELECT ppm.powner as processowner , ppm.pownerflg as processownerflg, ppm.amendment, pdv.* FROM AxprocessDefV2 pdv JOIN axpdef_peg_processmaster ppm ON pdv.processname = ppm.caption WHERE lower(transid)='ausrs' and lower(active)='t' and lower(tasktype)='make' and (ppm.amendment is null or ppm.amendment = '' or lower(ppm.amendment)<> 't') Time elapsed = 11 CheckAxProcessDef ends. IsAmendmentEnabled starts... SELECT ppm.powner as processowner , ppm.pownerflg as processownerflg, ppm.amendment, pdv.* FROM AxprocessDefV2 pdv JOIN axpdef_peg_processmaster ppm ON pdv.processname = ppm.caption WHERE lower(transid)='ausrs' and lower(active)='t' and lower(ppm.amendment) = 't' order by indexno Time elapsed = 8 IsAmendmentEnabled ends. CheckAxProcessDef ends. Structure XML : ausrsPortal LogintFalseTrueFalseFalseFalseNoneDefaultFalsedc1User Login1axusersFalseTrueTrueTrueTrueFalseviewfilterviewfilterCharacter5000calculate00TrueTrueFalseFalseFalse{ and a1.username <> 'admin' }TrueTrueFalseFalseTrueTrueTrueviewfilterrecidrecidNumeric150calculate00TrueTrueFalseFalseFalserecordid TrueFalseFalseFalseFalseTrueTruerecidtransidtransidCharacter50calculate00TrueTrueFalseFalseTrue{axusr}TrueFalseFalseFalseFalseTrueTruetransidpusernameEmail ID/Login IDCharacter300Selectselect distinct cast( a.primary_emailid as varchar(30)) emailids from client_details a order by emailids00TrueTrueFalseFalseTrueFalseTrueiif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits}, iif( fieldchanged( {pusername},1) = {T}, { cannot be changed}, {T})) { FalseTrueFalseFalseTrueTruesclient_details,sclient_details1,eaxusernameselect cast( a.primary_emailid as varchar(50)) emailids from client_details a where a.primary_emailid is not null and recordid = 0 and not exists (select 'x' from axusers b where a.primary_emailid = b.pusername) union select cast( a.pusername as varchar(50)) emailids from axusers a where a.axusersid = recordid order by emailidsTruepusername~client_details,client_details1,axusernamenicknameFirst NameCharacter2000Accept00FalseFalseFalseFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruenicknamepwdPasswordCharacter500Accept00FalseFalseFalseTrueFalseFalseFalseTrue{12345}iif(GetLength(pwd)<5,{_Password should be minimum 5 characters},{T})TrueTrueFalseFalseTrueTrueeppasswordTruepwd~ppasswordppasswordpasswordCharacter500calculate00TrueTrueFalseFalseTrueiif( recordid = 0, convertmd5(pwd), ppassword) TrueTrueFalseFalseTrueTrueiif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword)Trueppassword,pwdaxuseraxuserCharacter250calculate00TrueTrueFalseFalseFalseusernameTrueTrueFalseFalseTrueTrueTrueaxuserusertypeUser TypeCharacter200Select00FalseFalseADMINTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTruescharts,fchartgroup,fgraphtypeflag,ftmp_graphtype,sgraphtype,fpiecolor,ftitlelinkname,ffilterlinkname,fsqltext,fhyptextTrueusertype~charts,chartgroup,graphtypeflag,tmp_graphtype,graphtype,piecolor,titlelinkname,filterlinkname,sqltext,hyptextgroupnousergroupnumberNumeric70Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegroupnoemailE-mailCharacter2000Accept00FalseFalseFalseFalseTrueFalseFalseTrueFalseTrueFalseFalseTrue*@*.*TrueTrueemailmobileMobileCharacter100Accept00FalseFalseFalseFalseTrueFalseFalseTrueiif((isempty(mobile) = {F}) & getlength(mobile)#10,{ Invalid mobile number (should contain 10 digits)}, iif((isempty(mobile) = {F}) & substr(mobile,1,1)#{7} & substr(mobile,1,1)#{8} & substr(mobile,1,1)#{9},{ Invalid mobile number (should be starting with 7/8/9)},{T}))TrueTrueFalseFalseTrueTrueTruemobilebuildBuild ModeCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruebuildmanageUsersCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruemanageworkflowWorkflowCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueworkflowsendSend/ReceiveCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruesendimportstructImport StructuresCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueimportstructisfirsttimeisfirsttimeCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueisfirsttimepageaccesspageaccessCharacter2500Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepageaccessreportingtoreportingtoCharacter300Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruereportingtowebskinwebskinCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruewebskinlogintrylogintryNumeric20Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelogintrypwdexpdayspwdexpdaysNumeric30Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepwdexpdayslanguage_accesslanguage_accessCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguage_accesslanguagelanguageCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguageexportstructExport StructureCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueexportstructaxpertmanagerAxpertmanagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueaxpertmanageraccesscodeaccesscodeCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueaccesscodeappparamsappparamsCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappparamsappmanagerApp ManagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappmanagertoolsToolsCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruetoolsactflagActiveCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeactiveTrueactflag~activeactiveActiveCharacter10calculate00TrueTrueFalseFalseTrueactflagTrueTrueFalseFalseTrueTrueTrueactive,actflagallusergroupallusergroupCharacter2000calculate00TrueTrueFalseFalseTruegetallvalues({axusergroup},{F})TrueTrueFalseFalseTrueTrueTrueallusergroup,axusergrouptflagtflagCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseFalse{T}TrueTrueFalseFalseTrueTrueTruetflagdhomepageHome PageCharacter2000SelectSELECT caption, name, replace(props,'page.aspx?axpage_id=','') AS homepage, 2 as slno FROM axpages where lower(pagetype) = 'web' union all select cast('None' as varchar(50)) ,'' as b , '0' as homepage, 1 as slno from dual order by slno,caption00TrueFalseTrueTrueFalseFalseTrue{None}TrueTrueFalseFalseTrueTruefhomepageTruedhomepage~homepagehomepageCharacter200Fill00dhomepagehomepageFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruehomepage,dhomepageglobal_displaytextGlobal DisplaytextCharacter3000Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueglobal_displaytextreset_update_flagReset/UpdateCharacter10Accept00TrueFalseFalseTrueTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruereset_update_flagclient_detailsClient DetailsText40000Acceptselect STRING_AGG(CONCAT(a.client_code, ':' , a.client_name), ', ') AS Concatenated_Client_Info from client_details a where lower(a.primary_emailid) = lower( :pusername)00TrueFalseFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTrueclient_details,pusernameotpauthOTP AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTrueotpauthpwdauthPassword AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdauthclient_details1client_details1Character10000Acceptselect STRING_AGG(CONCAT(a.client_code, ':' , a.client_name, ','), ' ') AS Concatenated_Client_Info from client_details a where a.primary_emailid = :pusername00TrueFalseFalseTrueTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTrueclient_details1,pusernameportal_general_chkPortal/GeneralCharacter2000calculate00TrueTrueTrueFalseTrue{Portal}TrueFalseFalseFalseFalseTrueTrueportal_general_chkdc2Roles2axuserlevelgroupsTrueTrueFalseTrueTrueFalseaxusernameaxusernameCharacter500calculate00TrueTrueFalseFalseTruepusernameTrueTrueFalseFalseTrueTrueTrueaxusername,pusernameaxusergroupRoleCharacter500AcceptSELECT GROUPNAME as Role, GROUPNO FROM AXUSERGROUPS a1 where a1.groupname = 'client' ORDER BY Role00TrueFalseFalseFalseFalseTrueFalseTrueTrueFalseFalseFalseFalseTrueevalidrow2,eallusergroupTrueaxusergroup~validrow2,allusergroupstartdateStart DateDate/Time100Accept00FalseFalseFalseFalseFalseFalseFalseTruedate()IIF( isempty( axusergroup) = {F} & isempty( startdate) = {T}, {Assigned From should be specified for Additional Roles}, {T})TrueTrueFalseFalseTrueTrueTruestartdateenddateEnd DateDate/Time100Accept00FalseFalseFalseFalseTrueFalseFalseTrueIIF(isempty( enddate) = {T}, {T},iif( ctod( startdate) > ctod( enddate) , {End Date cannot be lesser than the start date}, {T}))TrueTrueFalseFalseTrueTrueTrueenddatevalidrow2validrow2Character100calculate00TrueTrueFalseFalseFalseiif(isempty(axusergroup)={F},{T},{F})TrueTrueFalseFalseTrueTrueTruevalidrow2,axusergroupFillRoleFalseFilling rolesselect 'client' as choice from dual dc2choiceFalseTrueFalseTrueTrueInitialize grid and addTruedc3User Charts3axuserchartsTrueTrueTrueTrueTrueFalsechartsChartsCharacter1000Selectselect a1.axp_chartconfigid , a1.title, a1.chartgroup, a1.graphtype, a1.piecolor, a1.linkname, a1.sqltext, a1.hyptext, a1.flinkname,COALESCE(changegraph,'F') as changegraph from axp_chartconfig a1 where upper( :usertype ) like '%'|| upper(cusertype)||'%' order by a1.title00TrueFalsetitleaxp_chartconfigFalseTrueFalseFalseTrueTrueTrueTrueFalseTrueTruefchartgroup,fgraphtypeflag,ftmp_graphtype,sgraphtype,fpiecolor,ftitlelinkname,ffilterlinkname,fsqltext,fhyptextTruecharts,usertype~chartgroup,graphtypeflag,tmp_graphtype,graphtype,piecolor,titlelinkname,filterlinkname,sqltext,hyptextchartgroupchartgroupCharacter1000Fill00chartsCHARTGROUPFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruechartgroup,charts,usertypegraphtypeflaggraphtypeflagCharacter100Fill00chartsCHANGEGRAPHFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTruesgraphtypeTruegraphtypeflag,charts,usertype~graphtype,tmp_graphtypetmp_graphtypetmp_graphtypeCharacter500Fill00chartsGRAPHTYPEFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTruesgraphtypeTruetmp_graphtype,charts,usertype~graphtype,graphtypeflaggraphtypeGraph TypeCharacter300Selectselect 'Pie' as ctype from dual where :graphtypeflag = 'T' union select 'Column' as ctype from dual where :graphtypeflag = 'T' union select :tmp_graphtype as ctype from dual where :graphtypeflag <> 'T' order by 100TrueFalseFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegraphtype,graphtypeflag,charts,usertype,tmp_graphtypepiecolorpiecolorCharacter1000Fill00chartsPIECOLORFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruepiecolor,charts,usertypetitlelinknametitlelinknameCharacter1000Fill00chartsLINKNAMEFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruetitlelinkname,charts,usertypefilterlinknamefilterlinknameCharacter3000Fill00chartsFLINKNAMEFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruefilterlinkname,charts,usertypesqltextsqltextCharacter35000Fill00chartsSQLTEXTFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruesqltext,charts,usertypehyptexthyptextCharacter10000Fill00chartsHYPTEXTFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruehyptext,charts,usertypedc4Client Details4user_clientcodeTrueTrueTrueTrueTrueFalseclient_codeClient CodeCharacter500SelectSelect a1.client_code,a1.client_name, a1.active from client_details a1 where a1.active = 'T' and a1.cancel = 'F' order by a1.client_code00FalseTrueFalseFalseFalseFalseTrueFalseTrueFalseFalseTrueTruefclient_nameTrueclient_code~client_nameclient_nameClient NameCharacter2000Fill00client_codeclient_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruetrue~client_codeclient_name,client_codeclient_start_dateClient Start DateDate/Time100Accept00TrueFalseFalseTrueTrueFalseFalseTrueDate()TrueFalseFalseFalseFalseTrueTrueclient_start_dateclient_end_dateClient End DateDate/Time100Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueclient_end_dateAxHideControls({dc3})AxHideControls({dc4})AxHideControls({dc3})AxHideControls({dc4})searchcolsactflag,axusergroup,charts,client_code,client_name,email,enddate,graphtype,mobile,nickname,otpauth,pusername,pwdauth,startdatelistmaterial-iconsmaterial-iconsfact_checkmaterial-iconsdc1dc2dc3dc4Tstructausrscamera optiontrueALLTstructausrsCustom CSStrueALLTstructausrsFile Upload Limit200ALLTstructausrsGeneralfalseALLTstructausrsGeneraltrueALLTstructausrsGridEditinlineALL[{"transid":"ausrs","compressedMode":true,"newDesign":true,"staticRunMode":false,"wizardDC":false,"selectedLayout":"single","selectedFontSize":"14","selectedControlHeight":"24","tstUpdatedOn":"30/04/2025 16:06:51","dcLayout":"default","formWidth":"100","formAlignment":"default","fieldCaptionWidth":"30","formLabel":[],"buttonFieldFont":[],"dcs":[{"dc_id":"1","isGrid":"F","gridStretch":false,"fieldsDesign":[{"fld_id":"pusername","x":0,"y":0,"width":7,"height":1,"visibility":true},{"fld_id":"nickname","x":7,"y":0,"width":10,"height":1,"visibility":true},{"fld_id":"mobile","x":17,"y":0,"width":8,"height":1,"visibility":true},{"fld_id":"otpauth","x":25,"y":0,"width":4,"height":1,"visibility":true},{"fld_id":"email","x":0,"y":1,"width":17,"height":1,"visibility":true},{"fld_id":"actflag","x":17,"y":1,"width":8,"height":1,"visibility":true},{"fld_id":"pwdauth","x":25,"y":1,"width":5,"height":1,"visibility":true},{"fld_id":"client_details","x":0,"y":2,"width":30,"height":2,"visibility":true},{"fld_id":"client_details1","x":0,"y":4,"width":16,"height":1,"visibility":true}],"tableDesign":null},{"dc_id":"2","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"axusergroup","x":0,"y":0,"width":12,"height":1,"visibility":true},{"fld_id":"startdate","x":12,"y":0,"width":9,"height":1,"visibility":true},{"fld_id":"enddate","x":21,"y":0,"width":9,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct2","width":39,"visibility":true},{"fld_id":"uniqueThHead2","width":43,"visibility":true},{"fld_id":"axp_recid2","width":0,"visibility":false},{"fld_id":"axusername","width":0,"visibility":false},{"fld_id":"axusergroup","width":260,"visibility":true},{"fld_id":"startdate","width":161,"visibility":true},{"fld_id":"enddate","width":161,"visibility":true},{"fld_id":"validrow2","width":0,"visibility":false}]},{"dc_id":"3","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"charts","x":0,"y":0,"width":24,"height":1,"visibility":true},{"fld_id":"graphtype","x":24,"y":0,"width":12,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct3","width":20,"visibility":true},{"fld_id":"uniqueThHead3","width":40,"visibility":true},{"fld_id":"axp_recid3","width":0,"visibility":false},{"fld_id":"charts","width":400,"visibility":true},{"fld_id":"chartgroup","width":0,"visibility":false},{"fld_id":"graphtypeflag","width":0,"visibility":false},{"fld_id":"tmp_graphtype","width":0,"visibility":false},{"fld_id":"graphtype","width":240,"visibility":true},{"fld_id":"piecolor","width":0,"visibility":false},{"fld_id":"titlelinkname","width":0,"visibility":false},{"fld_id":"filterlinkname","width":0,"visibility":false},{"fld_id":"sqltext","width":0,"visibility":false},{"fld_id":"hyptext","width":0,"visibility":false}]},{"dc_id":"4","isGrid":"T","gridStretch":false,"fieldsDesign":[{"fld_id":"client_code","x":0,"y":0,"width":15,"height":1,"visibility":true},{"fld_id":"client_name","x":0,"y":1,"width":36,"height":1,"visibility":true}],"tableDesign":[{"fld_id":"uniqueEditDeleteAct4","width":20,"visibility":true},{"fld_id":"uniqueThHead4","width":40,"visibility":true},{"fld_id":"axp_recid4","width":0,"visibility":false},{"fld_id":"client_code","width":270,"visibility":true},{"fld_id":"client_name","width":400,"visibility":true},{"fld_id":"client_start_date","width":0,"visibility":false},{"fld_id":"client_end_date","width":0,"visibility":false}]}],"newdcs":null}]username GetStructure webservice completed # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:53:29','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:53:29','dd/mm/yyyy hh24:mi:ss'),null,0,'Get Structure','success',451,78,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Destroying License Manager Destroying License Manager XDS Destroying License Manager Completed Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF Returning the structure. Getting Structure from DB rekhancia Role: default Recordid = 0 Opening Tstruct. ASB XE3/32/64 DLL running [Compiled on 24/03/2025 11:58:10 PM] [File Version : 11.3.0.0]] [Product Version : 11.3][64Bit(240325)] DB Manager created Current ASB DLL folder : E:\Axpert113\Axpert Web\AxpertWebScripts Connecting to project : trustlineuat Connecting to project found : -1 Session key validation Session key validation completed Db Manager Connection starts Db Manager Connection XML receied : dbPostgredbxlocalhosttrustlineuat\trustlineuat creating connection starts... creating connection end... creating date xds... creating date xds end... PostGreConnect starts... PostGreConnect ends... db user : trustlineuat Select now() as sdt Time elapsed = 0 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 17 axprops xml = images\Agile-TrustLine-UATINR1FFFsmtp.office365.com587portalneo@trustlineindia.com9IntFlo!!$$*1100000FF SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2 uXDS\dopen\ Check intransaction Time elapsed = 2 Db Manager Connection ends Connection to DB Successful Executing Quick DoFormLoad webservice ------------------------------------- Registering app/user variables for the session Registering DBMem variables Registering DBMem variables completed Registering ConfigParam variables Registering ConfigParam variables completed auth_path=E:\Axpert113\Axpert Web\AxpertWebScripts axp_clientlocale=en-us*asia/calcutta^english*5/20/2025 12:14:18 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=gmyjcxxozanv2o1zo21ssfaf ax_evalcopy=F rolename=default responsibilies=default millions=F axpimageserver= axglo_hide= axp_displaytext= axglo_user= fromuserlogin= axglo_recordid=1025660000000 axpimagepath= AxpServerPath=\\10.16.248.2\UAT_Attachment\UAT_TLBusiness AxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports AxpDbDirPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir LStr : ~~9867~25~0~0~1~R~false~R LReg Type : R User Group default User Roles default Registering app/user variables for the session completed select sessionid from connections where sessionid = :sesid uXDS\dopen\ Check intransaction Time elapsed = 3 Received XML dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuatdd/mm/yyyy hh24:mi:ssadminlocalBlackENGLISHtruet\\10.16.248.2\UAT_Attachment\UAT_TLReports\AxImportDbDir\\10.16.248.2\UAT_Attachment\UAT_TLReports\\10.16.248.2\UAT_Attachment\UAT_TLBusiness1025660000000FrekhanciadefaultdefaultFgmyjcxxozanv2o1zo21ssfafdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/20/2025 12:14:18 pm*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Received SXML ausrsPortal LogintFalseTrueFalseFalseFalseNoneDefaultFalsedc1User Login1axusersFalseTrueTrueTrueTrueFalseviewfilterviewfilterCharacter5000calculate00TrueTrueFalseFalseFalse{ and a1.username <> 'admin' }TrueTrueFalseFalseTrueTrueTrueviewfilterrecidrecidNumeric150calculate00TrueTrueFalseFalseFalserecordid TrueFalseFalseFalseFalseTrueTruerecidtransidtransidCharacter50calculate00TrueTrueFalseFalseTrue{axusr}TrueFalseFalseFalseFalseTrueTruetransidpusernameEmail ID/Login IDCharacter300Selectselect distinct cast( a.primary_emailid as varchar(30)) emailids from client_details a order by emailids00TrueTrueFalseFalseTrueFalseTrueiif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits}, iif( fieldchanged( {pusername},1) = {T}, { cannot be changed}, {T})) { FalseTrueFalseFalseTrueTruesclient_details,sclient_details1,eaxusernameselect cast( a.primary_emailid as varchar(50)) emailids from client_details a where a.primary_emailid is not null and recordid = 0 and not exists (select 'x' from axusers b where a.primary_emailid = b.pusername) union select cast( a.pusername as varchar(50)) emailids from axusers a where a.axusersid = recordid order by emailidsTruepusername~client_details,client_details1,axusernamenicknameFirst NameCharacter2000Accept00FalseFalseFalseFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruenicknamepwdPasswordCharacter500Accept00FalseFalseFalseTrueFalseFalseFalseTrue{12345}iif(GetLength(pwd)<5,{_Password should be minimum 5 characters},{T})TrueTrueFalseFalseTrueTrueeppasswordTruepwd~ppasswordppasswordpasswordCharacter500calculate00TrueTrueFalseFalseTrueiif( recordid = 0, convertmd5(pwd), ppassword) TrueTrueFalseFalseTrueTrueiif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword)Trueppassword,pwdaxuseraxuserCharacter250calculate00TrueTrueFalseFalseFalseusernameTrueTrueFalseFalseTrueTrueTrueaxuserusertypeUser TypeCharacter200Select00FalseFalseADMINTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTruescharts,fchartgroup,fgraphtypeflag,ftmp_graphtype,sgraphtype,fpiecolor,ftitlelinkname,ffilterlinkname,fsqltext,fhyptextTrueusertype~charts,chartgroup,graphtypeflag,tmp_graphtype,graphtype,piecolor,titlelinkname,filterlinkname,sqltext,hyptextgroupnousergroupnumberNumeric70Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegroupnoemailE-mailCharacter2000Accept00FalseFalseFalseFalseTrueFalseFalseTrueFalseTrueFalseFalseTrue*@*.*TrueTrueemailmobileMobileCharacter100Accept00FalseFalseFalseFalseTrueFalseFalseTrueiif((isempty(mobile) = {F}) & getlength(mobile)#10,{ Invalid mobile number (should contain 10 digits)}, iif((isempty(mobile) = {F}) & substr(mobile,1,1)#{7} & substr(mobile,1,1)#{8} & substr(mobile,1,1)#{9},{ Invalid mobile number (should be starting with 7/8/9)},{T}))TrueTrueFalseFalseTrueTrueTruemobilebuildBuild ModeCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruebuildmanageUsersCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruemanageworkflowWorkflowCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueworkflowsendSend/ReceiveCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruesendimportstructImport StructuresCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueimportstructisfirsttimeisfirsttimeCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueisfirsttimepageaccesspageaccessCharacter2500Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepageaccessreportingtoreportingtoCharacter300Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruereportingtowebskinwebskinCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruewebskinlogintrylogintryNumeric20Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelogintrypwdexpdayspwdexpdaysNumeric30Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepwdexpdayslanguage_accesslanguage_accessCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguage_accesslanguagelanguageCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguageexportstructExport StructureCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueexportstructaxpertmanagerAxpertmanagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueaxpertmanageraccesscodeaccesscodeCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueaccesscodeappparamsappparamsCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappparamsappmanagerApp ManagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappmanagertoolsToolsCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruetoolsactflagActiveCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeactiveTrueactflag~activeactiveActiveCharacter10calculate00TrueTrueFalseFalseTrueactflagTrueTrueFalseFalseTrueTrueTrueactive,actflagallusergroupallusergroupCharacter2000calculate00TrueTrueFalseFalseTruegetallvalues({axusergroup},{F})TrueTrueFalseFalseTrueTrueTrueallusergroup,axusergrouptflagtflagCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseFalse{T}TrueTrueFalseFalseTrueTrueTruetflagdhomepageHome PageCharacter2000SelectSELECT caption, name, replace(props,'page.aspx?axpage_id=','') AS homepage, 2 as slno FROM axpages where lower(pagetype) = 'web' union all select cast('None' as varchar(50)) ,'' as b , '0' as homepage, 1 as slno from dual order by slno,caption00TrueFalseTrueTrueFalseFalseTrue{None}TrueTrueFalseFalseTrueTruefhomepageTruedhomepage~homepagehomepageCharacter200Fill00dhomepagehomepageFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruehomepage,dhomepageglobal_displaytextGlobal DisplaytextCharacter3000Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueglobal_displaytextreset_update_flagReset/UpdateCharacter10Accept00TrueFalseFalseTrueTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruereset_update_flagclient_detailsClient DetailsText40000Acceptselect STRING_AGG(CONCAT(a.client_code, ':' , a.client_name), ', ') AS Concatenated_Client_Info from client_details a where lower(a.primary_emailid) = lower( :pusername)00TrueFalseFalseFalseTrueTrueFalseTrueTrueFalseFalseFalseFalseTrueTrueclient_details,pusernameotpauthOTP AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTrueotpauthpwdauthPassword AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdauthclient_details1client_details1Character10000Acceptselect STRING_AGG(CONCAT(a.client_code, ':' , a.client_name, ','), ' ') AS Concatenated_Client_Info from client_details a where a.primary_emailid = :pusername00TrueFalseFalseTrueTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTrueclient_details1,pusernameportal_general_chkPortal/GeneralCharacter2000calculate00TrueTrueTrueFalseTrue{Portal}TrueFalseFalseFalseFalseTrueTrueportal_general_chkdc2Roles2axuserlevelgroupsTrueTrueFalseTrueTrueFalseaxusernameaxusernameCharacter500calculate00TrueTrueFalseFalseTruepusernameTrueTrueFalseFalseTrueTrueTrueaxusername,pusernameaxusergroupRoleCharacter500AcceptSELECT GROUPNAME as Role, GROUPNO FROM AXUSERGROUPS a1 where a1.groupname = 'client' ORDER BY Role00TrueFalseFalseFalseFalseTrueFalseTrueTrueFalseFalseFalseFalseTrueevalidrow2,eallusergroupTrueaxusergroup~validrow2,allusergroupstartdateStart DateDate/Time100Accept00FalseFalseFalseFalseFalseFalseFalseTruedate()IIF( isempty( axusergroup) = {F} & isempty( startdate) = {T}, {Assigned From should be specified for Additional Roles}, {T})TrueTrueFalseFalseTrueTrueTruestartdateenddateEnd DateDate/Time100Accept00FalseFalseFalseFalseTrueFalseFalseTrueIIF(isempty( enddate) = {T}, {T},iif( ctod( startdate) > ctod( enddate) , {End Date cannot be lesser than the start date}, {T}))TrueTrueFalseFalseTrueTrueTrueenddatevalidrow2validrow2Character100calculate00TrueTrueFalseFalseFalseiif(isempty(axusergroup)={F},{T},{F})TrueTrueFalseFalseTrueTrueTruevalidrow2,axusergroupFillRoleFalseFilling rolesselect 'client' as choice from dual dc2choiceFalseTrueFalseTrueTrueInitialize grid and addTruedc3User Charts3axuserchartsTrueTrueTrueTrueTrueFalsechartsChartsCharacter1000Selectselect a1.axp_chartconfigid , a1.title, a1.chartgroup, a1.graphtype, a1.piecolor, a1.linkname, a1.sqltext, a1.hyptext, a1.flinkname,COALESCE(changegraph,'F') as changegraph from axp_chartconfig a1 where upper( :usertype ) like '%'|| upper(cusertype)||'%' order by a1.title00TrueFalsetitleaxp_chartconfigFalseTrueFalseFalseTrueTrueTrueTrueFalseTrueTruefchartgroup,fgraphtypeflag,ftmp_graphtype,sgraphtype,fpiecolor,ftitlelinkname,ffilterlinkname,fsqltext,fhyptextTruecharts,usertype~chartgroup,graphtypeflag,tmp_graphtype,graphtype,piecolor,titlelinkname,filterlinkname,sqltext,hyptextchartgroupchartgroupCharacter1000Fill00chartsCHARTGROUPFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruechartgroup,charts,usertypegraphtypeflaggraphtypeflagCharacter100Fill00chartsCHANGEGRAPHFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTruesgraphtypeTruegraphtypeflag,charts,usertype~graphtype,tmp_graphtypetmp_graphtypetmp_graphtypeCharacter500Fill00chartsGRAPHTYPEFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTruesgraphtypeTruetmp_graphtype,charts,usertype~graphtype,graphtypeflaggraphtypeGraph TypeCharacter300Selectselect 'Pie' as ctype from dual where :graphtypeflag = 'T' union select 'Column' as ctype from dual where :graphtypeflag = 'T' union select :tmp_graphtype as ctype from dual where :graphtypeflag <> 'T' order by 100TrueFalseFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegraphtype,graphtypeflag,charts,usertype,tmp_graphtypepiecolorpiecolorCharacter1000Fill00chartsPIECOLORFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruepiecolor,charts,usertypetitlelinknametitlelinknameCharacter1000Fill00chartsLINKNAMEFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruetitlelinkname,charts,usertypefilterlinknamefilterlinknameCharacter3000Fill00chartsFLINKNAMEFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruefilterlinkname,charts,usertypesqltextsqltextCharacter35000Fill00chartsSQLTEXTFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruesqltext,charts,usertypehyptexthyptextCharacter10000Fill00chartsHYPTEXTFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTruehyptext,charts,usertypedc4Client Details4user_clientcodeTrueTrueTrueTrueTrueFalseclient_codeClient CodeCharacter500SelectSelect a1.client_code,a1.client_name, a1.active from client_details a1 where a1.active = 'T' and a1.cancel = 'F' order by a1.client_code00FalseTrueFalseFalseFalseFalseTrueFalseTrueFalseFalseTrueTruefclient_nameTrueclient_code~client_nameclient_nameClient NameCharacter2000Fill00client_codeclient_nameFalseFalseTrueTrueFalseFalseTrueFalseFalseFalseFalseTrueTruetrue~client_codeclient_name,client_codeclient_start_dateClient Start DateDate/Time100Accept00TrueFalseFalseTrueTrueFalseFalseTrueDate()TrueFalseFalseFalseFalseTrueTrueclient_start_dateclient_end_dateClient End DateDate/Time100Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueclient_end_dateAxHideControls({dc3})AxHideControls({dc4})AxHideControls({dc3})AxHideControls({dc4})listmaterial-iconsmaterial-iconsfact_checkmaterial-iconsdc1dc2dc3dc4 Creating DbCall Evaluating { and a1.username <> 'admin' } Result = Evaluating pusername Result = Evaluating recordid Result = Evaluating {axusr} Result = Evaluating iif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits}, iif( fieldchanged( {pusername},1) = {T}, { cannot be changed}, {T})) { Result = Evaluating {12345} Result = Evaluating iif(GetLength(pwd)<5,{_Password should be minimum 5 characters},{T}) Result = Evaluating iif( recordid = 0, convertmd5(pwd), ppassword) Result = Evaluating username Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {T} Result = Evaluating actflag Result = Evaluating getallvalues({axusergroup},{F}) Result = Evaluating {T} Result = Evaluating {None} Result = Evaluating {F} Result = Evaluating {T} Result = Evaluating {F} Result = Evaluating {Portal} Result = CreateSelectedDCFlds DC : dc2 Evaluating date() Result = Evaluating IIF( isempty( axusergroup) = {F} & isempty( startdate) = {T}, {Assigned From should be specified for Additional Roles}, {T}) Result = Evaluating IIF(isempty( enddate) = {T}, {T},iif( ctod( startdate) > ctod( enddate) , {End Date cannot be lesser than the start date}, {T})) Result = Evaluating iif(isempty(axusergroup)={F},{T},{F}) Result = Evaluating Date() Result = Submiting & Registering data Registering Global variables data Registering Global variables data over Setting values over Creating Action object Time taken to connect and submit - 294 Action node in structure : AxHideControls({dc3})AxHideControls({dc4}) Starting Action Execution - script1 Executing task - scripts Assigning expression set to parser Expression : AxHideControls({dc3}) AxHideControls({dc4}) Evaluating AxHideControls({dc3}) Result = Evaluating AxHideControls({dc4}) Result = Executing task scripts over Action Execution over - script1 Quick Form Load JSON Executing fill Grid 1 Preparing viewfilter-calculate Field Value - and a1.username <> 'admin' DC to JSON DC1 Field to JSON viewfilter row 1 Preparing recid-calculate recordid = 0 Field Value - 0 Preparing transid-calculate Field Value - axusr Field to JSON transid row 1 Preparing pusername-select select distinct cast( a.primary_emailid as varchar(30)) emailids from client_details a order by emailids Time elapsed = 4 Query opened , Record count : 65 Field Value - Preparing pwd-accept Field Value - 12345 Field to JSON pwd row 1 Preparing ppassword-calculate pwd = 12345 Result of convertmd5 = 827ccb0eea8a706c4c34a16891f84e7b recordid = 0 ppassword = Result of iif = 827ccb0eea8a706c4c34a16891f84e7b Field Value - 827ccb0eea8a706c4c34a16891f84e7b Field to JSON ppassword row 1 Preparing axuser-calculate username = rekhancia Field Value - rekhancia Field to JSON axuser row 1 Preparing usertype-select Field Value - Preparing build-accept Field Value - F Field to JSON build row 1 Preparing manage-accept Field Value - F Field to JSON manage row 1 Preparing workflow-accept Field Value - F Field to JSON workflow row 1 Preparing send-accept Field Value - F Field to JSON send row 1 Preparing importstruct-accept Field Value - F Field to JSON importstruct row 1 Preparing exportstruct-accept Field Value - F Field to JSON exportstruct row 1 Preparing tools-accept Field Value - F Field to JSON tools row 1 Preparing actflag-accept Field Value - T Field to JSON actflag row 1 Preparing active-calculate actflag = T Field Value - T Field to JSON active row 1 Preparing allusergroup-calculate Result of getallvalues = Field Value - Preparing tflag-accept Field Value - T Field to JSON tflag row 1 Preparing dhomepage-select SELECT caption, name, replace(props,'page.aspx?axpage_id=','') AS homepage, 2 as slno FROM axpages where lower(pagetype) = 'web' union all select cast('None' as varchar(50)) ,'' as b , '0' as homepage, 1 as slno from dual order by slno,caption Time elapsed = 5 Query opened , Record count : 15 Field Value - None Field to JSON dhomepage row 1 Preparing homepage-fill Field Value - 0 Field to JSON homepage row 1 Preparing reset_update_flag-accept Field Value - F Field to JSON reset_update_flag row 1 Preparing client_details-accept pusername= select STRING_AGG(CONCAT(a.client_code, ':' , a.client_name), ', ') AS Concatenated_Client_Info from client_details a where lower(a.primary_emailid) = lower( :pusername) pusername= Time elapsed = 3 Query opened , Record count : 1 Field Value - Preparing otpauth-accept Field Value - T Field to JSON otpauth row 1 Preparing pwdauth-accept Field Value - F Field to JSON pwdauth row 1 Preparing client_details1-accept pusername= select STRING_AGG(CONCAT(a.client_code, ':' , a.client_name, ','), ' ') AS Concatenated_Client_Info from client_details a where a.primary_emailid = :pusername pusername= Time elapsed = 2 Query opened , Record count : 1 Field Value - Preparing portal_general_chk-calculate Field Value - Portal Field to JSON portal_general_chk row 1 Executing fill Grid 2 Executing Initgrid Filling grid Filling roles select 'client' as choice from dual Time elapsed = 2 Preparing axusername-calculate pusername = Field Value - Preparing startdate-accept Result of date = 20/05/2025 Field Value - 20/05/2025 Preparing enddate-accept Field Value - Preparing validrow2-calculate axusergroup = client Result of isempty = F Result of iif = T Field Value - T Grid To JSON 2 Row Count 1 Existing Row Count 0 DC to JSON DC2 Field to JSON axusergroup row 1 Field to JSON startdate row 1 Field to JSON validrow2 row 1 Executing fill Grid 3 Grid To JSON 3 Row Count 1 Existing Row Count 0 Executing fill Grid 4 Grid To JSON 4 Row Count 1 Existing Row Count 0 DC to JSON DC to JSON Quick Form load JSON completed 95 Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"0","r":"0","t":"s"},{"n":"viewfilter","v":" and a1.username <> 'admin' ","r":"0","t":"s"},{"n":"transid","v":"axusr","r":"0","t":"s"},{"n":"pwd","v":"12345","r":"0","t":"s"},{"n":"ppassword","v":"827ccb0eea8a706c4c34a16891f84e7b","r":"0","t":"s"},{"n":"axuser","v":"rekhancia","r":"0","t":"s"},{"n":"build","v":"F","r":"0","t":"s"},{"n":"manage","v":"F","r":"0","t":"s"},{"n":"workflow","v":"F","r":"0","t":"s"},{"n":"send","v":"F","r":"0","t":"s"},{"n":"importstruct","v":"F","r":"0","t":"s"},{"n":"exportstruct","v":"F","r":"0","t":"s"},{"n":"tools","v":"F","r":"0","t":"s"},{"n":"actflag","v":"T","r":"0","t":"s"},{"n":"active","v":"T","r":"0","t":"s"},{"n":"tflag","v":"T","r":"0","t":"s"},{"n":"dhomepage","v":"None","r":"0","idcol":"no","id":"0","oldid":"0","t":"c"},{"n":"homepage","v":"0","r":"0","t":"s"},{"n":"reset_update_flag","v":"F","r":"0","t":"s"},{"n":"otpauth","v":"T","r":"0","t":"s"},{"n":"pwdauth","v":"F","r":"0","t":"s"},{"n":"portal_general_chk","v":"Portal","r":"0","t":"s"},{"n":"DC2","v":"1","cr":"d*,i1","t":"dc","hasdatarows":"yes"},{"n":"axp_recid2","v":"0","r":"1","t":"s"},{"n":"axusergroup","v":"client","r":"1","t":"s"},{"n":"startdate","v":"20/05/2025","r":"1","t":"s"},{"n":"validrow2","v":"T","r":"1","t":"s"}]}*$*{"globalVars":[{"n":"username","v":"rekhancia"}]} Time taken by Quick FormLoad - 109 Quick DoFormLoad webservice completed Freeing DbCall Resources Freeing Store data Freeing DD Map Freeing Provide Link Freeing Validate Freeing Parser Freeing Poststr Freeing Maxrows Freeing Fnames Freeing NewMaxRows Freeing tlines Freeing workquery Freeing Struct Freeing EventList Freeing Tree Obj Freeing Workflow Obj Done - Workflow Obj Freeing DbCall Completed Freeing Action Obj Resources # 1#Saving to log insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('gmyjcxxozanv2o1zo21ssfaf','rekhancia',to_timestamp('20/05/2025 12:53:29','dd/mm/yyyy hh24:mi:ss'),to_timestamp('20/05/2025 12:53:30','dd/mm/yyyy hh24:mi:ss'),'ausrs',0,'Quick Form Load','success',420,38,0) uXDS\pinsert\ Check intransaction Closing connection Freeing AxProvider Resources Freeing DbManager Resources Destroying Default xds in db manager Destroying connect object Disconnecting from db trustlineuat Keep Connection setting false Disconnecting... Disconnected... Dbx name = ConnectionName = DriverName = GetDriverFunc = LibraryName = VendorLib = Successfully disconnected from db trustlineuat Destroyed connect object Destroying GF Getting structure from Cache. Loading tstruct.aspx completed End Time : 20/05/2025 12:53:30