IoT & Connectivity

I am trying to call the sql query service in a javascript service. While printing the length of the data returned from the sql query, it is giving null.While executing the local service, it is throwing error: Error executing service. Message ::Unable To Convert From org.mozilla.javascript.UniqueTag to INFOTABLE - See Script Error Log for more details. Can anyone please tell me where am I going wrong. try {  let sqlData = me.getAllProductsDetails_DB;  logger.info("mySQL_DB_TH   getAllProductsDetails  sqldata" + sqlData.length); // Output is null  // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(AllProducts_DS)  let data = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({    infoTableName: "InfoTable",    dataShapeName: "AllProducts_DS",  });  for (var i = 0; i < sqlData.length; i++) {    var row = sqlData.getRow(i);    // AllPro

Hi community team, How do we differentiate TWX Pie Chart color for the dynamic fields?Thingworx Pie Chart is showing the same color for all the fields. I want different colors to be shown among different dynamic data. ThingWorx Version 9.3.2@PEHOWE @PaiChung @slangley 

Hello everyone,I working through my training manual ThingWorx Fundamental overview, using software version 9.3.2Ref Page 59: Created new user XXXX password **** OK.Now I want to add this user to administrators group, as per document search for administrators User Group: Administrators  Did not find any way to add newly created user to this user group.Also tried Browse user Groups cannot see any group listed here strange? Might be something simple I am missing. 

Hi,There are subscriptions on EventAnyDataChange, but when ever there is any change in the Property the subscription are not getting invoked. There is no issue in logging the data in to the DB, that's working fine, but the subscriptions are not invoking.Restarted the VM and also the TomCat.@slangley , @PaiChung Thanks,Shashi.

Hi community team,   I want to know how many entries of state-style definitions we can make in a State Definition. ThingWorx Version 9.3.2  @PEHOWE @PaiChung @slangley 

Hi,I have created Thingshape and added Infotable type property, assigned Datashape to Infotable property.How to set default values to  Infotable properties to Thingshape through programmatically? Thank you in Advance.Latha

Hi All,I need to send an email based on certain values by inserting html tags within the body. The tag code is ready but I am facing challenge in sending dynamic values within the tag. The values are different strings generated at runtime. Can anyone help me.

Hello I am from Rockwell Automation, which is partner of PTC. I am trying to use the Thingworx partner license to handle over some customer facing events. I Want to make sure I follow all license compliance, but I couldn't find any agreement or items of conditions in terms of partner license. Could PTC give me some feedback? Thanks.

How to see Java Codes which is imported to thingworx as services ?

I already implemented the below css for the dropdown widget. It was working fine. After I updated the chrome version, It is not working now. ptcs-dropdown::part(icon){color: blue !important;} Can someone please help to resolve this issue? RegardsSugumar 

Hello, I tested with the H2 database, others might be affected. I tested 9.3.1 and 9.3.3 with the same result.When setting KEYSTORE:  from 'true' to 'false' in the docker-compose files, the database password isn't changed in the final platform-settings.json. The TWX_DATABASE_PASSWORD from the CUSTOM_SECRET_LIST: 'encrypt.db.password:TWX_DATABASE_PASSWORD' is never replaced, regardless of which password is put to replace it. I checked a bit further and found in platform-settings-overrides.json.j2:"password": "encrypt.db.password","username": "{{ env_var("TWX_DATABASE_USERNAME", "") }}" So the username is replaced but the password is set as plaintext. I believe this is intentional, to have it be replaced by finding the "encrypt.db.password" string at another point.But it never is. Building with the keystore activated is working fine and causes no problems. Am I overlooking something or is this currently not working or supported? Thanks. R

We have to apply query on LastConnection Datetime Property via postman. Please share the snippet. Thanks in advance.

I am creating a java extension to handle multi-thread issues. i need a synchronized subscription that calls a service from a generic thing. This thing is created dynamically so I have to call it in a generic fashion (like Things[ThingName].service() in js). Is there a way to accomplish something similar? Or do I have to look for alternative aproaches? For context he service is in a timer that and I don't want to fire the subscription if it's the first time it fires. The issue is that is  a time off timer and I need to reset every time a counter form an OPC server increases, which is about every second or so.  Thanks

Hi, I have a DataTable in Thingworx storing data from csv spreadsheet. I need to perform advanced queries with aggregate functions grouped by multiple columns.Conceptually, my case is similar to this:https://stackoverflow.com/questions/24657624/aggregate-function-in-group-by-multiple-columns In particular, the datashape of the DataTable is: let newEntry = {   Employee: undefined, // STRING [Primary Key]   LaborTime: undefined, // NUMBER   Project: undefined, // STRING [Primary Key]   Month: undefined // STRING [Primary Key]}; I need to compute the sum of LaborTime of all Employees for each Month, grouped by Project.What is the code to perform such query?The result should then be plotted in BarChart/LineChart widget. Best,Pietro

I am implementing some TOFF logic in my application.I have a  Thing with a subscription listening to some state tags in an opc server. I have to calculate the final state based on this. Sometimes two states change simultaneously firing the event twice at the same time which i do not want because it executes the change state logic twice  in parallel in different processors obtaining the same result twice and firing the subscripiton listening if the state has changed to fire twice simultaneously despite in practice having only one change.Is it possible to force  the subscription to only execute in a single processor so that the second firing is after the first instead of simlutaneous?

SnowFlake database is connected to my thingworx. DB have almost past 5 years data. So while fetching old datas, it takes 2 minutes to show output. How to fetch the old data quickly from DB. 

Hello, I am having trouble with thingworx analytics where my property transform thing does not connect. All the windows services are running, and I can see analytics builder / manager in the composer along with creating models/ etc. I keep seeing the attached windows events occurring, which are filling up my temp folder when the twpas-property-transform-service is enabled.  When I disable the above service, the events stop. Following the procedure below, I updated the owner with admin rights for both analytic server / platform analytics with no effect.  https://support.ptc.com/help/thingworx_hc/thingworx_analytics_8/#page/analytics/change_user_windows.htmlRunning on Thingworx V9.3 and analytics V9.3. Thank you.

Hello, i want to build a simple calculator. For this I would want to create 10 buttons for each digit and 6 buttons for plus, minus, multiply, divide, delete, equal. Then a computation services that takes the label of the buttons pressed as input. But here I am already stuck. I haven't found a way to pass a value for a button to a service. Logic; if button "4" was clicked, input parameter "digit" should be "4". I have already tried setting a contextID and working with event routers but the problem is that the context ID should only be passed  when the button is clicked, but it will always pass.   I would appreciate any help! Thank you.

Hi,  I would like to know if the API works the same as SDK, or the SDK have more capabilities like the "AlwaysOn" agent? 

I have a service where I retrieve one to many email addresses from my data table based on certain inputs. How do insert these into the send message service? It currently gives me the following error,   "javascript service. Message ::Invalid or malformed email address entered."        

We're looking for someone to give us a lecture on THINGWORX. We want to communicate during the THINGWORX lecture. The lecture will be held for a day and the lecture fee will be paid after consultation. Our company is in the Republic of Korea and if you want, you can give lectures online. We hope you can communicate.

Hi There,Want to provide the postgreSQL database command in input and show the output , which category widget, should I using Thingworx Mashup?Thanks in advance

I am able to execute GetConfigurationTable service Where as SetConfigurationTable service when called inside service written by me is not setting all the Configuration values for Database/Mailserver Thing entity.Please verify from your end if there is any problem.

Hi @kho1 , Did your issue get resolved? I am also facing the same issue. Production events are not getting captured and no KPI calculations are happening.

I need to write some CSS for this section: :host(#cell_FLS_Asset_Details-48_ptcsgrid-11:not([no-wc-style])){ } I need to know how to write css for this host?