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?
Hi Martin,We will investigate the concern and provide you an update accordingly.Regards,Lalitesh Vaidyar
Any update on this issue?
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.
Hi Martin,
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.
Hi Neha,
as already discussed, this code generally works.
But I need a small modification, and I didn't understand how modify it. Maybe you, or somebody else, can help me.
Your Query gives me, for pipelines who are connected to other pipelines, the name of the connected Pipe Run + Pipeline. But I just want to have the Pipeline (Piping_network_system) Name instead.
What did I have to modify?