Start Time : 07/08/2024 10:32:00
Get IviewObj from Cache, User: rekhancia Role:
Loading iview.aspx before post back (get and set parameters)
Get Iview Parameters
Call to GetParams Web Service
ASB XE3/32/64 DLL running
[Compiled on 31/07/2024 1:02:00 PM] [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 = 1
select props from axprops where lower(name)='app' order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 4
axprops xml = images\Agile-TrustLine-UAT![]()
INR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2
uXDS\dopen\ Check intransaction
Time elapsed = 3
Db Manager Connection ends
Connection to DB Successful
Executing GetParamsNew webservice
----------------------------------
Received XML + dbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuataxdefdd/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_TLBusiness1025660000000FrekhanciadefaultdefaultFfevgag5szj4b24cs5phvx0utdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218~~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*8/7/2024 10:29:20 am*-2592002218
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=fevgag5szj4b24cs5phvx0ut
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 = 4
Sql : select props from iviews where lower(name)= :name order by blobno
Paramval : cldocume
ParamTYpe : c
Param List : name
select props from iviews where lower(name)= :name order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 4
Step5
select count(*) recno from (select a.* from ( select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T'
order by a.createdon desc )a) aa
Time elapsed = 4
Sql after pagination change :select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T'
order by a.createdon desc LIMIT 100
Opening Query
select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T'
order by a.createdon desc LIMIT 100
Time elapsed = 2
CDS Record Count : 2
Evaluating {PMS}
Result = PMS
Param Name : pfundcode
Param Type : C
Param Value : PMS
select count(*) recno from (select a.* from ( Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T'
order by 1 )a) aa
Time elapsed = 3
Sql after pagination change :Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T'
order by 1 LIMIT 100
Opening Query
Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T'
order by 1 LIMIT 100
Time elapsed = 1
CDS Record Count : 2
Evaluating {Intrinsic}
Result = Intrinsic
Param Name : pschemecode
Param Type : C
Param Value : Intrinsic
CDS Param Name : pfundcode
CDS Param Type : c
CDS Param Value : PMS
pfundcode=PMS
select count(*) recno from (select a.* from ( select a.scheme_code
from fund_scheme_details a
where a.fund_code = :pfundcode
and a.active = 'T'
and a.cancel = 'F'
order by 1 )a) aa
pfundcode=PMS
Time elapsed = 3
Sql after pagination change :select a.scheme_code
from fund_scheme_details a
where a.fund_code = :pfundcode
and a.active = 'T'
and a.cancel = 'F'
order by 1 LIMIT 100
Opening Query
select a.scheme_code
from fund_scheme_details a
where a.fund_code = :pfundcode
and a.active = 'T'
and a.cancel = 'F'
order by 1 LIMIT 100
pfundcode=PMS
Time elapsed = 3
CDS Record Count : 2
Evaluating {Transaction Report}
Result = Transaction Report
Param Name : preporttype
Param Type : C
Param Value : Transaction Report
CDS Param Name : pfundcode
CDS Param Type : c
CDS Param Value : PMS
pfundcode=PMS
CDS Param Name : pschemecode
CDS Param Type : c
CDS Param Value : Intrinsic
pschemecode=Intrinsic
select count(*) recno from (select a.* from ( select unnest(string_to_array(b.report_type, ',')) as reporttype
from fund_scheme_details b
where b.fund_code = :pfundcode
and b.scheme_code = :pschemecode
order by 1 )a) aa
pfundcode=PMS
pschemecode=Intrinsic
Time elapsed = 4
Sql after pagination change :select unnest(string_to_array(b.report_type, ',')) as reporttype
from fund_scheme_details b
where b.fund_code = :pfundcode
and b.scheme_code = :pschemecode
order by 1 LIMIT 100
CDS Param Name : pfundcode
CDS Param Type : c
CDS Param Value : PMS
CDS Param Name : pschemecode
CDS Param Type : c
CDS Param Value : Intrinsic
Opening Query
select unnest(string_to_array(b.report_type, ',')) as reporttype
from fund_scheme_details b
where b.fund_code = :pfundcode
and b.scheme_code = :pschemecode
order by 1 LIMIT 100
pfundcode=PMS
pschemecode=Intrinsic
Time elapsed = 4
CDS Record Count : 3
Evaluating AxpAttachmentPath
AxpAttachmentPath = \\10.16.248.2\UAT_Attachment\UAT_TLReports
Result = \\10.16.248.2\UAT_Attachment\UAT_TLReports
Param Name : mAxpAttachmentPath
Param Type : C
Param Value : \\10.16.248.2\UAT_Attachment\UAT_TLReports
Evaluating usergroup
usergroup = default
Result = default
Param Name : paxusergroup
Param Type : C
Param Value : default
Evaluating username
username = rekhancia
Result = rekhancia
Param Name : pusername
Param Type : C
Param Value : rekhancia
CDS Param Name : pusername
CDS Param Type : c
CDS Param Value : rekhancia
pusername=rekhancia
CDS Param Name : paxusergroup
CDS Param Type : c
CDS Param Value : default
paxusergroup=default
select count(*) recno from (select a.* from ( select a.client_name as choice from client_details a
where a.active = 'T'
and a.cancel = 'F'
and (a.primary_emailid = :pusername
or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%')
union
select 'ALL' as choice from dual
order by 1 )a) aa
pusername=rekhancia
paxusergroup=default
paxusergroup=default
Time elapsed = 19
Sql after pagination change :select a.client_name as choice from client_details a
where a.active = 'T'
and a.cancel = 'F'
and (a.primary_emailid = :pusername
or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%')
union
select 'ALL' as choice from dual
order by 1 LIMIT 100
CDS Param Name : pusername
CDS Param Type : c
CDS Param Value : rekhancia
CDS Param Name : paxusergroup
CDS Param Type : c
CDS Param Value : default
Opening Query
select a.client_name as choice from client_details a
where a.active = 'T'
and a.cancel = 'F'
and (a.primary_emailid = :pusername
or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%')
union
select 'ALL' as choice from dual
order by 1 LIMIT 100
pusername=rekhancia
paxusergroup=default
paxusergroup=default
Time elapsed = 5
CDS Record Count : 65
select username , config_data from axp_smartviews_config where ivname = 'cldocume'
Time elapsed = 2
GetSmartViewSettings Result :
Select cvalue from axpconfigsiv_cldocume where configname= 'groupbtns'
CDS Open Error Msg : csd query : Select cvalue from axpconfigsiv_cldocume where configname= 'groupbtns' $ Error msg : relation "axpconfigsiv_cldocume" does not exist
uXDS\open\ Exceptio relation "axpconfigsiv_cldocume" does not exist
Creating runtime menu
Created runtime menu
Global vars in Params :{"globalVars":[{"n":"AxpAttachmentPath","v":"\\10.16.248.2\UAT_Attachment\UAT_TLReports"},{"n":"username","v":"rekhancia"}]}
Result :Task1pfinancialyearFinancial YearCharacterfalsetrueselect a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T'
order by a.createdon desc 0truefalseSelect325false2024-25
2023-24
Task1pfundcodeFund CodeCharacterfalse{PMS}true Select distinct a1.fund_code from fund_scheme_details a1 where a1.cancel = 'F' and a1.active = 'T'
order by 1
0truefalseSelectpschemecode,preporttype325falseAIF1
PMS
Task1pschemecodeScheme CodeCharacterfalse{Intrinsic}trueselect a.scheme_code
from fund_scheme_details a
where a.fund_code = :pfundcode
and a.active = 'T'
and a.cancel = 'F'
order by 1
0truefalseSelectpreporttype325falseFloater
Intrinsic
Task1preporttypeReport TypeCharacterfalse{Transaction Report}trueselect unnest(string_to_array(b.report_type, ',')) as reporttype
from fund_scheme_details b
where b.fund_code = :pfundcode
and b.scheme_code = :pschemecode
order by 1
0truefalseSelect325falseCapital Gain Report
Performance Report
Transaction Report
Task1mAxpAttachmentPathGlobal File PathCharacterfalseAxpAttachmentPathtrue0truefalseAccept325trueTask1paxusergroupUser RolesCharacterfalseusergrouptrue0truefalseAcceptpclientname325falseTask1pusernameUser NameCharacterfalseusernametrue0truefalseAcceptpclientname325falseTask1pclientnameClient NameCharacterfalsetrueselect a.client_name as choice from client_details a
where a.active = 'T'
and a.cancel = 'F'
and (a.primary_emailid = :pusername
or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%')
union
select 'ALL' as choice from dual
order by 10truefalseSelect325falseA R Chitra
Akhil Vishwanatham
ALL
Amitabh Prasad
Anjalidevi R
Annapoorna J
Anudita Prasad
Aravamudhan Rajesh
Aravindan R
Aruna Aruldass
B S Vijayanand
Balaji Dhandapani
Balaraman Kuppuswamy Jt Suguna Balaraman
Bharat Tanna
C V Kamath
Corporate testing
Deepa Deepak Desai
Eshwari Ravindran Ashok Kumar
Gomathi Ulaganathan
Govind Krishnan Jt Chitra Govind
Inbaraj Rajakumar
Janardhanan Shankar
Jayalakshmi T
Kalyan Raman Bangalore Janakiraman Jt Nishita Meenakshi Kumar
Kosala Raman Bangalore Janakiraman
Krithiga Ramesh
Kumaran Kandasamy
Lakshmi Prabha
Manohar Chandrasekhar
Mathew K Erali
Mythri Associates
N A Somasundari
N Rajadurai Jt Mahalakshmi B
Naithrav Srinivasan
Naozer Cusrow Dalal
Naozer Cusrow Dalal 1
Padmapriya V Jt Sathyanarayanan N B
Padmashri Kodivalasa
Pallipattu Srinivasa Lakshmi Narasa Reddy
Pradeep C R
Pranav Aditya C P Jt Vikram Adithya C P
Prasad Venkatesh Bhatt
Pravin Damodar Karve Jt Vaishali Pravin Karve
R Jayasowmya
Ramamurthy P
Ramanan C
Ramesh Babu C G
S Aramuthan HUF
S G Anjana Shankar
S N Damani Realty Investors LLP
Saravanan Krishnamoorthy Musuvathi
Shanmugavalli Chandrasekaran
Sridevi Prasanna Jt Prasanna Ramanujam
Srikanth N
Srikanth Narasimhan
Srinivas Mani Kolipakkam
Srinivasa Raghavan S
Subbulakshmi Vagulaparanan
Subhadip Sarkar
Sukanya Misra Jt Praphulla Misra
T K Govinda Rajan
Thirukkumaran Nagarajan
Usha Ratnakumari Rajakumar
Venkat Ravi Shankar
Venkata Raghavan S K
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=iview
structure_type=iview
sname=cldocume
sname=cldocume
uname=rekhancia
structure_type=iview
sname=cldocume
structure_type=iview
Time elapsed = 15
GetParamsNew webservice completed
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('fevgag5szj4b24cs5phvx0ut','rekhancia',to_timestamp('07/08/2024 10:32:00','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:32:00','dd/mm/yyyy hh24:mi:ss'),null,0,'Getting IView Params New','success',338,81,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
Loading and setting parameters components
Loading and setting parameters components completed
End Time : 07/08/2024 10:32:01
Loading iview.aspx after post back (get and load iview data)
Get and Load Iviewdata
Call to GetIView Web Service for page no 1
ASB XE3/32/64 DLL running
[Compiled on 31/07/2024 1:02:00 PM] [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 = 2
select props from axprops where lower(name)='app' order by blobno
uXDS\dopen\ Check intransaction
Time elapsed = 4
axprops xml = images\Agile-TrustLine-UAT![]()
INR1FFFsmtp.office365.com587portalneo@trustlineindia.com01trust@123*100000FF
SELECT Constraint_Name FROM AXCONSTRAINTS where 1=2
uXDS\dopen\ Check intransaction
Time elapsed = 3
Db Manager Connection ends
Connection to DB Successful
Executing GetIViewNew webservice
---------------------------------
Received XML : PMSIntrinsicTransaction Report\\10.16.248.2\UAT_Attachment\UAT_TLReportsdefaultrekhanciadbPostgredbxlocalhosttrustlineuat\trustlineuattrustlineuataxdefdd/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_TLBusiness1025660000000FrekhanciadefaultdefaultFfevgag5szj4b24cs5phvx0utdefault~100trustlineuattrustlineuat0defaulthttps://appneo.trustlineindia.biz/trustlineuatwebScripts/trustlineuataxdeftrustlineuaten-us*asia/calcutta^english*8/7/2024 10:29:20 am*-2592002218~~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*8/7/2024 10:29:20 am*-2592002218
axp_appschema=trustlineuat
axp_devschema=trustlineuataxdef
axp_apipath=https://appneo.trustlineindia.biz/trustlineuatwebScripts/
axp_connectionname=trustlineuat
sesid=fevgag5szj4b24cs5phvx0ut
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
>>Reading defintion - cldocume
select a.financialyear_code from financial_years a where a.cancel = 'F' and a.active = 'T'
order by a.createdon desc
Time elapsed = 4
pusername=rekhancia
paxusergroup=default
select a.client_name as choice from client_details a
where a.active = 'T'
and a.cancel = 'F'
and (a.primary_emailid = :pusername
or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%')
union
select 'ALL' as choice from dual
order by 1
pusername=rekhancia
paxusergroup=default
paxusergroup=default
Time elapsed = 8
Initializing Report
Preparing SQL statements
Assigning values to IView parameters
pfinancialyear(c)=
pfinancialyear=
mAxpAttachmentPath(c)=\\10.16.248.2\UAT_Attachment\UAT_TLReports
mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports
mAxpAttachmentPath(c)=\\10.16.248.2\UAT_Attachment\UAT_TLReports
pfundcode(c)=PMS
pfundcode=PMS
pschemecode(c)=Intrinsic
pschemecode=Intrinsic
preporttype(c)=Transaction Report
preporttype=Transaction Report
pfinancialyear(c)=
pusername(c)=rekhancia
pusername=rekhancia
paxusergroup(c)=default
paxusergroup=default
paxusergroup(c)=default
pclientname(c)=default
pclientname=default
pclientname(c)=default
Creating Columns
Creating Columns for first time
Creating financial_yearcode
sourcedocid
sourcefinancial_yearcode
Creating financialyear_code
sourcedocid
sourcefinancial_yearcode
Creating miles_account_code
sourcedocid
sourcefinancial_yearcode
Creating ucc_code
sourcedocid
sourcefinancial_yearcode
Creating client_code
sourcedocid
sourcefinancial_yearcode
Creating fund_code
sourcedocid
sourcefinancial_yearcode
Creating scheme_code
sourcedocid
sourcefinancial_yearcode
Creating report_type
sourcedocid
sourcefinancial_yearcode
Creating subreport_type
sourcedocid
sourcefinancial_yearcode
Creating document_shortdescription
sourcedocid
sourcefinancial_yearcode
Creating axpfile_documentupload
sourcedocid
sourcefinancial_yearcode
Creating client_name
sourcedocid
sourcefinancial_yearcode
Creating mfundcode
sourcedocid
sourcefinancial_yearcode
Creating docid
sourcedocid
sourcefinancial_yearcode
Creating axzipfilepath
sourcedocid
sourcefinancial_yearcode
Creating axzipfiles
sourcedocid
sourcefinancial_yearcode
Creating axzipfilename
sourcedocid
sourcefinancial_yearcode
Creating recordid
sourcedocid
sourcefinancial_yearcode
Creating date_published
sourcedocid
sourcefinancial_yearcode
Creating axpfilepath_documentupload
sourcedocid
sourcefinancial_yearcode
Creating filedocumentupload
sourcedocid
sourcefinancial_yearcode
Creating axp_emailfrom
sourcedocid
sourcefinancial_yearcode
Creating axp_emailto
sourcedocid
sourcefinancial_yearcode
Creating axp_emailsub
sourcedocid
sourcefinancial_yearcode
Creating axp_emailcc
sourcedocid
sourcefinancial_yearcode
Creating axp_emailbcc
sourcedocid
sourcefinancial_yearcode
Creating axpemailtemplate
sourcedocid
sourcefinancial_yearcode
Creating email
sourcedocid
sourcefinancial_yearcode
Creating title
sourcedocid
sourcefinancial_yearcode
Creating notation
sourcedocid
sourcefinancial_yearcode
Creating fincode
sourcedocid
sourcefinancial_yearcode
Creating Columns for first time completed
select
a1.documents_segregationid recordid,
:pfinancialyear as financial_yearcode,
a2.date_published,
a2.financialyear_code, a2.fund_code as mfundcode,
:mAxpAttachmentPath as axpfilepath_documentupload,
a1.axpfile_documentupload,
'download' as filedocumentupload,
a2.docid as docid, a1.miles_account_code, a1.client_code||'-'||a3.client_name as client_code, a1.ucc_code, a3.title, a3.client_name,
a2.fund_code, a2.scheme_code, a2.report_type, a2.subreport_type, a2.notation, a2.fincode,
:mAxpAttachmentPath as AxZIPFilePath, a1.axpfile_documentupload as AxZIPFiles,
concat(a1.miles_account_code, '-', a2.report_type ,'-', current_date) as AxZipFileName,
a2.document_shortdescription,
'devipriya@agile-labs.com' as Axp_EMailFrom,
a3.primary_emailid as Axp_EMailTo,concat('TrustLine UAT App : ','FY ', a2.fincode,' ', a2.notation, ' ', a2.subreport_type,' ', a2.scheme_code) as Axp_EMailSub,
a3.secondary_emailid as Axp_EMailCC,
a3.cc_mailid1 as Axp_EMailBCC ,
(select concat(replace(caption, ' ', '_'), '_', replace(name, 'HP', ''), '.html') as htmlfilename from axpages
where lower(caption) = lower('emailrepTransactionreport')
and name like 'HP%') as AxpEmailTemplate,'Email' as Email
from documents_segregation a1,
(select a2.*, a3.financialyear_code as fincode, a3.financialyear_startdate, a3.financialyear_enddate
from documents_uploads a2, financial_years a3
where
a2.cancel = 'F'
and a2.active = 'T'
and ((current_date BETWEEN a2.validity_datefrom and a2.validity_dateto) or (a2.validity_datefrom <= current_date and a2.validity_dateto is null))
and ( :pfundcode like '%'|| a2.fund_code||'%' )
and ( :pschemecode like '%'|| a2.scheme_code||'%')
and ( :preporttype like '%'|| a2.report_type||'%')
and a2.financialyear_code = a3.financial_yearsid
and a3.financialyear_code = :pfinancialyear
) a2,
client_details a3
where a1.docid = a2.documents_uploadsid
and a1.client_code = a3.client_code
and a2.cancel = 'F'
and a1.active = 'T'
and lower(a1.client_code) not like 'invalid%'
and (a3.primary_emailid = :pusername
or lower( :paxusergroup ) like '%default%' or lower( :paxusergroup ) like '%trustlineadmin%')
and (a3.client_name = :pclientname or :pclientname = 'ALL')
order by a1.miles_account_code,a2.date_published desc
LIMIT 25
pfinancialyear=
mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports
mAxpAttachmentPath=\\10.16.248.2\UAT_Attachment\UAT_TLReports
pfundcode=PMS
pschemecode=Intrinsic
preporttype=Transaction Report
pfinancialyear=
pusername=rekhancia
paxusergroup=default
paxusergroup=default
pclientname=default
pclientname=default
Time elapsed = 21
Time elapsed = 21
Copying result to grid
Row 1
Evaluating column values
financial_yearcode =
financial_yearcode =
financialyear_code = 0
financialyear_code = 0
miles_account_code =
miles_account_code =
ucc_code =
ucc_code =
client_code =
client_code =
fund_code =
fund_code =
scheme_code =
scheme_code =
report_type =
report_type =
subreport_type =
subreport_type =
document_shortdescription =
document_shortdescription =
axpfile_documentupload =
axpfile_documentupload =
client_name =
client_name =
mfundcode =
mfundcode =
docid =
docid =
axzipfilepath =
axzipfilepath =
axzipfiles =
axzipfiles =
axzipfilename =
axzipfilename =
recordid = 0
recordid = 0
date_published =
date_published =
axpfilepath_documentupload =
axpfilepath_documentupload =
filedocumentupload =
filedocumentupload =
axp_emailfrom =
axp_emailfrom =
axp_emailto =
axp_emailto =
axp_emailsub =
axp_emailsub =
axp_emailcc =
axp_emailcc =
axp_emailbcc =
axp_emailbcc =
axpemailtemplate =
axpemailtemplate =
email =
email =
title =
title =
notation =
notation =
fincode =
fincode =
First Heading
Headrow :
Creating Row
Row No1 Created
Displaying columns
Column Name : financial_yearcode
Column Value :
Column Name : financialyear_code
Column Value : 0
Column Name : miles_account_code
Column Value :
Column Name : ucc_code
Column Value :
Column Name : client_code
Column Value :
Column Name : fund_code
Column Value :
Column Name : scheme_code
Column Value :
Column Name : report_type
Column Value :
Column Name : subreport_type
Column Value :
Column Name : document_shortdescription
Column Value :
Column Name : axpfile_documentupload
Column Value :
Column Name : client_name
Column Value :
Column Name : mfundcode
Column Value :
Column Name : docid
Column Value :
Column Name : axzipfilepath
Column Value :
Column Name : axzipfiles
Column Value :
Column Name : axzipfilename
Column Value :
Column Name : recordid
Column Value : 0
Column Name : date_published
Column Value :
Column Name : axpfilepath_documentupload
Column Value :
Column Name : filedocumentupload
Column Value :
Column Name : axp_emailfrom
Column Value :
Column Name : axp_emailto
Column Value :
Column Name : axp_emailsub
Column Value :
Column Name : axp_emailcc
Column Value :
Column Name : axp_emailbcc
Column Value :
Column Name : axpemailtemplate
Column Value :
Column Name : email
Column Value :
Column Name : title
Column Value :
Column Name : notation
Column Value :
Column Name : fincode
Column Value :
Rehiding column financial_yearcode
Rehiding column financialyear_code
Rehiding column miles_account_code
Rehiding column ucc_code
Rehiding column client_code
Rehiding column fund_code
Rehiding column scheme_code
Rehiding column report_type
Rehiding column subreport_type
Rehiding column document_shortdescription
Rehiding column axpfile_documentupload
Rehiding column client_name
Rehiding column mfundcode
Rehiding column docid
Rehiding column axzipfilepath
Rehiding column axzipfiles
Rehiding column axzipfilename
Rehiding column recordid
Rehiding column date_published
Rehiding column axpfilepath_documentupload
Rehiding column filedocumentupload
Rehiding column axp_emailfrom
Rehiding column axp_emailto
Rehiding column axp_emailsub
Rehiding column axp_emailcc
Rehiding column axp_emailbcc
Rehiding column axpemailtemplate
Rehiding column email
Rehiding column title
Rehiding column notation
Rehiding column fincode
Storing subtotals
Storing subtotals at : E:\Axpert113\Axpert Web\AxpertWebScripts\Axpert\fevgag5szj4b24cs5phvx0ut\cldocume.lst
Time elapsed = 114
Total Time elapsed = 246
Creating Report Header/Footer
Creating Report Header/Footer over
select cvalue, elements from templates where type='Iview' and iviewid = 'cldocume'
Time elapsed = 4
Iview result :{"data":{"reporthf":{"hideprojname":"@f","hidereportdate":"@f","header":{"h1":{"font":"@clBlack,12,,T","header_aline":"@center","text":" cldocume"}}},"headrow":{"rowno":{"@hide":"false"},"axrowtype":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axrowtype"},"axp__font":{"@hide":"true","@width":"80","@dec":"0","@type":"c","#text":"axp__fontdetails"},"financial_yearcode":{"#text":"Financial Year","@width":"79","@dec":"0","@align":"Left","@type":"c","@hlink":"tdocup","@pop":"True","@hltype":"open","@parentrefresh":"true","@map":"fund_code=:fund_code","@freezecol":"F","@hide":"true"},"financialyear_code":{"#text":"Financial Year","@width":"111","@dec":"0","@align":"Right","@type":"n","@freezecol":"F","@hide":"true"},"miles_account_code":{"#text":"MILES Account Code","@width":"85","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"ucc_code":{"#text":"UCC Code","@width":"119","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"client_code":{"#text":"Client Code/Name","@width":"269","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"fund_code":{"#text":"Fund Code","@width":"79","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"scheme_code":{"#text":"Scheme Name","@width":"98","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"report_type":{"#text":"Report Type","@width":"143","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"subreport_type":{"#text":"Sub Report Type","@width":"160","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"document_shortdescription":{"#text":"Report Description","@width":"429","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"axpfile_documentupload":{"#text":"Download","@width":"69","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"client_name":{"#text":"Client Name","@width":"217","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"mfundcode":{"#text":"mfundcode","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"docid":{"#text":"Document#","@width":"150","@dec":"0","@align":"Center","@type":"c","@hlink":"tdocup","@pop":"True","@hltype":"open","@parentrefresh":"true","@map":"financialyear_code=:pfinancialyear","@freezecol":"F","@hide":"true"},"axzipfilepath":{"#text":"axzipfilepath","@width":"82","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfiles":{"#text":"axzipfiles","@width":"70","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axzipfilename":{"#text":"axzipfilename","@width":"88","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"recordid":{"#text":"recordid","@width":"67","@dec":"0","@align":"Right","@type":"n","@freezecol":"F","@hide":"true"},"date_published":{"#text":"Published On","@width":"92","@dec":"0","@align":"Left","@type":"d","@freezecol":"F","@hide":"false"},"axpfilepath_documentupload":{"#text":"axpfilepath_documentupload","@width":"184","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"filedocumentupload":{"#text":"filedocumentupload","@width":"128","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailfrom":{"#text":"axp_emailfrom","@width":"94","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailto":{"#text":"axp_emailto","@width":"83","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailsub":{"#text":"axp_emailsub","@width":"86","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailcc":{"#text":"axp_emailcc","@width":"83","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axp_emailbcc":{"#text":"axp_emailbcc","@width":"86","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"axpemailtemplate":{"#text":"axpemailtemplate","@width":"176","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"email":{"#text":"Email","@width":"47","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"false"},"title":{"#text":"title","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"notation":{"#text":"notation","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"},"fincode":{"#text":"fincode","@width":"80","@dec":"0","@align":"Left","@type":"c","@freezecol":"F","@hide":"true"}},"row":[{"rowno":"1","financial_yearcode":"","financialyear_code":"0","miles_account_code":"","ucc_code":"","client_code":"","fund_code":"","scheme_code":"","report_type":"","subreport_type":"","document_shortdescription":"","axpfile_documentupload":"","client_name":"","mfundcode":"","docid":"","axzipfilepath":"","axzipfiles":"","axzipfilename":"","recordid":"0","date_published":"","axpfilepath_documentupload":"","filedocumentupload":"","axp_emailfrom":"","axp_emailto":"","axp_emailsub":"","axp_emailcc":"","axp_emailbcc":"","axpemailtemplate":"","email":"","title":"","notation":"","fincode":""}]},"reccount":{"reccount":"1"},"actualrows":{"actualrows":"0"}}#$?#{"templete": [{"CVALUE": "download{{{axpfile_documentupload}}}
","ELEMENTS": "axpfile_documentupload"},{"CVALUE": "email
","ELEMENTS": "axp_emailto"},{"CVALUE": "email
","ELEMENTS": "email"}]}
GetIView webservice completed
Time Used : 45.9914389118982 secs
# 1#Saving to log
insert into axpertlog (sessionid,username,calledon,callfinished,structname,recordid,servicename,serviceresult,timetaken,dbtimetaken,db_conntime) values ('fevgag5szj4b24cs5phvx0ut','rekhancia',to_timestamp('07/08/2024 10:32:01','dd/mm/yyyy hh24:mi:ss'),to_timestamp('07/08/2024 10:32:02','dd/mm/yyyy hh24:mi:ss'),'cldocume',0,'Get IView New','success',482,49,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
End Time : 07/08/2024 10:32:02