API tools faq
paste
Advertisement
doranchak

Untitled

doranchak
Oct 31st, 2019
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 107.95 KB | None | 0 0
raw download clone embed print report
  1. Buildfile: /Users/doranchak/projects/harmony_gwt/build.xml
  2.  
  3. define-classpaths:
  4. [echo] jboss_server_lib.dir = ./bin/jboss/server/default/lib
  5.  
  6. transactionTiming:
  7. [java] Scanning log file [/Users/doranchak/projects/harmony_gwt/bin/jboss/server/default/log/server.log.2019-10-28]...
  8. [java] WARNING: Can't get id for thread: 80-3 (line: 2019-10-28 15:30:14,016 INFO [STDOUT] === 2019-10-28 15:30:14,016 [80-3] DEBUG HibernateDataSource - Looking up session factory with lookup style 'spring')
  9. [java] ms transactionId dataSource
  10. [java] 7590 874869866 PicklistValueDAODS_fetch 15:30:14,047 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1]
  11. [java] 1675 829729191 PicklistValueDAODS_fetch 15:31:11,894 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: TrialPhaseReason]
  12. [java] 1655 1385382625 PicklistValueDAODS_fetch 15:31:12,034 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCaseDisposition]
  13. [java] 1567 739817831 CivilMattersAndPlayersDAODS_fetch 15:32:25,945 [[builtinApplication.CivilMattersAndPlayersDAODS_fetch] Query string: select _CivilMattersAndPlayers from com.legaledge.maestro.server.summary.CivilMattersAndPlayers _CivilMattersAndPlayers ]
  14. [java] 1498 182380602 CivilMattersAndPlayersDAODS_fetch 15:32:24,186 [[builtinApplication.CivilMattersAndPlayersDAODS_fetch] Query string: select _CivilMattersAndPlayers from com.legaledge.maestro.server.summary.CivilMattersAndPlayers _CivilMattersAndPlayers ]
  15. [java] 1401 1200275528 PicklistValueDAODS_fetch 15:32:14,420 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: NamePrefix%]
  16. [java] 1397 784260492 PicklistValueDAODS_fetch 15:31:10,451 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventType]
  17. [java] 1367 483501424 PicklistValueDAODS_fetch 15:32:14,470 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: NameSuffix%]
  18. [java] 1331 1557307050 OpenCaseToEventDAODS_fetch 15:31:12,321 [[builtinApplication.OpenCaseToEventDAODS_fetch] Query string: select _CaseToEventDAO, eventDAO1, contractMatterDAO2, collectionCaseDAO3, generalMatterDAO4, litigationMatterDAO5, claimDAO6, delinquencyCaseDAO7, criminalCaseDAO8 from com.legaledge.maestro.server.model.report.CaseToEventDAO _CaseToEventDAO left outer join _CaseToEventDAO.eventDAO eventDAO1 left outer join _CaseToEventDAO.contractMatterDAO contractMatterDAO2 left outer join _CaseToEventDAO.collectionCaseDAO collectionCaseDAO3 left outer join _CaseToEventDAO.generalMatterDAO generalMatterDAO4 left outer join _CaseToEventDAO.litigationMatterDAO litigationMatterDAO5 left outer join _CaseToEventDAO.claimDAO claimDAO6 left outer join _CaseToEventDAO.delinquencyCaseDAO delinquencyCaseDAO7 left outer join _CaseToEventDAO.criminalCaseDAO criminalCaseDAO8 where (eventDAO1.endDate is null and criminalCaseDAO8.id = :p0 and criminalCaseDAO8.id is not null), [builtinApplication.OpenCaseToEventDAODS_fetch] Parameter p0: 375960]
  19. [java] 1299 1776093271 PicklistValueDAODS_fetch 15:32:14,538 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonType%]
  20. [java] 1280 1919485460 PicklistValueDAODS_fetch 15:31:12,271 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseGoalMeasure]
  21. [java] 1239 576080653 PicklistValueDAODS_fetch 15:32:14,598 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonGender%]
  22. [java] 1192 1383454381 PicklistValueDAODS_fetch 15:32:14,645 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonRace%]
  23. [java] 1084 1183223189 PicklistValueDAODS_fetch 15:31:11,172 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalFilingType]
  24. [java] 1021 112865817 PicklistValueDAODS_fetch 15:31:10,827 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventLocation]
  25. [java] 994 1803478290 PicklistValueDAODS_fetch 15:31:29,130 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) like lower(:p0) escape '~'), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventType%]
  26. [java] 974 2125795647 PicklistValueDAODS_fetch 15:32:14,863 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: Citizenship%]
  27. [java] 955 417402585 MyOpenCases_fetch 15:30:15,795 [[builtinApplication.MyOpenCases_fetch] Query string: select _MyOpenCases from com.legaledge.maestro.server.summary.MyOpenCases _MyOpenCases where _MyOpenCases.personId = :p0, [builtinApplication.MyOpenCases_fetch] Parameter p0: 7247]
  28. [java] 931 1544062254 PicklistValueDAODS_fetch 15:31:29,135 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventType]
  29. [java] 862 1850562120 MyAppearances_fetch 15:30:15,748 [[builtinApplication.MyAppearances_fetch] Query string: select _MyAppearances from com.legaledge.maestro.server.summary.MyAppearances _MyAppearances where ((_MyAppearances.personId = :p0 and _MyAppearances.personId is not null or _MyAppearances.personOrgId = :p1 and _MyAppearances.personOrgId is not null)), [builtinApplication.MyAppearances_fetch] Parameter p0: 7247, [builtinApplication.MyAppearances_fetch] Parameter p1: 7247]
  30. [java] 779 278178399 PicklistValueDAODS_fetch 15:32:15,058 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonBuildType%]
  31. [java] 722 1799555655 PicklistValueDAODS_fetch 15:32:15,050 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonRace]
  32. [java] 646 253723570 CriminalCaseSummaryDAODS_fetch 15:31:10,451 [[builtinApplication.CriminalCaseSummaryDAODS_fetch] Query string: select _CriminalCaseSummary from com.legaledge.maestro.server.summary.CriminalCaseSummary _CriminalCaseSummary where _CriminalCaseSummary.id = :p0, [builtinApplication.CriminalCaseSummaryDAODS_fetch] Parameter p0: 375960]
  33. [java] 608 1840853736 CriminalCaseSummaryDAODS_fetch 15:31:11,224 [[builtinApplication.CriminalCaseSummaryDAODS_fetch] Query string: select _CriminalCaseSummary from com.legaledge.maestro.server.summary.CriminalCaseSummary _CriminalCaseSummary where _CriminalCaseSummary.id = :p0, [builtinApplication.CriminalCaseSummaryDAODS_fetch] Parameter p0: 375960]
  34. [java] 571 979224913 PicklistValueDAODS_fetch 15:31:29,143 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: EventLocation%]
  35. [java] 562 48736554 PicklistValueDAODS_fetch 15:32:15,275 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonEyeColor%]
  36. [java] 555 491540426 PicklistValueDAODS_fetch 15:31:11,467 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseFilingType]
  37. [java] 532 294320713 PicklistValueDAODS_fetch 15:32:15,010 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: NameSuffix]
  38. [java] 517 240480224 PicklistValueDAODS_fetch 15:32:15,000 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonGender]
  39. [java] 478 993384350 PicklistValueDAODS_fetch 15:32:15,013 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonType]
  40. [java] 468 25686321 PicklistValueDAODS_fetch 15:31:57,949 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Drug, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  41. [java] 458 65784000 PicklistValueDAODS_fetch 15:31:57,951 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Drug]
  42. [java] 458 875387358 PicklistValueDAODS_fetch 15:31:29,128 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: EventType%]
  43. [java] 457 1238368987 CaseToIncidentDAODS_fetch 16:17:53,292 [[builtinApplication.CaseToIncidentDAODS_fetch] Query string: select _CaseToIncidentDAO, incidentDAO1, mentalHealthMatterDAO2, generalMatterDAO3, contemptCaseDAO4, claimDAO5, litigationMatterDAO6, trafficCaseDAO7, delinquencyCaseDAO8, dependencyCaseDAO9, criminalCaseDAO10, forfeitureCaseDAO11 from com.legaledge.maestro.server.model.report.CaseToIncidentDAO _CaseToIncidentDAO left outer join _CaseToIncidentDAO.incidentDAO incidentDAO1 left outer join _CaseToIncidentDAO.mentalHealthMatterDAO mentalHealthMatterDAO2 left outer join _CaseToIncidentDAO.generalMatterDAO generalMatterDAO3 left outer join _CaseToIncidentDAO.contemptCaseDAO contemptCaseDAO4 left outer join _CaseToIncidentDAO.claimDAO claimDAO5 left outer join _CaseToIncidentDAO.litigationMatterDAO litigationMatterDAO6 left outer join _CaseToIncidentDAO.trafficCaseDAO trafficCaseDAO7 left outer join _CaseToIncidentDAO.delinquencyCaseDAO delinquencyCaseDAO8 left outer join _CaseToIncidentDAO.dependencyCaseDAO dependencyCaseDAO9 left outer join _CaseToIncidentDAO.criminalCaseDAO criminalCaseDAO10 left outer join _CaseToIncidentDAO.forfeitureCaseDAO forfeitureCaseDAO11 where (_CaseToIncidentDAO.id = :p0 and _CaseToIncidentDAO.id is not null), [builtinApplication.CaseToIncidentDAODS_fetch] Parameter p0: 387081]
  44. [java] 445 705783072 PicklistValueDAODS_fetch 15:31:57,974 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Weapon, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  45. [java] 441 1331693958 PicklistValueDAODS_fetch 15:31:57,971 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Weapon]
  46. [java] 419 570817755 PicklistValueDAODS_fetch 15:31:53,381 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Drug, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  47. [java] 415 1331432950 PicklistValueDAODS_fetch 15:32:15,438 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonHairColor%]
  48. [java] 397 394310029 CriminalCaseSummaryDAODS_fetch 15:33:06,406 [[builtinApplication.CriminalCaseSummaryDAODS_fetch] Query string: select _CriminalCaseSummary from com.legaledge.maestro.server.summary.CriminalCaseSummary _CriminalCaseSummary where _CriminalCaseSummary.id = :p0, [builtinApplication.CriminalCaseSummaryDAODS_fetch] Parameter p0: 375960]
  49. [java] 388 1065586266 PicklistValueDAODS_fetch 15:33:05,988 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventType]
  50. [java] 383 1534281528 PicklistValueDAODS_fetch 15:31:29,686 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventLocation]
  51. [java] 350 1200400752 PicklistValueDAODS_fetch 15:31:53,368 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Drug]
  52. [java] 347 1363646004 PicklistValueDAODS_fetch 15:31:53,386 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Weapon]
  53. [java] 337 44144784 PicklistValueDAODS_fetch 15:31:53,463 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: Weapon, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  54. [java] 336 978881955 PicklistValueDAODS_fetch 15:32:15,517 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonSkinTone%]
  55. [java] 332 642919690 PicklistValueDAODS_fetch 15:31:29,794 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) like lower(:p0) escape '~'), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventLocation%]
  56. [java] 325 1076729559 PicklistValueDAODS_fetch 15:31:58,097 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargePlea, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  57. [java] 317 599087135 PicklistValueDAODS_fetch 15:31:58,097 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeSeverity]
  58. [java] 296 1189992685 PicklistValueDAODS_fetch 15:31:58,118 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargePlea]
  59. [java] 289 341788523 PicklistValueDAODS_fetch 15:31:58,133 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeSeverity, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  60. [java] 289 419669060 PicklistValueDAODS_fetch 15:33:06,411 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalFilingType]
  61. [java] 285 1926572843 PicklistValueDAODS_fetch 15:31:53,515 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargePlea, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  62. [java] 281 732981929 PicklistValueDAODS_fetch 15:31:11,884 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalStatus]
  63. [java] 275 351896162 PicklistValueDAODS_fetch 15:31:56,665 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonLanguage]
  64. [java] 271 1106475657 PicklistValueDAODS_fetch 15:32:15,208 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: Citizenship]
  65. [java] 270 292782041 PicklistValueDAODS_fetch 15:31:14,806 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: Weapon%]
  66. [java] 269 1398091112 PicklistValueDAODS_fetch 15:31:53,531 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeSeverity, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  67. [java] 267 527030787 PicklistValueDAODS_fetch 15:31:53,466 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeSeverity]
  68. [java] 263 421339273 PicklistValueDAODS_fetch 15:31:58,169 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeDisposition, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  69. [java] 263 551854138 PicklistValueDAODS_fetch 15:31:58,154 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeDisposition]
  70. [java] 262 189634452 PicklistValueDAODS_fetch 15:31:48,799 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: DefendantDisposition%]
  71. [java] 259 2091763766 DefenderPersonDAODS_fetch 15:32:14,370 [[builtinApplication.DefenderPersonDAODS_fetch] Query string: select _PersonDAO, personNameDAO1 from com.legaledge.maestro.server.model.report.PersonDAO _PersonDAO left outer join _PersonDAO.personNameDAO personNameDAO1 where (_PersonDAO.id = :p0 and _PersonDAO.id is not null), [builtinApplication.DefenderPersonDAODS_fetch] Parameter p0: 387046]
  72. [java] 249 1903697192 PicklistValueDAODS_fetch 15:31:53,484 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargePlea]
  73. [java] 240 1564493548 PicklistValueDAODS_fetch 15:31:11,227 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCaseType]
  74. [java] 235 1921249831 PicklistValueDAODS_fetch 15:34:54,837 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: Weapon]
  75. [java] 234 695534652 PicklistValueDAODS_fetch 15:31:53,499 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeDisposition]
  76. [java] 228 69443231 PicklistValueDAODS_fetch 15:31:56,375 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: DefendantDisposition%]
  77. [java] 227 1064555735 CriminalCaseSummaryDAODS_fetch 15:33:05,521 [[builtinApplication.CriminalCaseSummaryDAODS_fetch] Query string: select _CriminalCaseSummary from com.legaledge.maestro.server.summary.CriminalCaseSummary _CriminalCaseSummary where _CriminalCaseSummary.id = :p0, [builtinApplication.CriminalCaseSummaryDAODS_fetch] Parameter p0: 375960]
  78. [java] 225 647661170 PicklistValueDAODS_fetch 15:31:48,839 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CustodyStatus%]
  79. [java] 223 805023528 PicklistValueDAODS_fetch 15:31:53,577 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeDisposition, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  80. [java] 221 842911153 CaseToIncidentDAODS_fetch 15:31:14,981 [[builtinApplication.CaseToIncidentDAODS_fetch] Query string: select _CaseToIncidentDAO, incidentDAO1, mentalHealthMatterDAO2, generalMatterDAO3, contemptCaseDAO4, claimDAO5, litigationMatterDAO6, trafficCaseDAO7, delinquencyCaseDAO8, dependencyCaseDAO9, criminalCaseDAO10, forfeitureCaseDAO11 from com.legaledge.maestro.server.model.report.CaseToIncidentDAO _CaseToIncidentDAO left outer join _CaseToIncidentDAO.incidentDAO incidentDAO1 left outer join _CaseToIncidentDAO.mentalHealthMatterDAO mentalHealthMatterDAO2 left outer join _CaseToIncidentDAO.generalMatterDAO generalMatterDAO3 left outer join _CaseToIncidentDAO.contemptCaseDAO contemptCaseDAO4 left outer join _CaseToIncidentDAO.claimDAO claimDAO5 left outer join _CaseToIncidentDAO.litigationMatterDAO litigationMatterDAO6 left outer join _CaseToIncidentDAO.trafficCaseDAO trafficCaseDAO7 left outer join _CaseToIncidentDAO.delinquencyCaseDAO delinquencyCaseDAO8 left outer join _CaseToIncidentDAO.dependencyCaseDAO dependencyCaseDAO9 left outer join _CaseToIncidentDAO.criminalCaseDAO criminalCaseDAO10 left outer join _CaseToIncidentDAO.forfeitureCaseDAO forfeitureCaseDAO11 where (criminalCaseDAO10.id = :p0 and criminalCaseDAO10.id is not null), [builtinApplication.CaseToIncidentDAODS_fetch] Parameter p0: 375960]
  81. [java] 217 1979354805 PicklistValueDAODS_fetch 15:33:06,716 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCaseDisposition]
  82. [java] 215 672000398 PicklistValueDAODS_fetch 15:31:49,136 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonLanguage]
  83. [java] 214 97553569 PicklistValueDAODS_fetch 15:32:15,514 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonEyeColor]
  84. [java] 208 1043406916 PicklistValueDAODS_fetch 15:31:40,053 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonLanguage%]
  85. [java] 203 1682992643 CriminalCaseDAODS_fetch 15:31:10,248 [[builtinApplication.CriminalCaseDAODS_fetch] Query string: select _CriminalCaseDAO from com.legaledge.maestro.server.model.report.CriminalCaseDAO _CriminalCaseDAO where (_CriminalCaseDAO.id = :p0 and _CriminalCaseDAO.id is not null), [builtinApplication.CriminalCaseDAODS_fetch] Parameter p0: 375960]
  86. [java] 198 361291040 IncidentToAddressDAODS_fetch 16:17:53,284 [[builtinApplication.IncidentToAddressDAODS_fetch] Query string: select _IncidentToAddressDAO, addressDAO1, incidentDAO2 from com.legaledge.maestro.server.model.report.IncidentToAddressDAO _IncidentToAddressDAO left outer join _IncidentToAddressDAO.addressDAO addressDAO1 left outer join _IncidentToAddressDAO.incidentDAO incidentDAO2 where incidentDAO2.id = :p0, [builtinApplication.IncidentToAddressDAODS_fetch] Parameter p0: 387034]
  87. [java] 194 773823625 PicklistValueDAODS_fetch 15:32:15,496 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonBuildType]
  88. [java] 190 2003541432 DefenderIncidentDAODS_fetch 16:17:53,292 [[builtinApplication.DefenderIncidentDAODS_fetch] Query string: select _IncidentDAO from com.legaledge.maestro.server.model.report.IncidentDAO _IncidentDAO where (_IncidentDAO.id = :p0 and _IncidentDAO.id is not null), [builtinApplication.DefenderIncidentDAODS_fetch] Parameter p0: 387034]
  89. [java] 188 449448189 PicklistValueDAODS_fetch 15:31:56,415 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CustodyStatus%]
  90. [java] 185 2016152635 PicklistValueDAODS_fetch 15:32:14,870 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: NamePrefix]
  91. [java] 185 214537804 PicklistValueDAODS_fetch 15:31:48,879 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonLanguage%]
  92. [java] 184 854860091 DivisionStaffPersonDS_fetch 15:31:29,490 [[builtinApplication.DivisionStaffPersonDS_fetch] Query string: select _DivisionStaffPerson from com.legaledge.harmony.summary.DivisionStaffPerson _DivisionStaffPerson where (lower(_DivisionStaffPerson.active) like lower(:p0) escape '~') order by _DivisionStaffPerson.personFullName, [builtinApplication.DivisionStaffPersonDS_fetch] Parameter p0: Yes%]
  93. [java] 178 357169492 PicklistValueDAODS_fetch 16:17:53,929 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: Weapon]
  94. [java] 173 613379658 PicklistValueDAODS_fetch 15:31:11,244 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) = lower(:p1)) and _PicklistValueDAO.id = :p2, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCaseDisposition, [builtinApplication.PicklistValueDAODS_fetch] Parameter p2: -10003769]
  95. [java] 170 902727810 PicklistValueDAODS_fetch 15:31:14,806 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: VOID DUMMY%]
  96. [java] 167 1279865498 PicklistValueDAODS_fetch 15:31:56,438 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonLanguage%]
  97. [java] 167 10210870 PicklistValueDAODS_fetch 15:31:58,267 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeStatus, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  98. [java] 165 861865818 CaseToIncidentDAODS_fetch 15:34:55,329 [[builtinApplication.CaseToIncidentDAODS_fetch] Query string: select _CaseToIncidentDAO, incidentDAO1, mentalHealthMatterDAO2, generalMatterDAO3, contemptCaseDAO4, claimDAO5, litigationMatterDAO6, trafficCaseDAO7, delinquencyCaseDAO8, dependencyCaseDAO9, criminalCaseDAO10, forfeitureCaseDAO11 from com.legaledge.maestro.server.model.report.CaseToIncidentDAO _CaseToIncidentDAO left outer join _CaseToIncidentDAO.incidentDAO incidentDAO1 left outer join _CaseToIncidentDAO.mentalHealthMatterDAO mentalHealthMatterDAO2 left outer join _CaseToIncidentDAO.generalMatterDAO generalMatterDAO3 left outer join _CaseToIncidentDAO.contemptCaseDAO contemptCaseDAO4 left outer join _CaseToIncidentDAO.claimDAO claimDAO5 left outer join _CaseToIncidentDAO.litigationMatterDAO litigationMatterDAO6 left outer join _CaseToIncidentDAO.trafficCaseDAO trafficCaseDAO7 left outer join _CaseToIncidentDAO.delinquencyCaseDAO delinquencyCaseDAO8 left outer join _CaseToIncidentDAO.dependencyCaseDAO dependencyCaseDAO9 left outer join _CaseToIncidentDAO.criminalCaseDAO criminalCaseDAO10 left outer join _CaseToIncidentDAO.forfeitureCaseDAO forfeitureCaseDAO11 where (criminalCaseDAO10.id = :p0 and criminalCaseDAO10.id is not null), [builtinApplication.CaseToIncidentDAODS_fetch] Parameter p0: 375960]
  99. [java] 160 1388722972 PicklistValueDAODS_fetch 15:31:49,136 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: DefendantDisposition]
  100. [java] 158 661712311 SearchCaseCourtDAODS_fetch 15:33:09,696 [[builtinApplication.SearchCaseCourtDAODS_fetch] Query string: select _CaseCourtDAO, courtDAO1, criminalCaseDAO2, mentalHealthMatterDAO3, contemptCaseDAO4, litigationMatterDAO5, trafficCaseDAO6, delinquencyCaseDAO7, dependencyCaseDAO8, collectionCaseDAO9 from com.legaledge.maestro.server.model.report.CaseCourtDAO _CaseCourtDAO left outer join _CaseCourtDAO.courtDAO courtDAO1 left outer join _CaseCourtDAO.criminalCaseDAO criminalCaseDAO2 left outer join _CaseCourtDAO.mentalHealthMatterDAO mentalHealthMatterDAO3 left outer join _CaseCourtDAO.contemptCaseDAO contemptCaseDAO4 left outer join _CaseCourtDAO.litigationMatterDAO litigationMatterDAO5 left outer join _CaseCourtDAO.trafficCaseDAO trafficCaseDAO6 left outer join _CaseCourtDAO.delinquencyCaseDAO delinquencyCaseDAO7 left outer join _CaseCourtDAO.dependencyCaseDAO dependencyCaseDAO8 left outer join _CaseCourtDAO.collectionCaseDAO collectionCaseDAO9 where (criminalCaseDAO2.id = :p0 and criminalCaseDAO2.id is not null), [builtinApplication.SearchCaseCourtDAODS_fetch] Parameter p0: 375960]
  101. [java] 156 534771430 PicklistValueDAODS_fetch 15:31:53,577 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeStatus]
  102. [java] 152 1593772200 PicklistValueDAODS_fetch 15:33:06,226 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: EventLocation]
  103. [java] 152 174336615 PicklistValueDAODS_fetch 15:31:14,806 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: OffenseType%]
  104. [java] 152 366861654 PicklistValueDAODS_fetch 15:31:58,267 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeStatus]
  105. [java] 148 22100932 PicklistValueDAODS_fetch 15:31:40,048 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: DefendantDisposition%]
  106. [java] 147 186674059 CaseToIncidentDAODS_fetch 15:34:57,252 [[builtinApplication.CaseToIncidentDAODS_fetch] Query string: select _CaseToIncidentDAO, incidentDAO1, mentalHealthMatterDAO2, generalMatterDAO3, contemptCaseDAO4, claimDAO5, litigationMatterDAO6, trafficCaseDAO7, delinquencyCaseDAO8, dependencyCaseDAO9, criminalCaseDAO10, forfeitureCaseDAO11 from com.legaledge.maestro.server.model.report.CaseToIncidentDAO _CaseToIncidentDAO left outer join _CaseToIncidentDAO.incidentDAO incidentDAO1 left outer join _CaseToIncidentDAO.mentalHealthMatterDAO mentalHealthMatterDAO2 left outer join _CaseToIncidentDAO.generalMatterDAO generalMatterDAO3 left outer join _CaseToIncidentDAO.contemptCaseDAO contemptCaseDAO4 left outer join _CaseToIncidentDAO.claimDAO claimDAO5 left outer join _CaseToIncidentDAO.litigationMatterDAO litigationMatterDAO6 left outer join _CaseToIncidentDAO.trafficCaseDAO trafficCaseDAO7 left outer join _CaseToIncidentDAO.delinquencyCaseDAO delinquencyCaseDAO8 left outer join _CaseToIncidentDAO.dependencyCaseDAO dependencyCaseDAO9 left outer join _CaseToIncidentDAO.criminalCaseDAO criminalCaseDAO10 left outer join _CaseToIncidentDAO.forfeitureCaseDAO forfeitureCaseDAO11 where (_CaseToIncidentDAO.id = :p0 and _CaseToIncidentDAO.id is not null), [builtinApplication.CaseToIncidentDAODS_fetch] Parameter p0: 376193]
  107. [java] 145 1167653279 PicklistValueDAODS_fetch 15:34:57,847 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: Weapon]
  108. [java] 143 1278383181 PicklistValueDAODS_fetch 15:33:06,413 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseFilingType]
  109. [java] 142 264655482 PicklistValueDAODS_fetch 15:31:11,832 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCasePhase]
  110. [java] 131 1563876732 PicklistValueDAODS_fetch 15:32:15,574 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonHairColor]
  111. [java] 129 1305140332 PicklistValueDAODS_fetch 15:31:53,671 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (lower(PicklistDAOByPicklistId1.name) = lower(:p0)) and _PicklistValueDAO.isActive = :p1 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: ChargeStatus, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: true]
  112. [java] 127 2016686423 CaseToEventDAODS_fetch 15:31:29,378 [[builtinApplication.CaseToEventDAODS_fetch] Query string: select _CaseToEventDAO, eventDAO1, contractMatterDAO2, trafficCaseDAO3, dependencyCaseDAO4, forfeitureCaseDAO5, collectionCaseDAO6, generalMatterDAO7, mentalHealthMatterDAO8, contemptCaseDAO9, litigationMatterDAO10, claimDAO11, delinquencyCaseDAO12, criminalCaseDAO13 from com.legaledge.maestro.server.model.report.CaseToEventDAO _CaseToEventDAO left outer join _CaseToEventDAO.eventDAO eventDAO1 left outer join _CaseToEventDAO.contractMatterDAO contractMatterDAO2 left outer join _CaseToEventDAO.trafficCaseDAO trafficCaseDAO3 left outer join _CaseToEventDAO.dependencyCaseDAO dependencyCaseDAO4 left outer join _CaseToEventDAO.forfeitureCaseDAO forfeitureCaseDAO5 left outer join _CaseToEventDAO.collectionCaseDAO collectionCaseDAO6 left outer join _CaseToEventDAO.generalMatterDAO generalMatterDAO7 left outer join _CaseToEventDAO.mentalHealthMatterDAO mentalHealthMatterDAO8 left outer join _CaseToEventDAO.contemptCaseDAO contemptCaseDAO9 left outer join _CaseToEventDAO.litigationMatterDAO litigationMatterDAO10 left outer join _CaseToEventDAO.claimDAO claimDAO11 left outer join _CaseToEventDAO.delinquencyCaseDAO delinquencyCaseDAO12 left outer join _CaseToEventDAO.criminalCaseDAO criminalCaseDAO13 where criminalCaseDAO13.id = :p0 and criminalCaseDAO13.id is not null order by eventDAO1.startDate, [builtinApplication.CaseToEventDAODS_fetch] Parameter p0: 375960]
  113. [java] 125 1513065066 RepresentByDAODS_fetch 15:31:52,306 [[builtinApplication.RepresentByDAODS_fetch] Query string: select _RepresentByDAO, litigationMatterOpposingPartyDAO1, generalParticipantDAO2, generalMatterMainPartyDAO3, litigationParticipantDAO4, collectionClientOrgDAO5, criminalDefendantDAO6, juvenileOffenderDAO7, trafficDefendantDAO8, contemptDefendantDAO9, mentalHealthPatientDAO10, dependencyClientDAO11, victimFileDAO12, personDAO13, organizationDAO14 from com.legaledge.maestro.server.model.report.RepresentByDAO _RepresentByDAO left outer join _RepresentByDAO.litigationMatterOpposingPartyDAO litigationMatterOpposingPartyDAO1 left outer join _RepresentByDAO.generalParticipantDAO generalParticipantDAO2 left outer join _RepresentByDAO.generalMatterMainPartyDAO generalMatterMainPartyDAO3 left outer join _RepresentByDAO.litigationParticipantDAO litigationParticipantDAO4 left outer join _RepresentByDAO.collectionClientOrgDAO collectionClientOrgDAO5 left outer join _RepresentByDAO.criminalDefendantDAO criminalDefendantDAO6 left outer join _RepresentByDAO.juvenileOffenderDAO juvenileOffenderDAO7 left outer join _RepresentByDAO.trafficDefendantDAO trafficDefendantDAO8 left outer join _RepresentByDAO.contemptDefendantDAO contemptDefendantDAO9 left outer join _RepresentByDAO.mentalHealthPatientDAO mentalHealthPatientDAO10 left outer join _RepresentByDAO.dependencyClientDAO dependencyClientDAO11 left outer join _RepresentByDAO.victimFileDAO victimFileDAO12 left outer join _RepresentByDAO.personDAO personDAO13 left outer join _RepresentByDAO.organizationDAO organizationDAO14 where (criminalDefendantDAO6.id = :p0 and criminalDefendantDAO6.id is not null), [builtinApplication.RepresentByDAODS_fetch] Parameter p0: 376170]
  114. [java] 125 848690638 PicklistValueDAODS_fetch 16:17:53,929 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: OffenseType]
  115. [java] 125 1855259345 PicklistValueDAODS_fetch 15:31:40,055 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CustodyStatus%]
  116. [java] 122 709780083 PicklistValueDAODS_fetch 15:31:12,183 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseGoal]
  117. [java] 120 26036330 MinimalGenericParticipantDS_fetch 15:31:34,741 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  118. [java] 119 1274701721 PicklistValueDAODS_fetch 15:31:11,713 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseWeight]
  119. [java] 118 1182521768 PicklistValueDAODS_fetch 15:33:06,667 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: TrialPhaseReason]
  120. [java] 111 2143043935 CriminalCaseSearchDAODS_fetch 15:33:00,018 [[builtinApplication.CriminalCaseSearchDAODS_fetch] Query string: select _MinimalCriminalCaseCivil from com.legaledge.maestro.server.summary.MinimalCriminalCaseCivil _MinimalCriminalCaseCivil order by _MinimalCriminalCaseCivil.startDate desc]
  121. [java] 109 1730700135 PicklistValueDAODS_fetch 15:31:52,306 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~'), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: RepresentByRelationType%]
  122. [java] 106 211170330 PicklistValueDAODS_fetch 15:31:52,309 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) = lower(:p1)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: RepresentByRelationType]
  123. [java] 106 677014486 PicklistValueDAODS_fetch 15:31:12,134 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: DefenderCriminalCaseOutcome]
  124. [java] 105 1988244311 PicklistValueDAODS_fetch 15:34:54,849 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: OffenseType]
  125. [java] 102 116373916 PicklistValueDAODS_fetch 15:34:54,847 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: VOID DUMMY]
  126. [java] 102 706403938 PersonSearchDAODS_fetch 15:32:08,585 [[builtinApplication.PersonSearchDAODS_fetch] Query string: select _PersonSearchCivil from com.legaledge.maestro.server.summary.PersonSearchCivil _PersonSearchCivil order by _PersonSearchCivil.lastName]
  127. [java] 102 38541013 CaseToCaseIdentifierDAODS_fetch 15:32:01,244 [[builtinApplication.CaseToCaseIdentifierDAODS_fetch] Query string: select _CaseToCaseIdentifierDAO, caseIdentifierDAO1, picklistValueDAOByType2, picklistValueDAOByStatus3, contractMatterDAO4, trafficCaseDAO5, dependencyCaseDAO6, forfeitureCaseDAO7, collectionCaseDAO8, generalMatterDAO9, mentalHealthMatterDAO10, contemptCaseDAO11, litigationMatterDAO12, claimDAO13, delinquencyCaseDAO14, criminalCaseDAO15 from com.legaledge.maestro.server.model.report.CaseToCaseIdentifierDAO _CaseToCaseIdentifierDAO left outer join _CaseToCaseIdentifierDAO.caseIdentifierDAO caseIdentifierDAO1 left outer join caseIdentifierDAO1.picklistValueDAOByType picklistValueDAOByType2 left outer join caseIdentifierDAO1.picklistValueDAOByStatus picklistValueDAOByStatus3 left outer join _CaseToCaseIdentifierDAO.contractMatterDAO contractMatterDAO4 left outer join _CaseToCaseIdentifierDAO.trafficCaseDAO trafficCaseDAO5 left outer join _CaseToCaseIdentifierDAO.dependencyCaseDAO dependencyCaseDAO6 left outer join _CaseToCaseIdentifierDAO.forfeitureCaseDAO forfeitureCaseDAO7 left outer join _CaseToCaseIdentifierDAO.collectionCaseDAO collectionCaseDAO8 left outer join _CaseToCaseIdentifierDAO.generalMatterDAO generalMatterDAO9 left outer join _CaseToCaseIdentifierDAO.mentalHealthMatterDAO mentalHealthMatterDAO10 left outer join _CaseToCaseIdentifierDAO.contemptCaseDAO contemptCaseDAO11 left outer join _CaseToCaseIdentifierDAO.litigationMatterDAO litigationMatterDAO12 left outer join _CaseToCaseIdentifierDAO.claimDAO claimDAO13 left outer join _CaseToCaseIdentifierDAO.delinquencyCaseDAO delinquencyCaseDAO14 left outer join _CaseToCaseIdentifierDAO.criminalCaseDAO criminalCaseDAO15 where (criminalCaseDAO15.id = :p0 and criminalCaseDAO15.id is not null), [builtinApplication.CaseToCaseIdentifierDAODS_fetch] Parameter p0: 375960]
  128. [java] 95 2077377527 OrganizationDAODS_fetch 15:31:56,510 [[builtinApplication.OrganizationDAODS_fetch] Query string: select _OrganizationDAO from com.legaledge.maestro.server.model.report.OrganizationDAO _OrganizationDAO where (_OrganizationDAO.type = :p0 and _OrganizationDAO.type is not null), [builtinApplication.OrganizationDAODS_fetch] Parameter p0: -922050]
  129. [java] 95 2031376058 OrganizationDAODS_fetch 15:31:48,969 [[builtinApplication.OrganizationDAODS_fetch] Query string: select _OrganizationDAO from com.legaledge.maestro.server.model.report.OrganizationDAO _OrganizationDAO where (_OrganizationDAO.type = :p0 and _OrganizationDAO.type is not null), [builtinApplication.OrganizationDAODS_fetch] Parameter p0: -922050]
  130. [java] 93 1590932338 PicklistValueDAODS_fetch 15:33:06,667 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalStatus]
  131. [java] 90 1546576237 PicklistValueDAODS_fetch 15:31:12,150 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: ConflictOutcomeReason]
  132. [java] 85 495681595 PicklistValueDAODS_fetch 15:31:29,133 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: EventOutcome%]
  133. [java] 85 108244995 CaseDefendantToChargeDAODS_fetch 15:31:52,938 [[builtinApplication.CaseDefendantToChargeDAODS_fetch] Query string: select _CaseDefendantToChargeDAO, chargeDAO1, trafficDefendantDAO2, contemptDefendantDAO3, criminalDefendantDAO4, dependencyCaseDAO5, dependencyClientDAO6, juvenileOffenderDAO7 from com.legaledge.maestro.server.model.report.CaseDefendantToChargeDAO _CaseDefendantToChargeDAO left outer join _CaseDefendantToChargeDAO.chargeDAO chargeDAO1 left outer join _CaseDefendantToChargeDAO.trafficDefendantDAO trafficDefendantDAO2 left outer join _CaseDefendantToChargeDAO.contemptDefendantDAO contemptDefendantDAO3 left outer join _CaseDefendantToChargeDAO.criminalDefendantDAO criminalDefendantDAO4 left outer join _CaseDefendantToChargeDAO.dependencyCaseDAO dependencyCaseDAO5 left outer join _CaseDefendantToChargeDAO.dependencyClientDAO dependencyClientDAO6 left outer join _CaseDefendantToChargeDAO.juvenileOffenderDAO juvenileOffenderDAO7 where (criminalDefendantDAO4.id = :p0 and criminalDefendantDAO4.id is not null) order by chargeDAO1.source, chargeDAO1.paragraph, [builtinApplication.CaseDefendantToChargeDAODS_fetch] Parameter p0: 376170]
  134. [java] 85 1119187910 PicklistValueDAODS_fetch 15:31:56,680 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: DefendantDisposition]
  135. [java] 85 117729675 OrganizationDAODS_fetch 15:31:40,048 [[builtinApplication.OrganizationDAODS_fetch] Query string: select _OrganizationDAO from com.legaledge.maestro.server.model.report.OrganizationDAO _OrganizationDAO where (_OrganizationDAO.type = :p0 and _OrganizationDAO.type is not null), [builtinApplication.OrganizationDAODS_fetch] Parameter p0: -922050]
  136. [java] 80 1076811591 PrescottOpenCases_fetch 15:30:15,954 [[builtinApplication.PrescottOpenCases_fetch] Query string: select _PrescottOpenCases from com.legaledge.maestro.server.summary.PrescottOpenCases _PrescottOpenCases where (((_PrescottOpenCases.status = :p0 or _PrescottOpenCases.status = :p1) and _PrescottOpenCases.status is not null)), [builtinApplication.PrescottOpenCases_fetch] Parameter p0: pending, [builtinApplication.PrescottOpenCases_fetch] Parameter p1: new]
  137. [java] 80 1400724541 PersonSearchDAODS_fetch 15:32:11,802 [[builtinApplication.PersonSearchDAODS_fetch] Query string: select _PersonSearchCivil from com.legaledge.maestro.server.summary.PersonSearchCivil _PersonSearchCivil where (lower(_PersonSearchCivil.lastName) like lower(:p0) escape '~') order by _PersonSearchCivil.lastName, [builtinApplication.PersonSearchDAODS_fetch] Parameter p0: %williamson%]
  138. [java] 79 718527408 CaseCourtJudgeIntakeDAODS_fetch 15:33:09,759 [[builtinApplication.CaseCourtJudgeIntakeDAODS_fetch] Query string: select _CaseCourtJudgeDAO, caseCourtDAO1 from com.legaledge.maestro.server.model.report.CaseCourtJudgeDAO _CaseCourtJudgeDAO left outer join _CaseCourtJudgeDAO.caseCourtDAO caseCourtDAO1]
  139. [java] 78 195167663 IncidentToAddressDAODS_fetch 15:34:57,849 [[builtinApplication.IncidentToAddressDAODS_fetch] Query string: select _IncidentToAddressDAO, addressDAO1, incidentDAO2 from com.legaledge.maestro.server.model.report.IncidentToAddressDAO _IncidentToAddressDAO left outer join _IncidentToAddressDAO.addressDAO addressDAO1 left outer join _IncidentToAddressDAO.incidentDAO incidentDAO2 where incidentDAO2.id = :p0, [builtinApplication.IncidentToAddressDAODS_fetch] Parameter p0: 376000]
  140. [java] 77 967016010 PicklistValueDAODS_fetch 15:33:06,608 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCasePhase]
  141. [java] 75 88558089 CriminalDefendantDAODS_fetch 15:31:48,799 [[builtinApplication.CriminalDefendantDAODS_fetch] Query string: select _CriminalDefendantDAO from com.legaledge.maestro.server.model.report.CriminalDefendantDAO _CriminalDefendantDAO where (_CriminalDefendantDAO.id = :p0 and _CriminalDefendantDAO.id is not null), [builtinApplication.CriminalDefendantDAODS_fetch] Parameter p0: 376170]
  142. [java] 75 212234832 PicklistValueDAODS_fetch 15:33:06,416 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) = lower(:p1)) and _PicklistValueDAO.id = :p2, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCaseDisposition, [builtinApplication.PicklistValueDAODS_fetch] Parameter p2: -10003769]
  143. [java] 72 1366227744 PicklistValueDAODS_fetch 15:32:01,244 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: AlternateIdType%]
  144. [java] 70 1951693339 MinimalGenericParticipantDS_fetch 15:31:59,695 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  145. [java] 67 1913496251 PicklistValueDAODS_fetch 15:32:15,558 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: PersonSkinTone]
  146. [java] 65 179099441 PicklistValueDAODS_fetch 15:31:13,536 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where PicklistDAOByPicklistId1.id = :p0 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: 0]
  147. [java] 58 1770743967 DefenderIncidentDAODS_fetch 15:34:57,254 [[builtinApplication.DefenderIncidentDAODS_fetch] Query string: select _IncidentDAO from com.legaledge.maestro.server.model.report.IncidentDAO _IncidentDAO where (_IncidentDAO.id = :p0 and _IncidentDAO.id is not null), [builtinApplication.DefenderIncidentDAODS_fetch] Parameter p0: 376000]
  148. [java] 58 421349688 PicklistValueDAODS_fetch 15:31:49,131 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CustodyStatus]
  149. [java] 55 2122977720 PicklistValueDAODS_fetch 15:31:56,665 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CustodyStatus]
  150. [java] 54 498002721 CriminalCaseSearchDAODS_fetch 15:31:04,915 [[builtinApplication.CriminalCaseSearchDAODS_fetch] Query string: select _MinimalCriminalCaseCivil from com.legaledge.maestro.server.summary.MinimalCriminalCaseCivil _MinimalCriminalCaseCivil order by _MinimalCriminalCaseCivil.startDate desc]
  151. [java] 53 1348736329 OpenCaseToEventDAODS_fetch 15:33:06,885 [[builtinApplication.OpenCaseToEventDAODS_fetch] Query string: select _CaseToEventDAO, eventDAO1, contractMatterDAO2, collectionCaseDAO3, generalMatterDAO4, litigationMatterDAO5, claimDAO6, delinquencyCaseDAO7, criminalCaseDAO8 from com.legaledge.maestro.server.model.report.CaseToEventDAO _CaseToEventDAO left outer join _CaseToEventDAO.eventDAO eventDAO1 left outer join _CaseToEventDAO.contractMatterDAO contractMatterDAO2 left outer join _CaseToEventDAO.collectionCaseDAO collectionCaseDAO3 left outer join _CaseToEventDAO.generalMatterDAO generalMatterDAO4 left outer join _CaseToEventDAO.litigationMatterDAO litigationMatterDAO5 left outer join _CaseToEventDAO.claimDAO claimDAO6 left outer join _CaseToEventDAO.delinquencyCaseDAO delinquencyCaseDAO7 left outer join _CaseToEventDAO.criminalCaseDAO criminalCaseDAO8 where (eventDAO1.endDate is null and criminalCaseDAO8.id = :p0 and criminalCaseDAO8.id is not null), [builtinApplication.OpenCaseToEventDAODS_fetch] Parameter p0: 375960]
  152. [java] 52 1477543792 PicklistValueDAODS_fetch 15:34:57,857 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: VOID DUMMY]
  153. [java] 50 1582744033 CriminalCaseDAODS_fetch 15:33:05,521 [[builtinApplication.CriminalCaseDAODS_fetch] Query string: select _CriminalCaseDAO from com.legaledge.maestro.server.model.report.CriminalCaseDAO _CriminalCaseDAO where (_CriminalCaseDAO.id = :p0 and _CriminalCaseDAO.id is not null), [builtinApplication.CriminalCaseDAODS_fetch] Parameter p0: 375960]
  154. [java] 48 1896585971 PicklistValueDAODS_fetch 15:34:57,849 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: OffenseType]
  155. [java] 47 399704824 PicklistValueDAODS_fetch 15:31:52,384 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) = lower(:p1)), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: ParticipantRank]
  156. [java] 45 1947509181 PicklistValueDAODS_fetch 15:31:49,129 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: IntakeApprovalStatus]
  157. [java] 43 2112754315 PicklistValueDAODS_fetch 15:33:06,408 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CriminalCaseType]
  158. [java] 42 2119790121 PicklistValueDAODS_fetch 15:31:49,134 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: IntakeApprovalStatusReason]
  159. [java] 40 515679126 PicklistValueDAODS_fetch 15:33:06,760 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseGoal]
  160. [java] 40 317279803 MinimalGenericParticipantDS_fetch 15:31:39,873 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  161. [java] 40 472163126 CriminalDefendantDAODS_fetch 15:31:52,941 [[builtinApplication.CriminalDefendantDAODS_fetch] Query string: select _CriminalDefendantDAO from com.legaledge.maestro.server.model.report.CriminalDefendantDAO _CriminalDefendantDAO where _CriminalDefendantDAO.id = :p0, [builtinApplication.CriminalDefendantDAODS_fetch] Parameter p0: 376170]
  162. [java] 40 1257591999 MinimalAddressDAODS_fetch 15:34:58,027 [[builtinApplication.MinimalAddressDAODS_fetch] Query string: select _AddressDAO from com.legaledge.maestro.server.model.report.AddressDAO _AddressDAO where _AddressDAO.id = :p0, [builtinApplication.MinimalAddressDAODS_fetch] Parameter p0: 0]
  163. [java] 40 1362650638 MinimalGenericParticipantDS_fetch 15:31:48,949 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  164. [java] 38 990407516 CaseDefendantToChargeDAODS_fetch 15:31:57,506 [[builtinApplication.CaseDefendantToChargeDAODS_fetch] Query string: select _CaseDefendantToChargeDAO, chargeDAO1, trafficDefendantDAO2, contemptDefendantDAO3, criminalDefendantDAO4, dependencyCaseDAO5, dependencyClientDAO6, juvenileOffenderDAO7 from com.legaledge.maestro.server.model.report.CaseDefendantToChargeDAO _CaseDefendantToChargeDAO left outer join _CaseDefendantToChargeDAO.chargeDAO chargeDAO1 left outer join _CaseDefendantToChargeDAO.trafficDefendantDAO trafficDefendantDAO2 left outer join _CaseDefendantToChargeDAO.contemptDefendantDAO contemptDefendantDAO3 left outer join _CaseDefendantToChargeDAO.criminalDefendantDAO criminalDefendantDAO4 left outer join _CaseDefendantToChargeDAO.dependencyCaseDAO dependencyCaseDAO5 left outer join _CaseDefendantToChargeDAO.dependencyClientDAO dependencyClientDAO6 left outer join _CaseDefendantToChargeDAO.juvenileOffenderDAO juvenileOffenderDAO7 where (criminalDefendantDAO4.id = :p0 and criminalDefendantDAO4.id is not null) order by chargeDAO1.source, chargeDAO1.paragraph, [builtinApplication.CaseDefendantToChargeDAODS_fetch] Parameter p0: 387070]
  165. [java] 37 2057702834 MinimalGenericParticipantDS_fetch 15:31:56,478 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  166. [java] 35 1949865156 CriminalDefendantDAODS_fetch 15:31:56,370 [[builtinApplication.CriminalDefendantDAODS_fetch] Query string: select _CriminalDefendantDAO from com.legaledge.maestro.server.model.report.CriminalDefendantDAO _CriminalDefendantDAO where (_CriminalDefendantDAO.id = :p0 and _CriminalDefendantDAO.id is not null), [builtinApplication.CriminalDefendantDAODS_fetch] Parameter p0: 387070]
  167. [java] 35 969206789 OrganizationDAODS_fetch 15:34:55,204 [[builtinApplication.OrganizationDAODS_fetch] Query string: select _OrganizationDAO from com.legaledge.maestro.server.model.report.OrganizationDAO _OrganizationDAO where (_OrganizationDAO.type = :p0 and _OrganizationDAO.type is not null) order by _OrganizationDAO.name, [builtinApplication.OrganizationDAODS_fetch] Parameter p0: -888767]
  168. [java] 34 369330435 PicklistValueDAODS_fetch 15:31:11,661 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: District]
  169. [java] 34 1601081993 PicklistValueDAODS_fetch 15:31:52,381 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~'), [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: ParticipantRank%]
  170. [java] 33 1787960032 PicklistValueDAODS_fetch 15:33:06,667 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseWeight]
  171. [java] 32 1687459670 PicklistValueDAODS_fetch 15:33:06,728 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: ConflictOutcomeReason]
  172. [java] 32 896346008 MinimalGenericParticipantDS_fetch 15:31:35,149 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  173. [java] 31 161870011 MinimalGenericParticipantDS_fetch 15:31:46,715 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  174. [java] 30 404008028 MinimalAddressDAODS_fetch 16:17:53,927 [[builtinApplication.MinimalAddressDAODS_fetch] Query string: select _AddressDAO from com.legaledge.maestro.server.model.report.AddressDAO _AddressDAO where _AddressDAO.id = :p0, [builtinApplication.MinimalAddressDAODS_fetch] Parameter p0: 0]
  175. [java] 30 749511751 PicklistValueDAODS_fetch 15:31:52,016 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: ParticipantRank%]
  176. [java] 30 1066265705 PicklistValueDAODS_fetch 15:33:06,790 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: CaseGoalMeasure]
  177. [java] 30 1294539684 PicklistValueDAODS_fetch 15:32:01,244 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: AlternatIdStatus%]
  178. [java] 28 1544401403 MinimalGenericParticipantDS_fetch 15:31:54,670 [[builtinApplication.MinimalGenericParticipantDS_fetch] Query string: select _MinimalGenericParticipant from com.legaledge.harmony.summary.MinimalGenericParticipant _MinimalGenericParticipant where _MinimalGenericParticipant.caseId = :p0, [builtinApplication.MinimalGenericParticipantDS_fetch] Parameter p0: 375960]
  179. [java] 28 1862309862 PicklistValueDAODS_fetch 15:31:56,675 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: IntakeApprovalStatusReason]
  180. [java] 28 1871265089 CriminalDefendantDAODS_fetch 15:31:57,511 [[builtinApplication.CriminalDefendantDAODS_fetch] Query string: select _CriminalDefendantDAO from com.legaledge.maestro.server.model.report.CriminalDefendantDAO _CriminalDefendantDAO where _CriminalDefendantDAO.id = :p0, [builtinApplication.CriminalDefendantDAODS_fetch] Parameter p0: 387070]
  181. [java] 26 937512416 PicklistValueDAODS_fetch 15:33:06,718 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: DefenderCriminalCaseOutcome]
  182. [java] 25 2052409402 PicklistValueDAODS_fetch 15:31:52,019 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where _PicklistValueDAO.isActive = :p0 and (lower(PicklistDAOByPicklistId1.name) like lower(:p1) escape '~') order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: RepresentByRelationType%]
  183. [java] 20 446247347 PicklistValueDAODS_fetch 15:33:06,790 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where PicklistDAOByPicklistId1.id = :p0 order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: 0]
  184. [java] 20 413598217 PicklistValueDAODS_fetch 15:33:06,631 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: District]
  185. [java] 17 1729903964 PicklistValueDAODS_fetch 15:31:56,668 [[builtinApplication.PicklistValueDAODS_fetch] Query string: select _PicklistValueDAO, PicklistDAOByPicklistId1 from com.legaledge.maestro.server.model.report.PicklistValueDAO _PicklistValueDAO left outer join _PicklistValueDAO.PicklistDAOByPicklistId PicklistDAOByPicklistId1 where (_PicklistValueDAO.isActive = :p0 and _PicklistValueDAO.isActive is not null and PicklistDAOByPicklistId1.name = :p1 and PicklistDAOByPicklistId1.name is not null) order by _PicklistValueDAO.stringValue, [builtinApplication.PicklistValueDAODS_fetch] Parameter p0: true, [builtinApplication.PicklistValueDAODS_fetch] Parameter p1: IntakeApprovalStatus]
  186. [java] dataSource counts:
  187. [java] {OrganizationDAODS_fetch=4, CivilMattersAndPlayersDAODS_fetch=2, MinimalAddressDAODS_fetch=2, CriminalCaseDAODS_fetch=2, PrescottOpenCases_fetch=1, CaseDefendantToChargeDAODS_fetch=2, CriminalCaseSearchDAODS_fetch=2, CriminalDefendantDAODS_fetch=4, CaseToIncidentDAODS_fetch=4, MinimalGenericParticipantDS_fetch=8, PicklistValueDAODS_fetch=124, SearchCaseCourtDAODS_fetch=1, CaseToEventDAODS_fetch=1, DefenderIncidentDAODS_fetch=2, IncidentToAddressDAODS_fetch=2, OpenCaseToEventDAODS_fetch=2, MyOpenCases_fetch=1, PersonSearchDAODS_fetch=2, CaseCourtJudgeIntakeDAODS_fetch=1, DefenderPersonDAODS_fetch=1, CriminalCaseSummaryDAODS_fetch=4, MyAppearances_fetch=1, DivisionStaffPersonDS_fetch=1, RepresentByDAODS_fetch=1, CaseToCaseIdentifierDAODS_fetch=1}
  188.  
  189. BUILD SUCCESSFUL
  190. Total time: 2 seconds
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!