工作流模板中行輸入宏控件如何調(diào)用崗位、部門、職級等信息?是采用自定義SQL數(shù)據(jù)源實現(xiàn)嗎?
當(dāng)前位置:點晴教程→點晴OA辦公管理信息系統(tǒng)
→『 經(jīng)驗分享&問題答疑 』
![]() ![]() 行輸入宏控件不能直接調(diào)用宏控件,網(wǎng)管可以設(shè)置行輸入宏控件中某個字段指定數(shù)據(jù)源,將數(shù)據(jù)源指向后臺相關(guān)數(shù)據(jù)庫表即可: 點擊維護,就可以設(shè)置要調(diào)用的數(shù)據(jù)源了,詳細(xì)設(shè)置方法參見: 調(diào)用SQL參考: 崗位:SELECT position_name as main_info FROM mis_position where pri>0 and pri<90 order by pri 部門:SELECT dept as main_info FROM dept where dept<>'網(wǎng)管' order by dept_all_code 職級:SELECT userlevel as main_info FROM userlevel where pri>0 order by pri
該文章在 2017/1/23 12:04:55 編輯過 |
關(guān)鍵字查詢
相關(guān)文章
正在查詢... |