iT邦幫忙

0

[Aras筆記] 設定TreeGridView(1)-Query Definition

2018-10-23 12:24:07410 瀏覽

環境: Aras Innovator 11 sp12
參考文章: http://community.aras.com/en/tech-tip-filter-tree-grid-view-parameters/
如何自訂一個TreeGridView?
https://ithelp.ithome.com.tw/upload/images/20181023/20106503Sm3vFRl93E.png

首先,建立TreeGridView必須有Query Definition(搜尋定義),再藉由搜尋結果產生TreeGridView,因此第一部分先說明Query Definition。

https://ithelp.ithome.com.tw/upload/images/20181023/20106503lQJXy7avMA.png

Query Definitions

  1. 新增物件,並設定此搜尋是Part的內容
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503SKfQ1EoMJi.png

  2. 在Part加入Relationship
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503aszlexGeua.png

  3. 加入Part CAD 工程圖
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503nOoOSIUemR.png

  4. 同樣在CAD中加入子階工程圖CAD Structure
    https://ithelp.ithome.com.tw/upload/images/20181023/201065037hiyx9saiv.png
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503FmPwskwsSI.png
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503VsO6aGy6Ty.png

  5. 在子階工程圖加入遞迴查詢 Reuse Query Element Definition
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503mBxt1k4xpG.png

  6. 選擇父階CAD物件類型,按下Add
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503BgiIrM20v8.png
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503rrVSib2drq.png

  7. 開始加入Mapping的欄位, id,item_number,revision,generation,state,選擇完畢並儲存
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503vg2npzjVd4.png
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503uLGcvvyqnf.png
    https://ithelp.ithome.com.tw/upload/images/20181023/201065032Oj8Nl2D4C.png

  8. 建立搜尋條件參數 Edit Parameters
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503hFctKjH6TO.png
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503NFY8o7nq8J.png

  9. 在CAD的搜尋條件設定,輸入Released LIKE $cad_released 對應 第8點的參數name
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503RTadLUB2vk.png

  10. 在每個關聯 Part CAD, CAD structure加入Sequence屬性,並在order by 的部分加入Sequence
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503QZKfDH4ZGv.png
    https://ithelp.ithome.com.tw/upload/images/20181023/201065035YETcUUfPL.png
    https://ithelp.ithome.com.tw/upload/images/20181023/201065034mnqKVdXIm.png

  11. 上述完成後儲存,可以用Action測試搜尋是否成功
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503XCT02nHi3v.png
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503xvEg9umudZ.png

  12. 完成後如下圖,下一篇開始設定TreeGridView
    https://ithelp.ithome.com.tw/upload/images/20181023/20106503kOkyyEmvVj.png

下一章節 自訂 TreeGridView (2)-GridView


尚未有邦友留言

立即登入留言