Home Explore Help
Register Sign In
dbs289
/
ConsentDemoServer
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 48a9dbbbc5
Branches Tags
ConsentDemoS...
/
CLIP.e-Form.Consent.Web
/
Logs
/
eFormServer.iBATIS.log_2018-04-20

eFormServer.iBATIS.log_2018-04-20 5.0 KB
History Raw

123456789101112131415161718 
  1. 

  2. [Logging Date Time: 2018-04-20 09:07:40,143] =====================================================================================
    3. 

  3. SQL Command - Statement Id: [getDiagList] PreparedStatement : [SELECT term.diaghngnm             FROM emr.mmohdiag diag,                 emr.mmbvdiag term,                 pam.pmihinpt inpt           WHERE inpt.instcd =  :param0                  AND inpt.pid =  :param1                  AND inpt.indd =  :param2                  AND inpt.histstat = 'Y'                 AND inpt.mskind = 'M'                 AND inpt.pid = diag.pid                 AND inpt.indd = diag.orddd                 AND diag.cretno = inpt.cretno                 AND diag.instcd = inpt.instcd                 AND diag.instcd = term.instcd                 AND diag.diagcd = term.orgdiagcd                 AND diag.diaghistcd = 'O'                 AND diag.diagtypecd = 'D'                 AND diag.diagdd >= term.termfromdd                 AND diag.diagdd <= term.termtodd                 AND diag.diagdd >= term.diagattrfromdd                 AND diag.diagdd <= term.diagattrtodd                 AND diag.genrflagcd in ('I','E')          union all          SELECT term.diaghngnm as diaghngnm            FROM emr.mmohdiag diag,                 emr.mmbvdiag term,                 pam.pmohotpt otpt           WHERE otpt.instcd =  :param0                  AND otpt.pid =  :param1                  AND otpt.orddd =  :param2                  AND otpt.pid = diag.pid                 AND otpt.orddd = diag.orddd                 AND diag.cretno = otpt.cretno                 AND diag.instcd = otpt.instcd                 AND diag.instcd = term.instcd                 AND diag.diagcd = term.orgdiagcd                 AND diag.diaghistcd = 'O'                 AND diag.diagtypecd = 'D'                 AND diag.diagdd >= term.termfromdd                 AND diag.diagdd <= term.termtodd                 AND diag.diagdd >= term.diagattrfromdd                 AND diag.diagdd <= term.diagattrtodd                 AND diag.genrflagcd in ('O','S')]
    4. 

  4. 

  5. [Logging Date Time: 2018-04-20 09:07:40,143] =====================================================================================
    6. 

  6. SQL Command - Statement Id: [getDiagList] PreparedStatement : [SELECT term.diaghngnm             FROM emr.mmohdiag diag,                 emr.mmbvdiag term,                 pam.pmihinpt inpt           WHERE inpt.instcd =  :param0                  AND inpt.pid =  :param1                  AND inpt.indd =  :param2                  AND inpt.histstat = 'Y'                 AND inpt.mskind = 'M'                 AND inpt.pid = diag.pid                 AND inpt.indd = diag.orddd                 AND diag.cretno = inpt.cretno                 AND diag.instcd = inpt.instcd                 AND diag.instcd = term.instcd                 AND diag.diagcd = term.orgdiagcd                 AND diag.diaghistcd = 'O'                 AND diag.diagtypecd = 'D'                 AND diag.diagdd >= term.termfromdd                 AND diag.diagdd <= term.termtodd                 AND diag.diagdd >= term.diagattrfromdd                 AND diag.diagdd <= term.diagattrtodd                 AND diag.genrflagcd in ('I','E')          union all          SELECT term.diaghngnm as diaghngnm            FROM emr.mmohdiag diag,                 emr.mmbvdiag term,                 pam.pmohotpt otpt           WHERE otpt.instcd =  :param0                  AND otpt.pid =  :param1                  AND otpt.orddd =  :param2                  AND otpt.pid = diag.pid                 AND otpt.orddd = diag.orddd                 AND diag.cretno = otpt.cretno                 AND diag.instcd = otpt.instcd                 AND diag.instcd = term.instcd                 AND diag.diagcd = term.orgdiagcd                 AND diag.diaghistcd = 'O'                 AND diag.diagtypecd = 'D'                 AND diag.diagdd >= term.termfromdd                 AND diag.diagdd <= term.termtodd                 AND diag.diagdd >= term.diagattrfromdd                 AND diag.diagdd <= term.diagattrtodd                 AND diag.genrflagcd in ('O','S')]
    7. 

  7. 

  8. [Logging Date Time: 2018-04-20 09:07:40,160] =====================================================================================
    9. 

  9. SQL Command - Statement Id: [getDiagList] Parameters: [param0=[instcd,], param1=[pid,], param2=[orddd,]]
    10. 

  10. 

  11. [Logging Date Time: 2018-04-20 09:07:40,160] =====================================================================================
    12. 

  12. SQL Command - Statement Id: [getDiagList] Parameters: [param0=[instcd,], param1=[pid,], param2=[orddd,]]
    13. 

  13. 

  14. [Logging Date Time: 2018-04-20 09:07:40,160] =====================================================================================
    15. 

  15. SQL Command - Statement Id: [getDiagList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    16. 

  16. 

  17. [Logging Date Time: 2018-04-20 09:07:40,160] =====================================================================================
    18. 

  18. SQL Command - Statement Id: [getDiagList] Types: [param0=[AnsiString, System.String], param1=[AnsiString, System.String], param2=[AnsiString, System.String]]
    19.