ThingWorx Developers

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.

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 ?

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

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

Hello.I am implementing mashup for a client and he wants to display on screen various bar charts, similar to those  you see in the picture. I used Themable  Bar Chart in Thingworx 9.3I used collection widget, each collection cell has only has this single chart widget.The problem is that client screen has small resolution and I can not allow to widget to have 32px padding. (see picture)Is there a way to remove/modify this two CSS rule (:host{} and [part~="chart-layout"])  from Shadow DOM?Thank you.Illya.

Hi,I am currently working on a project where we want the pageNumber to be controled via a session variable.When for example selecting an item and then clicking back, we want the last viewed pagination page to show. The property pageNumber is updated correctly when switching pagination page. But when clicking an item and back, it is not taking into account the last pagination page,How to solve this?// Oskar Berntorp

Hello, I have a csdk prorgam, i need to search specific element on infotable.I am trying to use the function twList_Foreach(twList *list, twForEachHander listHandler, void *userData) to find and update row on the infotable, but i am not succeeding.Can someone provide me with a sample to use this method please?my infotable contains 4 strings [field A , field B , field C , field D] , i am searching the row where B=='some specific string'if true update the row. Thank you very much for your help  

Trying to fetch the outgoing dependencies of a thing as an infotable  using the GetOutgoingDependencies service in the  PTC.Resource.RelationshipUtilities,  but facing this error : Error executing service. Message ::Unable To Convert From org.mozilla.javascript.UniqueTag to INFOTABLE - See Script Error Log for more details. Here: var thingName =   "sampleThing"var mxItems = 10;var mxDepth = 2;let params = {    target: thingName,    maxItems: mxItems,    maxDepth: mxDepth};    var relData = Resources["PTC.Resource.RelationshipUtilities"].GetOutgoingDependencies(params);

I am looking to use the API's put method to update an infotable property on a specific thing. Using postman I currently get a 406 - Not Accepted with the message being:JSON Content for HealthAndSafetyReport Was Not ValidProperties. When I use the Get method, I get the following response:  { "dataShape": { "fieldDefinitions": { "HealthAndSafetyReport": { "name": "HealthAndSafetyReport", "description": "", "baseType": "INFOTABLE", "ordinal": 24, "aspects": { "isIndexed": false, "isPersistent": true, "isLogged": false, "dataChangeType": "VALUE", "dataShape": "HealthandSafetyReport_DS", "cacheTime": 0.0 } } } }, "rows": [ { "HealthAndSafetyReport": { "dataShape": { "fieldDefinitions": { "Daily": { "name": "Daily", "description": "", "baseType": "STRING", "ordinal": 0, "aspects": { "isPrimaryKey": false } }, "Date": { "name": "Date", "description": "", "baseType": "STRING", "ordinal": 0, "aspects": { "isPrimaryKey": false } }, "Month_

If I am an Administrator is it possible to run a service temporarily on a Thing in a user role that is less privileged? I am working upon a use case wherein the user is not an Administrator. For this I need to keep removing myself from the Administrator's group, check if the mashup/services work, and if they don't request other team member to add myself back to the Administrators group and keep working. I would like to avoid this. Scenario is: 1. User Jack is an Administrator2. When service GetData on a Thing runs it has to do it in a user role which is less privileged than an Administrator3. Jack's user roles should not be affected in any way if this service runs. Thanks,Ashish Tamhane 

Hi,How to merge grid multiple headers into one header in thingworx version 9.4.3? (I have attached screenshot need to do like this in grid please check it) or any other for highlighting same featured headers in a grid like apply same css to the same featured headers? I tried to apply css in 9.3.4 twx version but it's not working for headers.Please suggest me asap.   

How to Reconnect ThingWorx to Kepware?   Translated by the Community Moderation using Google Translate ----------------------------------------------------------------------------------------------- Como Reconectaar o Thingworx ao Kepware ?

I'm currently binding a grid configuration from a service to the Advanced Grid. Everything works fine - except I can no longer see the binding to get the EditedTable.  Please let me know how this can be done? Using version 9.3.4

Hi Team, If data is not available in dropdown and after hitting button need to show status message for it how to do?please explain step by step. It will be helpful.  thanks.  

Hi everyone, I am using a service which is calling windchill data and then storing it in thingworx local database postgres sql now I want to automate this service on a specific interval so that it will automatically execute after a certain time what I am thing is using a scheduler thing template but not sure how can I implement it and the Thing  on which this service is present already using database template so I can't use two template in a single thing  so please give me a  better understanding if anybody's have any Idea. Thanks and Regards,Lav.