get_mr.clmt 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. <templet>
  2. <version>1.0</version>
  3. <procedure _name="target">
  4. <parameters>
  5. <parameter>
  6. <name>sys</name>
  7. <description>系统代码,不传递时查询所有系统</description>
  8. <format></format>
  9. </parameter>
  10. </parameters>
  11. <elements>
  12. <table_query>
  13. <name>query</name>
  14. <dataSource>poc</dataSource>
  15. <addition>order by sys</addition>
  16. <table>mr_scope</table>
  17. <fields1>
  18. <bogda_item>
  19. <bogda_item>sys</bogda_item>
  20. <bogda_null/>
  21. </bogda_item>
  22. <bogda_item>
  23. <bogda_item>code</bogda_item>
  24. <bogda_null/>
  25. </bogda_item>
  26. </fields1>
  27. <fieldsWhere>
  28. <sys>=nvl(sys, $disabled)</sys>
  29. </fieldsWhere>
  30. </table_query>
  31. </elements>
  32. <output>
  33. <variable>
  34. <name>rtn</name>
  35. <assignment>query</assignment>
  36. </variable>
  37. </output>
  38. </procedure>
  39. <comments>
  40. <next_id>1</next_id>
  41. <list>
  42. <comment>
  43. <id>0</id>
  44. <items>
  45. <comment_item>
  46. <content>查询精细化机房范围</content>
  47. <update_time>2021-6-10 11:32</update_time>
  48. </comment_item>
  49. </items>
  50. </comment>
  51. </list>
  52. </comments>
  53. <comment_id>0</comment_id>
  54. </templet>