topic Re: How can I retrieve active bound properties on a Thing on ver9.1 in ThingWorx Developers

topic Re: How can I retrieve active bound properties on a Thing on ver9.1 in ThingWorx Developers https://community.ptc.com/t5/ThingWorx-Developers/How-can-I-retrieve-active-bound-properties-on-a-Thing-on-ver9-1/m-p/921905#M65017 <P>Hi <a href="https://community.ptc.com/t5/user/viewprofilepage/user-id/767196">@TMnemo_11</a> ,</P><P> </P><P>If you want to get the remote bounded property values with quality,time & value means, below given code will helps you to acheive it. Kindly try with it, If any queries please let me know.</P><LI-CODE lang="javascript">var params = { infoTableName: "InfoTable", dataShapeName: "PropertyDefinition" }; // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(PropertyDefinition) var FinalData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params); // result: INFOTABLE dataShape: "PropertyDefinition" var PropertyData = Things[IP_AssetThingName].GetPropertyDefinitions({ category: undefined /* STRING */ , type: undefined /* BASETYPENAME */ , dataShape: undefined /* DATASHAPENAME */ }); // result: INFOTABLE dataShape: "" var PropertyLiveData = Things[IP_AssetThingName].GetPropertyValuesAsMultiRowTable(); var a = 0; for (; PropertyData.length > a; a++) { var PropertyDataRow = PropertyData.rows[a]; try { // result: INFOTABLE dataShape: "RemotePropertyBinding" var BindingData = Things[IP_AssetThingName].GetRemotePropertyBinding({ propertyName: PropertyDataRow.name /* STRING */ }); PropertyDataRow.sourceName = BindingData.sourceName; FinalData.AddRow(PropertyDataRow); } catch (e) {} } var params = { columns2: "name,description,baseType,isLogged,isPersistent,isReadOnly,sourceName" /* STRING */ , // columns1: "name,quality,time,value" /* STRING */ , joinType: "INNER" /* STRING */ , t1: PropertyLiveData /* INFOTABLE */ , t2: FinalData /* INFOTABLE */ , joinColumns1: "name" /* STRING */ , joinColumns2: "name" /* STRING */ }; // result: INFOTABLE var JoinData = Resources["InfoTableFunctions"].Intersect(params); result = JoinData;</LI-CODE><P>Expected Out: </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Arun_C_0-1704465008139.png" style="width: 400px;"><img src="https://community.ptc.com/t5/image/serverpage/image-id/95730i273C79A281B612F0/image-size/medium?v=v2&px=400" role="button" title="Arun_C_0-1704465008139.png" alt="Arun_C_0-1704465008139.png" /></span></P><P>Thanks & Regards,</P><P>Arun C</P> Fri, 05 Jan 2024 14:30:18 GMT Arun_C 2024-01-05T14:30:18Z How can I retrieve active bound properties on a Thing on ver9.1 https://community.ptc.com/t5/ThingWorx-Developers/How-can-I-retrieve-active-bound-properties-on-a-Thing-on-ver9-1/m-p/921837#M65012 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TM_10841814_0-1704447349778.png" style="width: 400px;"><img src="https://community.ptc.com/t5/image/serverpage/image-id/95708iD8765D17ED8E7E1F/image-size/medium?v=v2&px=400" role="button" title="TM_10841814_0-1704447349778.png" alt="TM_10841814_0-1704447349778.png" /></span></P><P>Is it possible to get a list of all bound properties and their source and VTQ on a Thing by executing a service? Ideally I would like to monitor bad endpoints and create some notification to help track and fix any problems. </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TM_10841814_0-1704447604910.png" style="width: 400px;"><img src="https://community.ptc.com/t5/image/serverpage/image-id/95709i40D06CD37B13A4AF/image-size/medium?v=v2&px=400" role="button" title="TM_10841814_0-1704447604910.png" alt="TM_10841814_0-1704447604910.png" /></span></P><P>I have tried the getBound Items function with no success, even though I have quite a number of properties bound on my thing.</P> Fri, 05 Jan 2024 09:44:51 GMT https://community.ptc.com/t5/ThingWorx-Developers/How-can-I-retrieve-active-bound-properties-on-a-Thing-on-ver9-1/m-p/921837#M65012 TMnemo_11 2024-01-05T09:44:51Z Re: How can I retrieve active bound properties on a Thing on ver9.1 https://community.ptc.com/t5/ThingWorx-Developers/How-can-I-retrieve-active-bound-properties-on-a-Thing-on-ver9-1/m-p/921905#M65017 <P>Hi <a href="https://community.ptc.com/t5/user/viewprofilepage/user-id/767196">@TMnemo_11</a> ,</P><P> </P><P>If you want to get the remote bounded property values with quality,time & value means, below given code will helps you to acheive it. Kindly try with it, If any queries please let me know.</P><LI-CODE lang="javascript">var params = { infoTableName: "InfoTable", dataShapeName: "PropertyDefinition" }; // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(PropertyDefinition) var FinalData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params); // result: INFOTABLE dataShape: "PropertyDefinition" var PropertyData = Things[IP_AssetThingName].GetPropertyDefinitions({ category: undefined /* STRING */ , type: undefined /* BASETYPENAME */ , dataShape: undefined /* DATASHAPENAME */ }); // result: INFOTABLE dataShape: "" var PropertyLiveData = Things[IP_AssetThingName].GetPropertyValuesAsMultiRowTable(); var a = 0; for (; PropertyData.length > a; a++) { var PropertyDataRow = PropertyData.rows[a]; try { // result: INFOTABLE dataShape: "RemotePropertyBinding" var BindingData = Things[IP_AssetThingName].GetRemotePropertyBinding({ propertyName: PropertyDataRow.name /* STRING */ }); PropertyDataRow.sourceName = BindingData.sourceName; FinalData.AddRow(PropertyDataRow); } catch (e) {} } var params = { columns2: "name,description,baseType,isLogged,isPersistent,isReadOnly,sourceName" /* STRING */ , // columns1: "name,quality,time,value" /* STRING */ , joinType: "INNER" /* STRING */ , t1: PropertyLiveData /* INFOTABLE */ , t2: FinalData /* INFOTABLE */ , joinColumns1: "name" /* STRING */ , joinColumns2: "name" /* STRING */ }; // result: INFOTABLE var JoinData = Resources["InfoTableFunctions"].Intersect(params); result = JoinData;</LI-CODE><P>Expected Out: </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Arun_C_0-1704465008139.png" style="width: 400px;"><img src="https://community.ptc.com/t5/image/serverpage/image-id/95730i273C79A281B612F0/image-size/medium?v=v2&px=400" role="button" title="Arun_C_0-1704465008139.png" alt="Arun_C_0-1704465008139.png" /></span></P><P>Thanks & Regards,</P><P>Arun C</P> Fri, 05 Jan 2024 14:30:18 GMT https://community.ptc.com/t5/ThingWorx-Developers/How-can-I-retrieve-active-bound-properties-on-a-Thing-on-ver9-1/m-p/921905#M65017 Arun_C 2024-01-05T14:30:18Z