Tag Property Editing Constraints for Advanced Queries
When editing tag properties for advanced mode query results, the following constraints apply:
Edit Mode Constraints | Query Examples | Comments |
Edit mode is disabled for schemas other than ProcessFunctional and ProcessPhysical. | Select * from Electrical_RCM.CABLE_TROUGH | Following are few
example of schema where edit mode is disabled.
OpenPlantExtensions, OpenPlantBuilding,Bis.Element. |
Edit mode is disabled for process functional queries with missing ECClasssid, ECInstanceid and Model properties. | Select ecclassid, codevalue, alias, description, nominal_diameter from pfunc.Valve | ECClassId, ECInstanceId and Model properties are required. |
Edit mode is disabled for process physical queries with missing ECClasssid, ECInstanceid, Model and Checkoutid properties. | Select ecclassid,ecinstanceid,checkoutid,userlabel, alias, description, nominal_diameter from processphysical.Valve | ECClasssid, ECInstanceid, Model and Checkoutid properties are required. |
For Joins, only primary data is editable. | Select pmp.ecclassid, pmp.ecinstanceid, pmp.model, pmp.codevalue, pmp.Device_Type_Code, pmp.Description, pmp.MANUFACTURER, pmp.MODEL_NUMBER, do.codevalue, do.number, do.alias FROM pfunc.PUMP pmp LEFT JOIN pfunc.DOCUMENT_IS_RELATED_TO_OBJECT re ON pmp.ECInstanceID = re.TargetECInstanceID LEFT JOIN pfunc.PID_DOCUMENT do ON re.SourceECInstanceID = do.ECInstanceID WHERE pmp.codevalue IS NOT NULL | For this query only Description , MANUFACTURER, and MODEL_NUMBER will be editable. |
Edit mode is disabled for queries with property name set to "Alias". | Select codevalue, alias, description, nominal_diameter as DIA from pfunc.Valve | Nominal_Diameter set as "DIA". |
Edit mode is disabled for queries with aggregate functions. | Select MIN(dry_weight) from Pfunc.Vessel | Aggregate functions such as Min, Max, Sum, AVG, AGG. |
Edit mode is disabled for queries with mathematical expressions. | Select (Dry_weight/2) from Pfunc.Pump | Mathematical expressions such as +, -, *, /. |
Edit mode is disabled for queries with a transient data set. | Select ECInstanceid, ECClassid, codevalue, Description, Alias from (Select ECInstanceid, ECClassid, codevalue, Description, Alias from pfunc.Pump UNION Select ECInstanceid, ECClassid, codevalue, Description, Alias from pfunc.Vessel) | Transient or Nested Select statements. |