| | |
|---|
| | | department_id, |
|---|
| | | department_area, |
|---|
| | | classify_id, |
|---|
| | | (select classify_name from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id) as classifyName, |
|---|
| | | (IF((select classify_grade from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)='2', |
|---|
| | | (select classify_name from automessage_classify_administration where automessage_classify_administration.id=(select parent_id from |
|---|
| | | automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id)), |
|---|
| | | (select classify_name from automessage_classify_administration where automessage_classify_administration.id=automessage_transaction_event.classify_id))) as classifyName, |
|---|
| | | (select organization_name from automessage_organization_chart where automessage_organization_chart.id=automessage_transaction_event.department_id) as departmentName, |
|---|
| | | matter_name, |
|---|
| | | associate_ids, |
|---|
