ThingWorx

Can I communicate directly from my edge device/gateway to ThingWorx via MQTT? If so, is there any documentation on configuring this connection?

Hey Community, I m trying to query a machform and i want to show the average of 3 choices in the machform matrix in output but it didnt seem to work: SELECT date_created as Date, Line.`option` as Line, z1.`option`as S1, z2.`option` as S2, z3.`option` as S34 , AVG(z1, z2, z3) as SGFROM ap_form_122320 FLEFT JOIN ap_element_options Line ON Line.form_id = 122320 AND Line.element_id = 3 AND Line.option_id = F.element_3LEFT JOIN ap_element_options z1 ON z1.form_id = 122320 AND z1.element_id = 48 AND z1.option_id = F.element_48LEFT JOIN ap_element_options z2 ON z2.form_id = 122320 AND z2.element_id = 49 AND z2.option_id = F.element_49LEFT JOIN ap_element_options z3 ON z3.form_id = 122320 AND z3.element_id = 50 AND z3.option_id = F.element_50Where F.date_created >= [[StartDate]]and F.date_created <= [[EndDate]]  but i keep getting execution errors. How can I get the average of more than One column/ matrix option in SQL ? thanks a lot !

Hello, In Thingworx, while creating Things, we can specify the properties as read-only also. According to the documentation https://support.ptc.com/cs/help/thingworx_hc/thingworx_7.0_hc/index.jspx?id=ThingProperties&action=show , it mentions that only way of changing this type of property is when we change its default value. Now my question is, how does 'isConnected' property which is of read-only type in 'RemoteThing/IndustrialGateway' template changes its state when the Thing using these templates is connected to SDK or Industrial Connectivity platform?   -Aditya Mittal

Hello Everyone,   I have Question If Possible have date pickup inside Grid table  in the below table for daily action i want when the Clint click on Due date open date widget to select instate of write by hand  Thanks, Islam

I have created table1 for daily direction in "Mysql workbench 6.3 CE" with 11 Rows , I want to archive all data table in another table archive every day since 2 years to have all history. How can I write such a table? This the table script: CREATE TABLE ``table1( IDINT(11) NOT NULL, tskVARCHAR(200) NULL DEFAULT NULL, labelVARCHAR(45) NULL DEFAULT NULL, statVARCHAR(10) NULL DEFAULT NULL, noteVARCHAR(200) NULL DEFAULT NULL, dateVARCHAR(45) NULL DEFAULT NULL, recVARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (ID), UNIQUE INDEXID_UNIQUE(ID` ASC));

Hi, I wanted to make a label as marquee inside a panel. How can I make it possible? And how can I define this simple html marquee tag in ThingWorx service? <marquee>Default scrolling</marquee> Please provide some idea.  Thanks, Shalini V.

Kindly what is the name of widget used in the screen which I attached in this post.

How TW Analytics could be used for finding dependancies / correleations between fields in a dataset. I.e. for the dataset on the screenshot below I would expect to get insights like   If x2=3 then x1 is guaranteed to be 7 If x5=3 and x4!=2 then x1 is rather likely (80%) to be 8 If x1=6 then x3 is most likely (~85%) to be 7 and so on   The first approach that came to my mind is that this is basically a categorical (ordinal?) data, but currently handling it in TWA is only possible using custom code / mashups etc   So then I thought about adding another boolean column, say, 'target' and set it to '1' for a given value of a field (say, for x1=8) and then dropping the x1 field from the dataset.   This kind of works, but requires a bit of overhead activities.   Do I understand the things right? Am I missing some other approaches?  

Hello anyone.   I have data in MSSQL. How I send data to Thingworx?   I want to send data when some data income to MSSQL.   Thank you

When I used LandingPageAccessAppMashup, I get output i.e. part details, but when I create my own mashup I get the error like:  [context: com.thingworx.webservices.context.HttpExecutionContext@7bf42e1f][message: Execution error in service script [ExecuteSavedSearch] :: Connection refused: connect]     Also, windchill is not installed on my system, it's on another system, but in the same network.   Service from "ptc-windchill-demo-thing"      getRestUrl services gives output as:                                                                            http://localhost:7080/Windchill/servlet/rest                                                &nbsp

Hi All,I would like to see in the Three Model Viewer the file from Creo (pvz format file).Which extension should be loaded?Many ThanksBRDimitri

I just try to view some data out of my Thingworx instance through the H2 Console. Does anyone know in which table I can find something?

1. I have a asset A1 with property A1P1 and A1P2(Lets say i create a template A)2. I have a sensor S1 with property S1P1 and S1P2(Lets say i create a ThingShape S)If i have scenario with 1 sensor(S) and 1 asset(A), I can create a thing which implements ThingTemplate A and ThingShape S.But how should i model on thingworx where if i have asset(A) with two sensors(S), here the sensors are same but attached to asset(A) at two different ends.1. Here How will i create a Thing and what should be my model to achieve it .2. If i want to show properties of two sensors(S) on the same mashup with the asset(A) properties, how will i get to know what properties thing it should pull??3. Do we have a provision to capture additional info(apart from what we have currently in property info) for the property of a thing, like having a custom string or infotable associated to a property.It may happen that i may have multiple sensors( of same type S) on the asset(A) but i need to show all the properties of t

Hi, I wanted to make a label inside a panel to be marquee and moving to left. I wrote a simple css using keyframe rule but it doesn't work.   @keyframes marquee { 0% { left: 0; } 100% { left: -100%; }} .testLabel .widget-Label { animation: marquee 5s linear infinite;} testLabel is my Label name. How can I proceed?    Thanks, Shalini V.

Hello, Is it possible to add/set multiple category to same property or service? When we define a property in a Thing, there is a provision also to add a Category (which is helpful in organising and searching), so I would like to know if I can put a property/service in multiple category? If yes, then how? To better understand what I mean please refer the attached screen shot. So in the screen shot I have 2 properties, property t1 has (better to say, I tried to put) category as POLLED, PLOTTABLE while t2 has category as POLLED. What I would want is when I call the service (generic service) 'GetPropertyDefinitions' with category parameter as POLLED, I should get both t1 and t2 (right now I am only getting t2) and when I call the same service with category parameter as PLOTTABLE, I should get only t1 (right now I am getting nothing). Please suggest if that's possible. Thanks in advance Regards Aditya Mittal

Hello Team, I am trying to implement a solution that has 2 branches : Branch 1 : publish sensor data through simulated devices on node red to Thingworx iot platform using mqtt protocol Branch 2 : create web application in nodejs that subscriber to these messages using mqtt   The only problem i am facing is that , from my understanding of all the threads on this community, thingworx does not provide any mqtt broker for mqtt connectivity. It only provides an mqtt client like eclipse paho and we need to integrate the mqtt extension with our own mqtt broker: that can be AWS, Azure or Mosquitto and so on.   Kindly confirm and suggest otherwise   Thanks, Aarushi

Hello All   I have one table with different targets i want color each cell with the right target if in or out I have try but the grid give me only one style for the column ,  Do you have any Idea how it work?      

I am trying to use Thingworx git extension. I used this guide: https://app-direct-www-cloudfront.s3.amazonaws.com/downloads/196081/Git_Backup_Extension_User_Guide_1.3.1.pdf   I had everything setup successfully based on the guide.    I got a problem when I tried to import entities using the Source Control Entities from Import menu:  Error executing API request message, sending error response to caller!   At the log, I got info message before the error message saying: Successfully added for import "file name"    Can  you please help! 

Hello Community,   I hope my English is sufficient to explain my Problem.   I developed an App in Unity to transfer Data/Information about Test Parts for my Masterthesis and I am nearly finished. I have only one Problem to transfer Data from my Unity App to our ThingWorx Server.   I wrote an Service to transfer my Data to my Info Table:   ServiceCode:   var koorDaten = new Object(); koorDaten.Koordinaten = objektkoor; koorDaten.Betreff = objektbetreff; var tablereference = me.Koor; tablereference.AddRow(koorDaten); Code in Unity string myPostData = "{\"objektKoor\":\"" + 444545 + "\", \"objektBetreff\":\"" + 1333 + "\"}"; byte[] pData = Encoding.ASCII.GetBytes(myPostData.ToCharArray()); Debug.Log(pData); string auswertung = Encoding.ASCII.GetString(pData); Debug.Log(auswertung); Debug.Log(System.BitConverter.ToString(pData).Replace("-", string.Empty).ToLower()); Dictionary<string, string> dictionary = new Dictionary<string, string>(); dict

I`m going trough  valuestream entries and filtering them and saving to infotable in a service. Basicaly im totalling values between hour A to hour B on each day for a week.   Problem is I get error when i use: Totall+= StreamValue;   Im getting error: "Wrapped org.json.JSONException: JSON does not allow non-finite numbers. Cause: JSON does not allow non-finite numbers."   everythign works fine if I use Totall+=1 or Totall= StreamValue;  but  +=StreamValue makes a problem.   Code used: var params = {                 oldestFirst: undefined /* BOOLEAN */,                 maxItems: undefined /* NUMBER */,                 endDate: undefined /* DATETIME */,             &nb

Hi everyone! I'm quite new on TW, and i'm trying to learn how to build a .NET app.The official references talk about a "Steam Sensor Example", but where is it hosted? Where can i download it?   ref: http://support.ptc.com/help/thingworx_hc/thingworx_edge_sdks_ems/index.html#page/latest%2Fdotnet_sdk%2Fc_new_steamsensor_example.html%23wwID0EDB6S   Thanks in advance 😄

We're looking for develop a predicition for a brake prototype. We found this video of PTC (from minute 3):   From 3th minute you can see the use of ThingPredictor to display the time of failure. Our question would be how to develop such a prediction, to say in how many days an error will occur or it will fail out. Are there any guides to that specified pump serve video/usecase or how can we get some support in this topic? Yours sincerely

I assume it's possible to export from TW 8.0 and then import into TW 8.3, but if I wanted to export from 8.3 and then import into 8.0, would I encounter issues (ignoring for a moment extensions).  Would I simply need to take care to avoid using features that are only available in the later version?   More broadly, is there any guidance / matrix  available as to which versions play nicely and those that don't when importing / exporting entities between them?   Thanks to anyone that can point me in the right direction in this matter.      

Hi, Can anyone please help me in providing solution to create progress bar using shape?  Have seen some comments in one of post that can be done with shape. Attaching screen shot for reference , I  need to change color to red from green when it is close to threshold value.    

Does anyone know how to convert timestamp to Datetime in Javascript please? thank you so much?  This is my service that returns dates but in MS i need to bind its output to an SQL query who uses datetime as inputs :  var currentDate=new Date(Date.now());var currentWeekDay=currentDate.getDay();var currentHour=currentDate.getHours();var currentMonthDay=currentDate.getDate();var currentMonth=currentDate.getMonth();var currentYear=currentDate.getFullYear();var SelectedButton ;var myStartDate;var myEndDate ;var i=currentWeekDay;var j=currentMonthDay;var newEntry=new Object ();if (SelectedButton=="Yesterday"){ myStartDate=currentDate; myStartDate.setDate((currentDate.getDate())-1); myStartDate.setHours(06); myEndDate=new Date(Date.now()); myEndDate.setHours(06); }if (SelectedButton=="Week To Date"){ myStartDate = currentDate; myStartDate.setHours(06); if(j<i) { myStartDay.setDate(30-(7-i+j)); myStartMonth.setMonth=currentMonth-1; myStartDate.setHours(06);} else { myStartDate=cu