Hello /*,
How can you Query the MEM of BRAN along with their DTXR?
For instance the report should extract all the components used to make this from BRAN HEAD to BRAN TAIL with their DTXR.
Thanks for your TIME!
Hello /*,
How can you Query the MEM of BRAN along with their DTXR?
For instance the report should extract all the components used to make this from BRAN HEAD to BRAN TAIL with their DTXR.
Thanks for your TIME!
Thanks for your reply Fariza.
The Query only reports NAMED items in a PIPE, like INST in the BRAN below.
How do you extract the NAMES of the unnamed items?
What PML code can convert the DBREFs of unnamed items to their NAMES?
And can it be used in a REPORT?
for that report, is represent condition of our model.
if named item, it will show with named. if not, it just showing ref. actually the report will show all you need, depend on your query you input. i say you report showing all item including not named item.
if you need to showing items name as your first picture, maybe you can combine in excel. try make ref as a key.
Depend on the method to assign name on E3D.
i don't know the macro that suitable for your condition, but rather than develop difficult PML, you can named your item with simple method.
usually, my method is : collect on the excel all unnamed item and give the name. And pasted in the command for execute. for example
=805324460/10 name /ESDV-3002
=805324460/12 name /ESDV-3003
=xxxx/yy name /ESDV-MMMM
Just continue as your list.
My suggestion, if you can't find in one way.
Try combine the other way. Try to use Excel, combine all you need with Vlookup.
Don't only deepen on macro or PML (except you know how to develop it). Try to use everting you know to get close to your goal,
Use Fullname instead of Name
with row use isnamed eq T
Thanks Henrik and Sri.