Paste #207937

   
pasted on 20.07.2021 10:55
  • Edit to this paste
  • Print
  • Raw
  • Compare with paste
    #  
  • Toggle line numbers
  • Syntax highlighting  
Text paste
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
select networkrul0_.id as id1_30_, networkrul0_.close_code_id as close_co9_30_, networkrul0_.external_id as external2_30_, 
networkrul0_.is_active as is_activ3_30_, networkrul0_.is_deleted as is_delet4_30_, 
networkrul0_.name as name5_30_, networkrul0_.process_name as process_6_30_, networkrul0_.version as version7_30_, 
  networkrul0_.sort as sort8_30_, networkrul0_.target_unit_role_id as target_10_30_, 
  from cache_network_rule networkrul0_ 
  left outer join cache_network_rule_source_system_link sourcesyst1_ on networkrul0_.id=sourcesyst1_.rule_id 
  left outer join cat_source_system sourcesyst2_ on sourcesyst1_.source_system_id=sourcesyst2_.id 
  left outer join cache_network_rule_issue_class_link issueclass3_ on networkrul0_.id=issueclass3_.rule_id 
  left outer join cat_network_ticket_issue_class issueclass4_ on issueclass3_.issue_class_id=issueclass4_.id 
  left outer join cache_network_rule_source_unit_role_link sourceunit5_ on networkrul0_.id=sourceunit5_.rule_id 
  left outer join cat_unit_role unitrole6_ on sourceunit5_.unit_role_id=unitrole6_.id 
  left outer join cache_network_rule_source_task_type_link sourcetask7_ on networkrul0_.id=sourcetask7_.rule_id 
  left outer join cat_task_type tasktype8_ on sourcetask7_.task_type_id=tasktype8_.id 
  where networkrul0_.is_active is true    and networkrul0_.process_name='network_ticket_process' and networkrul0_.version=28
  and (tasktype8_.id=15 or tasktype8_.id is null) and (unitrole6_.id=165 or unitrole6_.id is null) 
  and (issueclass4_.id=1 or issueclass4_.id is null) and (sourcesyst2_.id=1 or sourcesyst2_.id is null);
Add Comment
Author