OPPID CE / Plantsight - Pipeline - From/to property

Hi everybody,

I am looking for a solution to get the "From/To" property from pipelines (not Pipe_run) to Plantsight and to the page connectors.

And the one hand, we need this information for the pipeline lists, generated in plantsight. And on the other hand, we add this information to the Off-Page connectors. Until now, manually, but I guess there must an option to do this smart ;-)

Can somebody help me?

Parents
  • Hi Martin,

    We will investigate the concern and provide you an update accordingly.

    Regards,
    Lalitesh Vaidyar


  • Hi Martin,

    I have tried to customize the schema for cascading from/to Property in the Page connector. But it seems the values are not coming through in the element information. It would be nice if you raise an SR and we can discuss this issue further. You can follow the below wiki link for raising Service request.

    Product(s): OpenPlant Products Version(s): All Bentley Products Environment: GENERAL Area: N/A Subarea: N\A Overview How to log a SR informing of any problem…
    Last edited in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki


    Regards,
    Neha Chougule

  • Hi Martin,

    1. If you select the Pipeline and then click it again, you can see the From/To information for the Pipeline.

    1. And then:

     

     The reason you see the information for the pipeline is because the pipeline is really the intelligent part. Pipe run needs to terminate at another component (NOT a page Connector). using existing connector on New PID drawing, You can get information of From and TO on Piperun.



    To get From and To information on Plantsight, Use this advance query.

    SELECT

                    pl.codevalue AS [Pipeline Tag], pl.SERVICE AS [Pipeline Service], pl.Unit AS [Unit],

                    GROUP_CONCAT(se.size) AS [Pipe Run Sizes],

                    GROUP_CONCAT(se.codevalue) AS [Pipe Run Number],

            GROUP_CONCAT(DISTINCT se.codevalue) AS [Run Name],

                    GROUP_CONCAT(DISTINCT se.SPECIFICATION) AS [Pipe Spec],

                    GROUP_CONCAT(DISTINCT se.SIZE) AS [Run Size],

                    GROUP_CONCAT(DISTINCT se.FROM_COMPONENT) AS [From],

                    GROUP_CONCAT(DISTINCT se.TO_COMPONENT) As [To]

    FROM pfunc.PIPING_NETWORK_SYSTEM pl

                    LEFT JOIN pfunc.DOCUMENT_IS_RELATED_TO_OBJECT re ON pl.EcInstanceID = re.TargetECInstanceID

                    LEFT JOIN pfunc.PID_DOCUMENT do ON re.SourceECInstanceID = do.ECInstanceID

                    LEFT JOIN pfunc.PIPELINE_HAS_SEGMENT pse ON pl.EcInstanceID = pse.SourceECInstanceID

                    LEFT JOIN pfunc.PIPING_NETWORK_SEGMENT se ON pse.ECInstanceID = se.ECInstanceID

    WHERE pl.codevalue IS NOT NULL

    GROUP BY pl.codevalue

    ORDER BY pl.codevalue, se.codevalue


    Also If you require From and To properties cascaded from piperun and annotate on Off-Page Connectors, Then follow below wiki article.

    Applies To Product(s): OpenPlant PID Version(s): 08.11.10.XXX Environment: Windows 7 (64 bit) Area: Customization Subarea: …
    Last edited in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki


    Thanks and Regards,
    Neha Chougule

Reply
  • Hi Martin,

    1. If you select the Pipeline and then click it again, you can see the From/To information for the Pipeline.

    1. And then:

     

     The reason you see the information for the pipeline is because the pipeline is really the intelligent part. Pipe run needs to terminate at another component (NOT a page Connector). using existing connector on New PID drawing, You can get information of From and TO on Piperun.



    To get From and To information on Plantsight, Use this advance query.

    SELECT

                    pl.codevalue AS [Pipeline Tag], pl.SERVICE AS [Pipeline Service], pl.Unit AS [Unit],

                    GROUP_CONCAT(se.size) AS [Pipe Run Sizes],

                    GROUP_CONCAT(se.codevalue) AS [Pipe Run Number],

            GROUP_CONCAT(DISTINCT se.codevalue) AS [Run Name],

                    GROUP_CONCAT(DISTINCT se.SPECIFICATION) AS [Pipe Spec],

                    GROUP_CONCAT(DISTINCT se.SIZE) AS [Run Size],

                    GROUP_CONCAT(DISTINCT se.FROM_COMPONENT) AS [From],

                    GROUP_CONCAT(DISTINCT se.TO_COMPONENT) As [To]

    FROM pfunc.PIPING_NETWORK_SYSTEM pl

                    LEFT JOIN pfunc.DOCUMENT_IS_RELATED_TO_OBJECT re ON pl.EcInstanceID = re.TargetECInstanceID

                    LEFT JOIN pfunc.PID_DOCUMENT do ON re.SourceECInstanceID = do.ECInstanceID

                    LEFT JOIN pfunc.PIPELINE_HAS_SEGMENT pse ON pl.EcInstanceID = pse.SourceECInstanceID

                    LEFT JOIN pfunc.PIPING_NETWORK_SEGMENT se ON pse.ECInstanceID = se.ECInstanceID

    WHERE pl.codevalue IS NOT NULL

    GROUP BY pl.codevalue

    ORDER BY pl.codevalue, se.codevalue


    Also If you require From and To properties cascaded from piperun and annotate on Off-Page Connectors, Then follow below wiki article.

    Applies To Product(s): OpenPlant PID Version(s): 08.11.10.XXX Environment: Windows 7 (64 bit) Area: Customization Subarea: …
    Last edited in OpenPlant | AutoPLANT > OpenPlant | AutoPLANT Wiki


    Thanks and Regards,
    Neha Chougule

Children