ThingWorx

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.  

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.

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

Hi, I want to add Legend in D3 Pie chart, how do I add legend?

Hello, I am trying to setup Thingworx HA cluster on Kubernetes. Thingworx foundation containers are up and thingworx composer is accessible. I am unable to bring cxserver up, error is in zookeeper client connect(detailed message below).   Can you please support me with some troubleshooting steps to verify zookeeper? Also any pointers on CXServer troubleshooting  ?  Error MessageError :{"@timestamp":"2022-06-24T04:54:39.915+00:00","@version":1,"message":"Background exception was not retry-able or retry gave up","logger_name":"org.apache.curator.framework.imps.CuratorFrameworkImpl","thread_name":"main-EventThread","level":"ERROR","level_value":40000,"stack_trace":"java.lang.NullPointerException: null\n\tat org.apache.curator.framework.imps.EnsembleTracker.configToConnectionString(EnsembleTracker.java:185)\n\tat org.apache.curator.framework.imps.EnsembleTracker.processConfigData(EnsembleTracker.java:206)\n\tat org.apache.curator.framework.imps.EnsembleTr

We are using Thingworx Platform 8.5.5 and PostgreSQL 10.8 in AWS. PostgreSQL 10 has become obsolete now and AWS will upgrade the database to v11 soon. The system requirements guide shows that TWX 8.5 only supports 10.8. Is there a plan to support more postgres versions? Regards,Sri

Can someone explain when an extension may not be compatible in an active-active cluster?  I see the haCompatible attribute documented in the Help Center but there is no guidance as to when that should be set to true or false. I have a legacy extension from the defunct Market Place and several home-grown custom extensions and need to determine if they are compatible in high availability mode but I don't know how to make that determination.  Would an example of one that wouldn't be compatible do something like keeping a local state or cache of data and that information would be lost if a different node handles the request? I want to just add haCompatible="true" and repackage the extension but I don't know if that is advisable or not.

Hello, I would like to add effective token onto a ressources.So I could find them back later by using GetEffectiveToken()Is It possible? Cordially.

I have 2 infotables with same datashape. I need to compare them and store the difference in third infotable.For example,DifferenceTable.Reading = CurrentTable.Reading - PreviousTable.Readingwhere Reading is a property name for all 3 tables.Kindly provide solution for same. Regards,Siddharth