Hello team,
in one of our use case, we need to show multiple WTPart's details in a drawing as a table format. there could be 100 WTParts with ~15 attributes each. so the data will be sppaned across multiple sheets.
as of now design engineer has to manually create table and fill in all the data and we want to automate the process.
Solution:
- fetch the data from windchill using queryspec and populate the as "Parameters" of the drawing
- create a "Table Template" as file with '&variables' as key and add same Key values in 'Parameter' table.
- user then will select the table template from 'Table From File' option and place it on drawing, the drawing will automatically fill out the variable values from 'Parameter' section.
downside
- too many parameters are getting generated as of now. if drawing has 20 related WTParts with 20 values to be shown the 20 x 20 = 400 key values pairs will get generated. but it saves a lot of manual data filling.
- we have to create a table templates manually and add the variable names 1 Sheet hold 5 WTPart information with 5 x 15 table. so to show 20 WTParts info we need to create 4 Table templates.
thought this is a temporary solution and we are moving to PartsLink soon. bit the timeline is not defined yet how long it will take.
approaches we a trying..
- using AttributeDelegate. the issue with this approach is the delegate code is getting called multiple times on all check in, checkout, save, upload and publish event of the drawing which could slow down the system since there are 300 users working on system. we could add custom listeners for all these events though.
- Using J-link, as of now we are trying to figure out how we cab use J-link to fetch the data or to create a tables. since we can not access windchill api such as queryspec in J-link we are now trying to see if we can call WRS endpoints.
is there any other solution to this problem? please let us know.
thank you in advance!!
