• State Not Answered
  • Replies 1 reply
  • Subscribers 15 subscribers
  • Views 204 views
  • Users 0 members are here
Options
Related

Add Documents To BOM Structure

Hargul Sidhu
Offline

Like the title says. I need the PDF version of all CAD documents to be shown in BOM and BOM Structure. 
Also, these have to be downloadable, if I can add a "Download All' button that would be cherry on top! 

I saw a post there similar to this. Do I need to edit the SQL query for this? Add joins to bring in the CAD documents? Which sql query would need to be edited? and is the "Download All" button implemented.

If someone can give me the detailed steps to accomplish this that would be awesome. 

Thanks!

  • 0

    The BOM Structure is based on a Query Definition and a Tree Grid view. You can modify these two and add additional ItemTypes. The cad document is on a different relationship level which maybe will bloat your view. Maybe you can create a property in side Part that links to the CAD directly? But this only works if you can somehow guarantee that there is a 1:1 relationship between CAD and Part. Anyway, play around with the TGV in a test data base first.

    A Download All button is possible, but needs some coding. I actually do something similar already (in my case my button shows all documents that are on sub-levels, but the basic query for download would be the same). You need an AML query to get all related files and than download a zip package. For this task a couple of official Aras samples are available that you can google. 

    Instead of using the download button inside the relationship, you can also directly add it to the parent item. This approach is pretty common. 

    Angela

Copyright © 2024 Aras. All rights reserved.