Start Time : 26/05/2025 12:37:06 Loading Structure. Get Struct from Cache Manager. User: rekhancia Role: default Getting Structure from Redis rekhancia Role: default Getting structure from Cache. 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 = 1 select props from axprops where lower(name)='app' order by blobno uXDS\dopen\ Check intransaction Time elapsed = 4 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/26/2025 12:21:16 pm* axp_appschema=trustlineuat axp_devschema=trustlineuataxdef axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/ axp_connectionname=trustlineuat sesid=kfqfvoooa5vo3qsqy3vpyysl 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 Portalclient162:Prasad Venkatesh Bhatt26/05/202511prasadbhatt@gmail.comPrasad Venkatesh Bhatt11prasadbhatt@gmail.com196502239845390928dbPostgredbxlocalhosttrustlineuat\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_TLBusiness1025660000000FrekhanciadefaultdefaultFkfqfvoooa5vo3qsqy3vpyysldefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*5/26/2025 12:21:16 pm*~~9867~25~0~0~1~R~false~RccccncccccE:\Axpert113\Axpert Web\AxpertWebScripts Received SXML axusrUser LogintTrueTrueFalseFalseFalseNoneDefaultFalsedc1User Login1axusersFalseTrueTrueTrueTrueFalsetransidtransidCharacter50Accept00TrueFalseFalseTrueTrueFalseFalseTrue{axusr}TrueFalseFalseFalseFalseTrueTruetransidusernameasemailidusernameasemailidCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeemailTrueusernameasemailid~email,pusernameusertypeUser TypeCharacter200Select00FalseFalseADMINTrueTrueFalseFalseTrue{ADMIN}TrueTrueFalseFalseTrueTrueTrueusertypeportal_general_chkPortal/GeneralCharacter1000Select00FalseFalsePortalGeneralFalseTrueTrueFalseTrue{General}TrueTrueFalseFalseTrueTrueeallusergroup,saxusergroup,evalidrow2Trueportal_general_chk~allusergroup,axusergroup,validrow2pusernameEmail ID/Login IDCharacter300Accept00FalseFalseFalseFalseFalseFalseFalseTrueiif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T})FalseTrueFalseFalseTrueTrueeemail,sclient_details,eaxusernameFor login purposeTruepusername~email,usernameasemailid,client_details,axusernamepwdPasswordCharacter150Accept00FalseFalseFalseTrueTrueFalseFalseFalse{12345}TrueTrueFalseFalseTrue*TrueeppasswordTruepwd~ppasswordnicknameFirst NameCharacter2000Accept00FalseFalseFalseFalseFalseFalseFalseTrueTrueTrueFalseFalseTrueTrueTruenicknameppasswordpasswordCharacter500calculate00TrueTrueFalseFalseTrueiif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword)TrueTrueFalseFalseTrueTrueTrueppassword,pwdaxuseraxuserCharacter250calculate00TrueTrueFalseFalseFalseusernameTrueTrueFalseFalseTrueTrueTrueaxusergroupnousergroupnumberNumeric70Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruegroupnoemailE-mailCharacter2540Accept00FalseFalseFalseFalseTrueFalseFalseTrueiif(usernameasemailid={T},pusername,email)FalseTrueFalseFalseTrueTrue*@*.*Trueemail,usernameasemailid,pusernamemobileMobileCharacter100Accept00FalseFalseFalseFalseTrueFalseFalseTrueiif(((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}))TrueTrueFalseFalseTrueTrueTruemobileclient_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,pusernamedepartmentDepartmentCharacter1000Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruedepartmentbuildEnable TraceCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueedebugTruebuild~debugdebugDebugCharacter10calculate00FalseTrueFalseFalseTruebuildTrueTrueFalseFalseTrueTrueTruedebug,buildmanageUsersCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruemanageworkflowEnable WorkflowCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueworkflowlogin_usernamelogin_usernameCharacter500calculate00TrueTrueFalseFalseTrueusernameTrueFalseFalseFalseFalseTrueelogin_usergroup,slogin_usergroupTruelogin_username~login_usergrouplogin_usergrouplogin_usergroupCharacter500Acceptselect b.axusergroup from axusers a , axuserlevelgroups b where a.axusersid = b.axusersid and a.pusername = :login_username 00TrueFalseFalseTrueTrueFalseFalseTrueusergroupTrueFalseFalseFalseFalseTrueTruelogin_usergroup,login_usernamesendSend/ReceiveCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruesendimportstructImport StructuresCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueimportstructisfirsttimeisfirsttimeCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueisfirsttimepageaccesspageaccessCharacter2500Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepageaccessreportingtoreportingtoCharacter300Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruereportingtowebskinwebskinCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruewebskinlogintrylogintryNumeric20Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelogintrypwdexpdayspwdexpdaysNumeric30Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruepwdexpdayslanguage_accesslanguage_accessCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguage_accesslanguagelanguageCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTruelanguageexportstructExport StructureCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueexportstructaxpertmanagerAxpertmanagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueaxpertmanageraccesscodeaccesscodeCharacter250Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueaccesscodeappparamsappparamsCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappparamsappmanagerApp ManagerCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueappmanagertoolsToolsCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTruetoolsactflagActiveCharacter10Accept00FalseFalseFalseFalseTrueFalseFalseTrue{T}TrueTrueFalseFalseTrueTrueeactiveTrueactflag~activeactiveActiveCharacter10calculate00TrueTrueFalseFalseTrueactflagTrueTrueFalseFalseTrueTrueTrueactive,actflagallusergroupallusergroupCharacter20000calculate00TrueTrueFalseFalseTruegetallvalues({axusergroup},{F})TrueTrueFalseFalseTrueTrueTrueallusergroup,axusergroupviewfilterviewfilterCharacter20000calculate00TrueTrueTrueFalseFalse{and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )} TrueFalseFalseFalseFalseTrueTrueviewfiltertflagtflagCharacter10Accept00FalseFalseFalseTrueTrueFalseFalseFalse{T}TrueTrueFalseFalseTrueTrueTruetflagglobal_displaytextGlobal DisplaytextCharacter3000Accept00FalseFalseFalseTrueTrueFalseFalseTrueTrueTrueFalseFalseTrueTrueTrueglobal_displaytextdhomepageHome PageCharacter2000SelectSELECT caption, name, props 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,caption00TrueTrueFalseTrueFalseFalseTrueTrueTrueFalseFalseTrueTruefhomepageTruedhomepage~homepagehomepageCharacter2000Fill00dhomepageHOMEPAGEFalseTrueTrueTrueFalseTrueTrueTrueFalseFalseTrueFalseFalsehomepage,dhomepageisIpIs IP authentication required?Character10Accept00FalseFalseFalseTrueTrueFalseFalseTrue{F}TrueTrueFalseFalseTrueTrueTrueisIpreset_update_flagReset/UpdateCharacter10Accept00TrueFalseFalseTrueTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruereset_update_flagipaddrIP AddressCharacter10000Accept00FalseFalseFalseTrueTrueFalseFalseTrueiif(((getlength(ipaddr) = 0) & (isIp = {T})),{ cannot be left empty},{T})TrueTrueFalseFalseTrueTrueTrueipaddraxcloudtriggeraxcloudtriggerCharacter1000Acceptselect 'ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE' AS TR from dual00TrueTrueFalseTrueTrueFalseFalseFalseTrueTrueFalseFalseTrueTrueTrueaxcloudtriggerreporting_toReporting toCharacter500Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTruereporting_toempidEmployee IdCharacter1000Accept00TrueFalseFalseTrueTrueFalseFalseTrueTrueFalseFalseFalseFalseTrueTrueempidotpauthOTP AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{T}TrueFalseFalseFalseFalseTrueTrueotpauthpwdauthPassword AuthenticationCharacter10Accept00TrueFalseFalseFalseTrueFalseFalseTrue{F}TrueFalseFalseFalseFalseTrueTruepwdauthdc2Roles2axuserlevelgroupsTrueTrueFalseTrueTrueFalseaxusernameaxusernameCharacter1000calculate00TrueTrueFalseFalseTruepusernameTrueTrueFalseFalseTrueTrueTrueaxusername,pusernameaxusergroupRoleCharacter300Selectselect Role, GROUPNO from (SELECT GROUPNAME as Role, GROUPNO FROM AXUSERGROUPS a1 where a1.groupname <> 'admin' and :usergroup in ('default','admin') UNION select GROUPNAME as Role, GROUPNO from axusergroups a1 where :usergroup not in ('default','admin') and a1.groupname not in ('default','admin') and a1.active = 'T' union select GROUPNAME as Role, GROUPNO from axusergroups a1 where a1.groupname in ('client') and :portal_general_chk = 'Portal' )a ORDER BY Role00TrueTrueFalseFalseFalseFalseTrueFalseTrueFalseFalseTrueTrueevalidrow2,eallusergroupTrueaxusergroup,portal_general_chk~validrow2,allusergroupstartdateStart DateDate/Time100Accept00FalseTrueFalseFalseFalseFalseFalseTrueDate()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,axusergroup,portal_general_chkif portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) AxDisableControls({startdate})end if if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) AxDisableControls({startdate})end if removematerial-iconslistmaterial-iconslistmaterial-iconsfact_checkmaterial-iconsdc1dc2activeF1enddate:currentdate0pusernamepusername,FalseFalseUser ImportusimpFalsetypecalc Equal to TFalseEnablevvipaccess''1FalseDisablefusertypeciftypecalcetT1vvipaccesscelse3vvipaccess3''2vvipaccessFalseHideFalseDisable Creating DbCall Evaluating {axusr} Result = Evaluating pusername Result = Evaluating {T} Result = Evaluating {ADMIN} Result = Evaluating {General} Result = Evaluating {12345} Result = Evaluating iif( recordid = 0, iif(axp_md5pwd = {T},convertmd5(pwd), Encryptstr(pwd)), ppassword) Result = Evaluating username Result = Evaluating iif(usernameasemailid={T},pusername,email) Result = Evaluating {F} Result = Evaluating build Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating username Result = Evaluating usergroup 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 {and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )} Result = Evaluating {T} Result = Evaluating {F} Result = Evaluating {F} Result = Evaluating {T} Result = Evaluating {F} Result = Evaluating Date() Result = Evaluating IIF( (isempty( axusergroup) = {F} & isempty( startdate) = {T}), {Assigned From should be specified for Additional Roles}, {T}) Result = Evaluating iif(isempty(axusergroup)={F},{T},{F}) Result = Evaluating iif(getlength(pusername) < 4,{User ID should have minmum length of 4 digits},{T}) Result = Submiting & Registering data Registering Global variables data Registering Global variables data over Evaluating iif(((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})) Result = Setting values over Creating Action object Time taken to connect and submit - 271 Action node in structure : FalseHide Starting Action Execution - OnFormLoad Executing task - field access checkFillGrid : Visible dcs :'dc1','dc2' Executing task field access over Action Execution over - OnFormLoad Action node in structure : if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) AxDisableControls({startdate})end if Starting Action Execution - script1 Executing task - scripts Assigning expression set to parser Expression : if portal_general_chk = {Portal} AxHideControls({dhomepage}) AxHideControls({build}) AxHideControls({tools}) AxHideControls({workflow}) AxHideControls({importstruct}) AxHideControls({exportstruct}) AxHideControls({manage}) AxHideControls({debug}) AxDisableControls({pusername}) AxDisableControls({axusergroup}) AxDisableControls({startdate}) end if Evaluating portal_general_chk = {Portal} portal_general_chk = Portal Result = 1 Evaluating AxHideControls({dhomepage}) Result = Evaluating AxHideControls({build}) Result = Evaluating AxHideControls({tools}) Result = Evaluating AxHideControls({workflow}) Result = Evaluating AxHideControls({importstruct}) Result = Evaluating AxHideControls({exportstruct}) Result = Evaluating AxHideControls({manage}) Result = Evaluating AxHideControls({debug}) Result = Evaluating AxDisableControls({pusername}) Result = Evaluating AxDisableControls({axusergroup}) Result = Evaluating AxDisableControls({startdate}) Result = Executing task scripts over Action Execution over - script1 Quick Form Load JSON Executing fill Grid 1 Preparing transid-accept Field Value - axusr DC to JSON DC1 Field to JSON transid row 1 Preparing usernameasemailid-accept Field Value - T Field to JSON usernameasemailid row 1 Preparing usertype-select Field Value - ADMIN Field to JSON usertype row 1 Preparing portal_general_chk-select Field Value - Portal Field to JSON portal_general_chk row 1 Preparing pusername-accept Field Value - 11prasadbhatt@gmail.com Field to JSON pusername row 1 Preparing pwd-accept Field Value - 19650223 Field to JSON pwd row 1 Preparing nickname-accept Field Value - Prasad Venkatesh Bhatt Field to JSON nickname row 1 Preparing ppassword-calculate pwd = 19650223 Result of encryptstr = 080000006F6E32F17AF05D135CC78E27B369D832 pwd = 19650223 Result of convertmd5 = bb5c27ae4b59765255ea30d68a01a116 axp_md5pwd = T Result of iif = bb5c27ae4b59765255ea30d68a01a116 recordid = 0 ppassword = Result of iif = bb5c27ae4b59765255ea30d68a01a116 Field Value - bb5c27ae4b59765255ea30d68a01a116 Field to JSON ppassword row 1 Preparing axuser-calculate username = rekhancia Field Value - rekhancia Field to JSON axuser row 1 Preparing email-accept Field Value - 11prasadbhatt@gmail.com Field to JSON email row 1 Preparing mobile-accept Field Value - 9845390928 Field to JSON mobile row 1 Preparing client_details-accept Field Value - 162:Prasad Venkatesh Bhatt Field to JSON client_details row 1 Preparing build-accept Field Value - F Field to JSON build row 1 Preparing debug-calculate build = F Field Value - F Field to JSON debug 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 login_username-calculate username = rekhancia Field Value - rekhancia Field to JSON login_username row 1 Preparing login_usergroup-accept usergroup = default login_username=rekhancia select b.axusergroup from axusers a , axuserlevelgroups b where a.axusersid = b.axusersid and a.pusername = :login_username login_username=rekhancia Time elapsed = 6 Query opened , Record count : 1 Field Value - default Field to JSON login_usergroup 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 isfirsttime-accept Field Value - F Field to JSON isfirsttime row 1 Preparing exportstruct-accept Field Value - F Field to JSON exportstruct row 1 Preparing axpertmanager-accept Field Value - F Field to JSON axpertmanager 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 = client Field Value - client Field to JSON allusergroup row 1 Preparing viewfilter-calculate Field Value - and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' ) Field to JSON viewfilter row 1 Preparing tflag-accept Field Value - T Field to JSON tflag row 1 Preparing dhomepage-select SELECT caption, name, props 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 = 6 Query opened , Record count : 15 Field Value - Preparing homepage-fill Field Value - Preparing isIp-accept Field Value - F Field to JSON isIp row 1 Preparing reset_update_flag-accept Field Value - F Field to JSON reset_update_flag row 1 Preparing axcloudtrigger-accept select 'ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE' AS TR from dual Time elapsed = 2 Query opened , Record count : 1 Field Value - ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE Field to JSON axcloudtrigger row 1 Preparing otpauth-accept Field Value - T Field to JSON otpauth row 1 Preparing pwdauth-accept Field Value - F Field to JSON pwdauth row 1 Executing fill Grid 2 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 Quick Form load JSON completed 91 Result : {"data":[{"n":"DC1","v":"1","t":"dc"},{"n":"axp_recid1","v":"0","r":"0","t":"s"},{"n":"transid","v":"axusr","r":"0","t":"s"},{"n":"usernameasemailid","v":"T","r":"0","t":"s"},{"n":"usertype","v":"ADMIN","r":"0","t":"c"},{"n":"portal_general_chk","v":"Portal","r":"0","t":"c"},{"n":"pusername","v":"11prasadbhatt@gmail.com","r":"0","t":"s"},{"n":"pwd","v":"19650223","r":"0","t":"s"},{"n":"nickname","v":"Prasad Venkatesh Bhatt","r":"0","t":"s"},{"n":"ppassword","v":"bb5c27ae4b59765255ea30d68a01a116","r":"0","t":"s"},{"n":"axuser","v":"rekhancia","r":"0","t":"s"},{"n":"email","v":"11prasadbhatt@gmail.com","r":"0","t":"s"},{"n":"mobile","v":"9845390928","r":"0","t":"s"},{"n":"client_details","v":"162:Prasad Venkatesh Bhatt","r":"0","t":"m"},{"n":"build","v":"F","r":"0","t":"s"},{"n":"debug","v":"F","r":"0","t":"s"},{"n":"manage","v":"F","r":"0","t":"s"},{"n":"workflow","v":"F","r":"0","t":"s"},{"n":"login_username","v":"rekhancia","r":"0","t":"s"},{"n":"login_usergroup","v":"default","r":"0","t":"s"},{"n":"send","v":"F","r":"0","t":"s"},{"n":"importstruct","v":"F","r":"0","t":"s"},{"n":"isfirsttime","v":"F","r":"0","t":"s"},{"n":"exportstruct","v":"F","r":"0","t":"s"},{"n":"axpertmanager","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":"allusergroup","v":"client","r":"0","t":"s"},{"n":"viewfilter","v":"and((position( 'default' in lower( :usergroup )) = 0 and position ( 'default' in lower( a1.allusergroup)) =0 ) or position ( 'default' in lower ( :usergroup )) != 0 and ?portal_general_chk = 'General' )","r":"0","t":"s"},{"n":"tflag","v":"T","r":"0","t":"s"},{"n":"isIp","v":"F","r":"0","t":"s"},{"n":"reset_update_flag","v":"F","r":"0","t":"s"},{"n":"axcloudtrigger","v":"ALTER TRIGGER TR_AXCLOUD_USER_CREATION ENABLE","r":"0","t":"s"},{"n":"otpauth","v":"T","r":"0","t":"s"},{"n":"pwdauth","v":"F","r":"0","t":"s"},{"n":"DC2","v":"1","cr":"i1","t":"dc","hasdatarows":"no"},{"n":"axp_recid2","v":"0","r":"1","t":"s"},{"n":"axusergroup","v":"client","r":"1","idcol":"no","id":"0","oldid":"0","mr":"1","t":"c"},{"n":"startdate","v":"26/05/2025","r":"1","t":"s"}]}*$*{"formcontrol":[{"readonlytrans":"no"},{"dc":"dc5","dcact":"hide"},{"fldname":"pwd000F0","fldact":"enable"}]}*$*{"globalVars":[{"n":"username","v":"rekhancia"}]} Time taken by Quick FormLoad - 129 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 ('kfqfvoooa5vo3qsqy3vpyysl','rekhancia',to_timestamp('26/05/2025 12:37:06','dd/mm/yyyy hh24:mi:ss'),to_timestamp('26/05/2025 12:37:06','dd/mm/yyyy hh24:mi:ss'),'axusr',0,'Quick Form Load','success',415,24,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 : 26/05/2025 12:37:06