| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="selectSearchList" resultType="com.dg.core.db.manual.pojo.Search"> |
|---|
| | | select distinct classify_id, type,parentClassifyId from ( select id,matter_name title,concat((select classify_name from automessage_classify_administration |
|---|
| | | select distinct classify_id, content,type,parentClassifyId from ( select id,matter_name title,concat((select classify_name from automessage_classify_administration |
|---|
| | | where id=(select parent_id from automessage_classify_administration where id=automessage_transaction_event.classify_id)), |
|---|
| | | '/',(select classify_name from automessage_classify_administration where id=automessage_transaction_event.classify_id)) content, |
|---|
| | | classify_id,(select parent_id from automessage_classify_administration where id=automessage_transaction_event.classify_id) parentClassifyId, |
|---|
