[2023-09-23 00:13:10 #168 query.manager] Query "select new lk.gov.health.phsp.pojcs.ClientBasicData(c.id, c.phn, c.person.name, c.person.nic, c.person.phone1, c.person.address ) from Client c where c.retired=false and ( lower(c.phn)=:q or lower(c.person.localReferanceNo)=:q or lower(c.person.ssNumber)=:q or c.person.phone1=:q or c.person.phone2=:q or lower(c.person.nic)=:q ) " => 7 results in 4254 milliseconds. lder name="c.person.name" type="java.lang.String" /> ="0.00/0.00" variable="v$1(Person)" binding="bound(c.person)" />

eval="2.74/2.71" var="$$owner,$$inv"> [2023-09-23 00:05:49 #25 query.manager] [2023-09-23 00:05:49 #26 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 2 milliseconds. [2023-09-23 00:05:49 #27 query.manager] [2023-09-23 00:05:49 #28 query.manager] [2023-09-23 00:05:49 #29 query.manager] [2023-09-23 00:05:49 #30 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 1 milliseconds. [2023-09-23 00:05:49 #31 query.manager] [2023-09-23 00:05:49 #32 query.tokenizer] [2023-09-23 00:05:49 #33 query.tokenizer] [2023-09-23 00:05:49 #34 query.compiler]

[2023-09-23 00:05:49 #35 query.compiler]

[2023-09-23 00:05:49 #36 query.compiler] [2023-09-23 00:05:49 #37 query.manager] [2023-09-23 00:05:49 #38 query.manager] [2023-09-23 00:05:49 #39 query.manager] Query "select p from UserPrivilege p where p.retired=false and p.webUser=:u " => 13 results in 25 milliseconds. [2023-09-23 00:05:49 #40 query.manager] [2023-09-23 00:05:49 #41 query.manager] [2023-09-23 00:05:49 #42 query.manager] [2023-09-23 00:05:49 #43 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 1 milliseconds. [2023-09-23 00:05:49 #44 query.manager] [2023-09-23 00:05:49 #45 query.manager] [2023-09-23 00:05:49 #46 query.manager] [2023-09-23 00:05:49 #47 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 1 milliseconds. [2023-09-23 00:05:49 #48 query.manager] [2023-09-23 00:05:49 #49 query.manager] [2023-09-23 00:05:49 #50 query.manager] [2023-09-23 00:05:49 #51 query.tokenizer] [2023-09-23 00:05:49 #52 query.tokenizer] [2023-09-23 00:05:49 #53 query.compiler] [2023-09-23 00:05:49 #54 query.compiler]

[2023-09-23 00:05:49 #55 query.compiler] [2023-09-23 00:05:49 #56 query.manager] [2023-09-23 00:05:59 #57 query.manager] [2023-09-23 00:05:59 #58 query.manager] Query "select count(c) from Client c where c.retired=:ret and c.createInstitution in :ins " => 1 results in 9834 milliseconds. [2023-09-23 00:05:59 #59 store] Database '/home/objectdb/objectdb-2.8.8/db/chims.odb' is closed by 2307@moh-hrms-lb [2023-09-23 00:06:02 #60 store] Database '/home/objectdb/objectdb-2.8.8/db/chims.odb' is opened by 2307@moh-hrms-lb [2023-09-23 00:06:02 #61 store] Configuration path: /home/objectdb/objectdb-2.8.8/objectdb.conf [2023-09-23 00:06:24 #62 store] Database '/home/objectdb/objectdb-2.8.8/db/chims.odb' is closed by 2307@moh-hrms-lb [2023-09-23 00:06:52 #63 store] Database '/home/objectdb/objectdb-2.8.8/db/chims.odb' is opened by 2307@moh-hrms-lb [2023-09-23 00:06:52 #64 store] Configuration path: /home/objectdb/objectdb-2.8.8/objectdb.conf [2023-09-23 00:07:01 #65 query.manager] [2023-09-23 00:07:01 #66 query.tokenizer] [2023-09-23 00:07:01 #67 query.tokenizer] [2023-09-23 00:07:01 #68 query.compiler] [2023-09-23 00:07:01 #69 query.compiler]

[2023-09-23 00:07:01 #70 query.compiler] :userName:notNull]) /> [2023-09-23 00:07:01 #71 query.manager] [2023-09-23 00:07:01 #72 query.manager] [2023-09-23 00:07:01 #73 query.manager] Query "SELECT u FROM WebUser u WHERE u.name=:userName and u.retired =:ret" => 1 results in 8 milliseconds. [2023-09-23 00:07:01 #74 query.manager] [2023-09-23 00:07:01 #75 query.tokenizer] [2023-09-23 00:07:01 #76 query.tokenizer] [2023-09-23 00:07:01 #77 query.compiler] <1 type="java.util.Collection" /> <$$owner varId="0" type="lk.gov.health.phsp.entity.Coordinate" subtypes="include" typeId="3" binding="null" nav="1"> <$$inv varId="1" type="lk.gov.health.phsp.entity.Area" subtypes="include" typeId="4" binding="$$owner.area" nav="0"> [2023-09-23 00:07:01 #78 query.compiler]

[2023-09-23 00:07:01 #79 query.compiler] [2023-09-23 00:07:01 #80 query.manager] [2023-09-23 00:07:01 #81 query.manager] [2023-09-23 00:07:01 #82 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 15 milliseconds. [2023-09-23 00:07:01 #83 query.manager] [2023-09-23 00:07:01 #84 query.manager] [2023-09-23 00:07:01 #85 query.manager] [2023-09-23 00:07:01 #86 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 1 milliseconds. [2023-09-23 00:07:01 #87 query.manager] [2023-09-23 00:07:01 #88 query.manager] [2023-09-23 00:07:01 #89 query.manager] [2023-09-23 00:07:01 #90 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 1 milliseconds. [2023-09-23 00:07:01 #91 query.manager] [2023-09-23 00:07:01 #92 query.tokenizer] [2023-09-23 00:07:01 #93 query.tokenizer] [2023-09-23 00:07:01 #94 query.compiler]

[2023-09-23 00:07:01 #95 query.compiler]

[2023-09-23 00:07:01 #96 query.compiler] [2023-09-23 00:07:01 #97 query.manager] [2023-09-23 00:07:01 #98 query.manager] [2023-09-23 00:07:01 #99 query.manager] Query "select p from UserPrivilege p where p.retired=false and p.webUser=:u " => 8 results in 18 milliseconds. [2023-09-23 00:07:01 #100 query.manager] [2023-09-23 00:07:01 #101 query.manager] [2023-09-23 00:07:01 #102 query.manager] [2023-09-23 00:07:01 #103 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 1 milliseconds. [2023-09-23 00:07:01 #104 query.manager] [2023-09-23 00:07:01 #105 query.manager] [2023-09-23 00:07:01 #106 query.manager] [2023-09-23 00:07:01 #107 query.manager] [2023-09-23 00:07:01 #108 query.manager] [2023-09-23 00:07:01 #109 query.tokenizer] [2023-09-23 00:07:01 #110 query.tokenizer] [2023-09-23 00:07:01 #111 query.compiler] [2023-09-23 00:07:01 #112 query.compiler]

[2023-09-23 00:07:01 #113 query.compiler] [2023-09-23 00:07:01 #114 query.manager] [2023-09-23 00:07:01 #115 query.manager] [2023-09-23 00:07:01 #116 query.manager] Query "select i from Institution i where i.retired=:ret order by i.name " => 3043 results in 28 milliseconds. [2023-09-23 00:07:01 #117 query.manager] [2023-09-23 00:07:01 #118 query.manager] [2023-09-23 00:07:01 #119 query.manager] [2023-09-23 00:07:01 #120 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 6 milliseconds. [2023-09-23 00:07:01 #121 query.manager] [2023-09-23 00:07:01 #122 query.manager] [2023-09-23 00:07:01 #123 query.manager] [2023-09-23 00:07:01 #124 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 2 milliseconds. [2023-09-23 00:07:01 #125 query.manager] [2023-09-23 00:07:01 #126 query.manager] [2023-09-23 00:07:01 #127 query.manager] [2023-09-23 00:07:01 #128 query.manager] Query "SELECT $$owner, $$inv FROM Coordinate $$owner JOIN $$owner.area $$inv WHERE $$inv in ?1" => 0 results in 1 milliseconds. [2023-09-23 00:07:01 #129 query.manager] [2023-09-23 00:07:01 #130 query.tokenizer] [2023-09-23 00:07:01 #131 query.tokenizer] [2023-09-23 00:07:01 #132 query.compiler] [2023-09-23 00:07:01 #133 query.compiler]

[2023-09-23 00:07:01 #134 query.compiler] [2023-09-23 00:07:01 #135 query.manager] [2023-09-23 00:07:02 #136 query.manager] [2023-09-23 00:07:02 #137 query.manager] Query "select count(c) from Client c where c.retired=:ret and c.createInstitution in :ins " => 1 results in 533 milliseconds. [2023-09-23 00:07:02 #138 query.manager] [2023-09-23 00:07:02 #139 query.tokenizer] [2023-09-23 00:07:02 #140 query.tokenizer] [2023-09-23 00:07:02 #141 query.compiler] [2023-09-23 00:07:02 #142 query.compiler]

[2023-09-23 00:07:02 #143 query.compiler] :d)> [2023-09-23 00:07:02 #144 query.manager] [2023-09-23 00:07:04 #145 query.manager] [2023-09-23 00:07:04 #146 query.manager] Query "select count(e) from Encounter e where e.retired=:ret and e.encounterType=:ec and e.createdAt>:d and e.institution in :ins " => 1 results in 1634 milliseconds. [2023-09-23 00:07:04 #147 query.manager] [2023-09-23 00:07:04 #148 query.manager] [2023-09-23 00:07:04 #149 query.manager] [2023-09-23 00:07:04 #150 query.manager] Query "select count(e) from Encounter e where e.retired=:ret and e.encounterType=:ec and e.createdAt>:d and e.institution in :ins " => 1 results in 805 milliseconds. [2023-09-23 00:07:04 #151 query.manager] [2023-09-23 00:07:04 #152 query.tokenizer] [2023-09-23 00:07:04 #153 query.tokenizer] [2023-09-23 00:07:04 #154 query.compiler]


  
    
      
        
          
            
              
              
            
            
               exp="f.createdAt" type="java.util.Date" var="f" directVar="f" ext="10000">
                
                
              >




[2023-09-23 00:07:04 #155 query.compiler] 

  
    
      
        
          
            
              
            
          
        
      
    
    
      
    
  
  
    
      
        
          
        
      
    
    
      
    
  
  
    
      
        
          
            
          
        
        
          
            
              
                
                  
                
              
            
          
        
      
    
    
      
        
          
            
              
                
              
            
          
        
        
          
            
          
        
      
      
        
          
            
              
                
              
            
          
        
        
          
            
          
        
      
    
    
      
      
    
  



[2023-09-23 00:07:04 #156 query.compiler] 

  
    
      :ret)>
        
          =:fd),(f.createdAt<=:td))>
            
              
            
          
        
      
      
        
          
        
      
    
  
  
    
      :ret)>
        
          =:fd),(f.createdAt<=:td))>
            
              
            
          
        
      
      
        
          
        
      
    
  



[2023-09-23 00:07:04 #157 query.manager] 

  
    
      
        
          
            
              
            
          
        
      
      
        
          
        
      
    
  



[2023-09-23 00:07:06 #158 query.manager] 

  



[2023-09-23 00:07:06 #159 query.manager] 
Query "select count(f)  from ClientEncounterComponentItem f  where f.retired<>:ret  and f.item.code=:ic  and f.shortTextValue in :ivs and f.createdAt between :fd and :td " => 1 results in 1152 milliseconds.