Capturing the AutoPLANT model name when extracting an iso with OPIM

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 

  • Hi Tyler,
    Do you have a solution on this yet?
    Thanks,
    Maggie
  • 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.

    Regards,

    Abhijit Bute

      


     

  • this sql does not work when a linenumber is used in multiple models. it returns the first match. For example, if both test1.dwg and test2.dwg contain line L-100, when running above query in test2.dwg, it might return test1.dwg for model name