Hi there,
I'm looking for a way to grab the AutoPLANT model name that the iso was extracted from when using OPIM, and placing that value into the iso as text similar to the txt2node & node2da methods.
Thanks,
Tyler
Hi Tyler,
I can only give a pointer to the solution. it should be something similar to the two textnodes.txt entries shown below.
# this make a drawing attribute compID that gets the most common value of the component attribute GUID
compId = *(GUID)
# This is the query to get the modelname from the project database using compID
modelName = DBQUERY ($(DSN), SELECT D.DOC_NAME FROM DOC_REG AS D INNER JOIN RELATIONSHIPINSTANCE AS R1 ON R1.ID1 = D.DOC_ID WHERE R1.ID2='$(compID)' AND R1.RELATIONSHIPTYPE = 3)
Regards,
Frank
Answer Verified By: Rahul Kumar
Hello Maggie,
For getting drawing number in isometric please try following steps:
in textnode.txt file add following query :
modelName = DBQUERY ($(mydsn), SELECT DISTINCT DOC_REG.DOC_NAME AS FieldtoDisp FROM (DOC_REG INNER JOIN RELATIONSHIPINSTANCE DOCREL ON DOC_REG.DOC_ID = DOCREL.ID1) INNER JOIN (TAG_REG INNER JOIN RELATIONSHIPINSTANCE LINEREL ON TAG_REG.KEYTAG = LINEREL.ID1) ON DOCREL.ID2=LINEREL.ID2 WHERE DOCREL.RelationshipType=3 and LINEREL.RelationshipType=2 AND TAG_REG.TAG_NO = '$(LINENUMBER)')
Resulted isometric show model name
For more details steps refer following communities link:
http://communities.bentley.com/products/plant/design___engineering/w/plant_design_and_engineering__wiki/15447.adding-data-from-the-process-table-to-isometric-backing-sheetdrawing-frameseed-file
Hope this helps. Looking forward to your reply.
Abhijit Bute