IoT & Connectivity

Hello Community,   I've been trying to figure out how to use the "select" key in the JSON query functionality of QueryStreamData...   me.QueryStreamData({ // oldestFirst: undefined /* BOOLEAN */, // maxItems: undefined /* NUMBER {"defaultValue":500} */, // sourceTags: undefined /* TAGS */, // endDate: undefined /* DATETIME */, // query: undefined /* QUERY */, // source: undefined /* STRING */, // startDate: undefined /* DATETIME */, // tags: undefined /* TAGS */, // });   However I haven't had any luck... There is no datashape returned for this service, and even if there was one, I'm not entirely sure I could get it to work.   I have do have a datashape for the stream of course, and I did try to use that using the following query: "select": [ { "dataShapeName": "MyDataShape", "fieldName": "FieldName" } ]  But that didn't work either.   I also tried just querying everything from my stream and doing an infotable query: let test = DataShapes["MyD

Dears,     as screenshoots below, when a simulated float transferred from kepware to thingworx, 1.2 turns to 1.2000000476837158, so a false alarm triggered. Misdata logged in influxdb as well.a simulated float which is 1.2 on kepwarebut on thingworx that turns to 1.2000000476837158alarm triggered when property is above 1.2So a false alarm triggered I can't change data restricted to external audit, what can I do to modify the data to the correct.

Hello, everyone.Why the web denies access？Please help me out.

Hello Community,   I just got stuck on an issue and was hoping that perhaps someone here could help me. I am using the QueryNamedPropertyHistory function for a property.   Getting this data, I want to loop it over and use each value for something.   Now, the issue I am facing is that the infotable data shape being used for the QueryNamedPropertyHistory is "dynamic".   It has the "timestamp" column and then the value column with is named after the property. This makes it so I cant just do:   const propertyValues = Things[EntityName].QueryNamedPropertyHistory({ ***params*** }); propertyValues.rows.toArray().forEach((element) => { let propertyValue = element.value; let propertyTimestamp = element.timestamp; });   As the "value" column changes name based on the property name.   I know you can do something like:  Things[DynamicThing][DynamicProperty]   But is something similar possible in my use case? Or how would you go about it? &nbsp

1. What version of Thingworx are you currently running?Thingworx 9.3.7 2. Describe the problem you are trying to solve. Please include detailed documentation such as screenshots, images or video.I need to send "Alerts and "Notifications" as SMS, through WHATSAPP3. What business value would your suggestion represent for your organization?When ever alert occured,Need to send a notification to the user,  through WHATSAPP. Now a  days everyone closely monitoring WHATSAPP only.

Hi, everyone. I have a question when I trying to make a Thingworx smart city demo clone like this video and website ThingWorx Industrial IoT Platform - Creating Smart Building Applications - PTC Demo Video Gallery | IoT start from 3:00 to 3:20 and SmartCitiesDataView . And my question is how do I do like the video shows, how to interactive with the lights and rooms.For example.1. when I select the room and the Lights controller become green because all lights in this room are on, when I click the green button then the lights will turn of like this  and the button turn to gray from green.2.  When I click the red light the Light controller will turn to red and the service light button turn to red. Dose any one know how to achieve this goal? Please tell me how to do or some hits.I know if use javascript and HTML, CSS to do this is not that hard even I can use frontend framework like React or Vue to do this, but in thingworx

Hello, I want to update a row in an infotable in my CSDKI have an infotable  i am iterating via twList_Foreachmy infotable contain sevaral fields : Id, field A, field B, field CI want to iterate my infotable row by row if i found the id already exist, i have to update the fields (A, B, C)This my code:twList_Foreach(it_List, search_ForeachHandler, params)in the param i am passing the id to serachin my search_ForeachHandler:static int search_ForeachHandler(void* key, size_t keySize, void* currentValue, void* userData) { twInfoTableRow* value = (twInfoTableRow*)currentValue; //id to search int* id= (int*)userData; if (*id == twInfoTableRow_GetEntry(value, 0)) { //Get Field A twPrimitive* it_field_a = twInfoTableRow_GetEntry(value, 1); it_field_a = TW_MAKE_STRING(params->message_id); //Same for field B et C .... return TW_FOREACH_EXIT; } return TW_FOREACH_CONTINUE; }I thought I am modifying row field by address. but apparently it's a copy.Do yo

How we can get the users mail from the windows login in thingworx

I have 2 views data(table in each view please check screenshot) fetched it from SQL query in Thingworx and in that 2 views  same columns are available. Issue is - In first view of gcid column 4928 is not available and in 2nd view it's available so, I want to compare both the views data row by row. I want to fetch 4928 gcid platform column from 2nd view and want to show platform for 4928 gcid on UI (Same data available in both the views except 4928 gcid) I have attached ss of both the views data and already written code in attached file. please check it. code is already written by developer. I have to do changes for it.On UI now showing following platforms need to add one more platform from 2nd view data(UI screenshot attached at the end)(AvailabilityPlatformSummaryTable) and (SBDAvailabilityGC_PlatformTable )views names in codeUnable to apply logic for it. where should I do changes in code? Please let me know asap.If something is needed please ask me.  Thank you.

Is there a way to format the Numeric Entry widget so the number has the thousands seprator of a comma? It would be helpful to have this with large numbers. 

Hi,I am creating a service that fetches data from an external api with subsequent actions that needs to be run in a certain order. As an api call needs to finish, I wonder how to run code asyncroniously in a thingworx service?   I tried to write an async function, but I got the error in the image bellow, writing use 'esversion: 8' did not work.  

Hello,   Is there any method, we can trigger a subscription if the ThingWorx platform is going to shut down?   If not, is it possible to get the date and time when the last platform Shutdown happened? I am looking for either the ThingStop Event just like ThingStart, or the server shutdown time.   Any pointers would be very Helpful.   Thanks and Regards, Bhushan

Hello Community, We have a rest server that acs like proxy between the iot devices and twx. When our sever sometimes try to do post with the device data we receive from Thingworx this error: 2024-01-09 02:54:06,943 34670452 ERROR c.a.c.client.ThingworxClient - An exception occurred during the request: /ip GOAWAY receivedWhen happen this error in thingworx? Thank you in advance,Luis.

I have recently upgraded old server's ( x2) with new S2019. I installed the latest Version 6.15.132.0 of KEPServerEX and the backup configuration of my existing installation. I have an assortment of ROC RTU's and Allen Bradly Control Logix PLC's. All of the remote devices communicate but one of the PLC's won't update the tags? The configuration file is the same and works on the old installation but nothing will update for this one device on the new S2019's.

When I am trying to publish a simulator tag value to a broker I am facing the below error. Can someone tell me how to fix the errorMQTT agent 'MQTT Broker' failed to process write request on topic '123' - reason: 'Cannot deserialize value of type `[Lcom.kepware.agents.mqtt.WriteValue;` from Object value (token `JsonToken.START_OBJECT`)_ at [Source: (String)"{"timestamp":1704956770208,"values":[{"id":"Simulator.Long.Rand","v":49,"q":true,"t":1704956770198}]}"; line: 1, column: 1]'

I would like to find out if the "Advanced Tags" functionality is part of the Kepware Manufacturing Suite. I can only find the list of included drivers but not whether other modules are also part of the suite. I hope someone here knows. Thank you.

Reference topic - https://community.ptc.com/t5/ThingWorx-Developers/how-to-add-multiple-color-state-definition-in-shape-widget/m-p/754978#M55073   So is this means I can't create progress bar in mashup ?

Hello All,  We are moving forward to understand how advanced tags can create value to our DPM and AMU Environment. Lately we have come to the idea that reading the tool life would be beneficial to us. We are using MTConnect protocol to monitor our Mazak Assets.  Checking with Mazak their MT connect code, does not support the tool life, i would like to know if someone is currently monitorizing this information. 

i've created a service for creating folder in the repository, how can i get the created folder name in the output as string/text? thankskeerthi

I have requirement to find unmatched rows from two tables.Basically need to compare one table data to another table and save the unmatched records from first table into new table.I used intersect to solve this.but getting Unable To Convert From org.mozilla.javascript.UniqueTag to INFOTABLE error.  try {let Status = 'Accepted';let Project;let WorkPackage;let WorkOrder;let Jobcard;let InsertProjectData;let currentuser = Resources["CurrentSessionInfo"].GetCurrentUser();var currentdate = Date.now();  let EIDWData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DWM_ DB_EIDWACTIVITYVERSION_DS"});let DWMProjectData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DWM_DB_PROJECT_DS"}); let DWMWorkPackageData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DWM_DB_WorkPackage_DS"});let DWMWork

I tried to export the complex tags (advanced tags) created in one instance to other using Export/Import CSV it is not taking the mapped tags within them. How can i get it done with the mapped tags along with complex tag. 

Hello @AB_10607533, we have the same issue you marked as resolved in this thread, we want to read and write inside the address #10095 via the Fanuc Focas Ethernet protocol using the "Open" model. How did you managed to solve the problem? The documentation linked in the answer (link) clearly states that the "#" variables range is limited to #9999: Thank you,Riccardo

Hi PTC, In my thingworx service am trying to query influxDB to get the moving average and the standard deviation of one or more properties. Below is my code: //AggregateFunctions_Inputs is an array of inputsAggregateFunctions_Inputs.forEach(functionName => {if(functionName === "stddev"){//stddevfluxQuery += 'from(bucket: "thingworx")' +'|> range(start: ' + start + ', stop: ' + end + ')' +'|> filter(fn: (r) => ' + Measurements_Inputs.map(m => 'r["_measurement"] == "' + m + '"').join(' or ') + ')' +'|> filter(fn: (r) => ' + Fields.map(f => 'r["_field"] == "' + f + '"').join(' or ') + ')' ;}else if (functionName === "movingAverage"){//movingAveragefluxQuery = 'from(bucket: "thingworx")'+'|> range(start: '+start+')' +'|> filter(fn: (r) => ' + Measurements_Inputs.map(m => 'r["_measurement"] == "' + m + '"').join(' or ') + ')' +'|> filter(fn: (r) => ' + Fields.map(f => 'r["_field"] == "' + f + '"').join(' or ') + ')' +'|> movingA

I have a main grid widget on my mashup and I would like to display another grid widget upon clicking a cell on the main grid the way a popup would work. Is this possible on Thingworx version 9.4?

I have a scenario where I am executing a  child service (inputs: ThingShape, Thing and Boolean) from another wrapper service. Now the child service fails if I pass a ThingShape that does not exist, so I am trying to write something like:If ThingShape Exists :TS = TS_NAMEElse:TS = undefined.How do I achieve this ?I have checked many OOTB services but none help with this.TWX v9.3.4