IoT & Connectivity

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? 

Hi,I have a Link widget that always fails the second time it is clicked. It is meant to download a file, which it does the first time, but then sends the user to a default "Could not provide media" page the second time. I've fixed the issue via an auto-refresh pointed at the service that provides the URL for the Link widget, but that only works if the user waits to click again. Is there a way to cause the link to be disabled after it is clicked once? I was hoping Thingworx allowed services to reference widgets, but sadly this feature does not exist from what I've read. Any help would be greatly appreciated.

When ever I try to delete an Entity in TWX, it shows an error message: but if I delete from VM(where TWX is installed), can delete successfully.Thingworx version: 9.3@slangley @PaiChung Thanks,Shashi.  

Hi,We have created a new customized tile and a new user group on Manufacturing Apps, and now all roles see Composer tile on console.Maintenance Engineer user: New group user: PTC.Factory.MachineVisibility organization doesn't have Composer sub-unit, so we don`t know why can see it and how to hide the tile for those groups. Does anyone know how to solve it?Thanks in advance.  

Creating API Map for WRS endpoints is painfully slow as Firefox takes all available memory. Only after API tree is fully collapsed it becomes somewhat navigatable. Is this a bug or 'normal' behavior? Is there any other way of defining API Maps e.g. in XML and through importing? ThingWorx 9.1.0

Hello everyone I have a stream that has a property infotable.I want to write a service inside of that stream, I want this service to get each row ID inside of my infotable and store these IDs within an array. I have tried using the queryinfotableproperty history service.This does not seem to work. Kindly suggest how I can go about fixing this? Thank you so much.

User Load Testing in ThingWorxJava Client TutorialWritten by Tori Firewind, IoT EDC IntroductionAs stated in previous posts, user load testing is a critical component of ensuring a ThingWorx solution is Enterprise-ready. Even a sturdy new feature that seems to function well in development can run into issues once larger loads are thrown into the mix. That's why no piece of code should be considered production-ready until it has undergone not just unit and integration testing (detailed in our Comprehensive DevOps Guide), but also load testing that ensures a positive user experience and an adequately sized server to facilitate the user load.  The EDC has spent quite a few posts detailing the process of setting up an accurate, real-world testing suite using JMeter for ThingWorx. In this piece, we detail an alternative approach that makes use of the Java Spring Boot Framework to call rest requests against the ThingWorx server and simulate the user load. This Java Client tuto

I am trying to match the colors in the label chart widget by changing the segment colors in the d3 pie chart widget.   The d3 pie chart can be downloaded from the following link: https://community.ptc.com/t5/ThingWorx-Developers/label-above-pie-chart/m-p/540169   To change the segment colors, I followed the instructions provided by d3pie in the following link: http://d3pie.org/website/examples/colors.html   I changed lines 127 to 132 in d3pie.min.js: Before: misc: { colors: { background: null, segments: ["#0086ff", "#1bff31", "#de0e0e", "#ffa100", "#8dc3fa", "#6b6b6b", "#cbcbcb", "#ebebeb", "#ff13f2", "#a08965", "#7c0071", "#7cd685", "#ede2be", "#32ffff", "#ffee33", "#ffcdf3", "#bc0000", "#c58937", "#e1d04d", "#a6cd44", "#43a4c9", "#da5f5f", "#a4cba5", "#4f3ebe", "#2484c1", "#65a620", "#7b6888", "#a05d56", "#961a1a", "#d8d23a", "#e98125", "#d0743c", "#635222", "#6ada6a", "#0c6197", "#7d9058", "#207f33", "#44b9b0", "#bca44a", "#e4a14b", "#a3acb2", "#8cc3e9", "#69a6f9