ThingWorx

Hello community,I have very strange issue when i import the project on for eg another server the users which are already there and get also imported on this project do not able to login with their passwords. Then i set the passwords again and everything works then for eg again after some time when i do import project with users the users passwords got disable and again i have to do this process.I think i should not import users which are already present on the server..  

Hello All,    This is my datagrid widget on the mashup and i do sorting by clicking this arrow on the Date of the Report parameter because i want it to show from latest till end but bydefault is shows me oldest till new. is there any way that i can set it from latest to old so that whenever i come to mashup it show me like that.thanks!   

Thingworx Version: 9.5.2I'm going to try to be as precise as possible here, so bear with me. In a Mashup that is exclusively used as a popup window showing our page's software history & changelog on two separate tabs respectively, we've encountered an issue where the data of the changelog isn't loading unless you specifically open the Mashup on the tab the text is supposed to be loaded in - meaning if you load the Mashup on the first tab, then switch to the tab with the changelog, it isn't visible. The data is still there (you can see Mashups created within the collection in the debug view), but it just doesn't show - resizing the browser window also makes it show, but that's unfeasible for practical use. The Changelog itself is made of two parts, a list and a container with that shows the changelog itself, which is just a collection with mashups that only contain formatted labels. (I've found no better way to do changelogs since we still have no replacement for the HTML

Hi folks, I am not able to to execute a simple select query where the service type is "Query". Even with Insert query as command it is not working out as well. The database is PostgresSQL and the DB thing is connected as well. But on execute of the select query it is giving,  error as: "Unable to Invoke Service test on PostgresDB_Thing : Execute Query failed. Please check Database logs for more details." It seems there is some permission required on the database, I have checked the owner group in postgres SQL table, where "txadmin" user is selected. Still not able to figure out where am I going wrong to provide permission. Please provide some suggestions here. I have attached the database log error below:

Hello,I want to export data into csv file as similar to data export widget, but it should take more than 1 infotable input and should give output as the csv filewith more than 1 sheets containing the data from those infotables.I there any similar custom widget available to such requirement. Please suggest.Thanks!

Hello all,     I have changed my thingworx version and import the project from Thingworx 9.1 to 9.3 but my widget datepicker here not giving me time. It only sends the date to qualitytimestamp datatype input service parameter. I have no idea why the same thing was giving me datetime on old version of thingworx and not anymore here. can anyone please let me know about it. Please have a look on the properties of the widget where the time can be show in qualitytimestamp as below: Screenshot 1  Screenshot 2  screenshot 3 

Hi,I have used the Print Extension widget to take to print of mashup from runtime.I want to give custom background color to my print page.Any suggestion, how can i achieve that? Thanks in advance!

Hello I am using thingworx 9.4.4 and suddenly my mashups has been stuck and they keep on loading without showing anything. Any help will be appreciated. Thanks

Hello My thingworx installer is failing at the last step while waiting to connect thingworx and whenever it fails the folder structure is rolled back. I am trying to locate the errors but as soon as installer stop it delete all the folders .Is there any specific location i can look for installer logs? Thanks

Hi, Suggest something that we can contribute/do with Thingworx analytics to the design/engineering teams. Thanks,Keerthivarman.

Hi,I have two date values in String format like "2024-07-25 19:41:27.0000000 +00:00"I want to calculate the time difference in between so I want to change them to date format. so used the code below but it gives me the invalid format error. Parsing neglects the year: let StartDate = "2024-07-25 19:41:27.0000000 +00:00"let sdf = "yyyyMMddHHmmsszzz";result = parseDate(StartDate,sdf); Invalid format: "2024-07-25 19:41:27.0000000 +00:00" is malformed at "-07-25 19:41:27.0000000 +00:00" I even tried the slice the string, but I got the same error: let StartDate = "2024-07-25 19:41:27.0000000 +00:00"let ShortStartDate = StartDate.slice(0,19)let sdf = "yyyyMMddHHmmsszzz";result = parseDate(ShortStartDate,sdf); Invalid format: "2024-07-25 19:41:27" is malformed at "-07-25 19:41:27"

Hi, I have a service output of base type infotable. The datashape attached only has 1 column called timestamp. I add all my other columns dynamically in my service. In the result, the timestamp column appears last. Instead I want this column to be the first in the grid. How do I force this column to appear first? Many Thanks.

Hello All, I am working on DPM and have uploaded the default excel file which we get from github name is DPM sample 1.2.14. In Performance Anaysis page >> waterfall model >> timeloss trend i not loading PFA 

We are fetching almost 2k-3k rows data from datatable to populate in grid. It takes around 1 minute to populate data in tree grid. We also using data filter to filter data from datatable, it takes another 1 minute to filter data from datatable and to populate in grid. How to reduce the time when multiple users fetching data at same time in production environment.

Hi all, I have a case where I want to query a lot of different property histories, do some calculations from the history, and create a report from it. For my specific case, it simplifies the process of creating a clean report if I just loop through the list of properties and query each one individually (typically like 30 or less properties total so nothing crazy). I am curious about whether doing this and calling several queries will cause any performance issues or database access problems. I tried doing it all in one query, but it is much simpler to get the data specific to each property and then perform my calculations in individual queries. The speed of my service is fine, so really just wondering if there are possible issues I haven't considered with this approach or if this is okay practice. Thanks!

Hi all,My mashup is completed and working, that is until I tried adding a new function.Currently I have a service that provide data to the bar chart and have my seriesclicked and selecteddata binded to another barchart which works, it takes in the x and dataField of the first barchart. The problem occurs when I try reading the x and dataField of the chart in the same service that provide the data to the chart.Now my Mashup have loading error only on the chart, and only when I try to read the x or dataField of the input infotable. Any advice is greatly appreciated!

Hi Community,   I'm trying to run integration runtime with logback.xml. When I run below command in CMD     java -DconfigFile="integrationRuntime-settings.json" -Dlogs.includedLogback="logback.xml" -jar .\integration-runtime-8.0.14-b100.jar     Throws an error   logback.xml file content   <?xml version="1.0"?> <included> <property name="logs.dir" value="C:\\ThingworxStorage\\IRlogs" /> <property name="logs.uniqueId" value="${processId}" /> <property name="logs.maxFileSize" value="1MB" /> <property name="logs.maxIndex" value="5" /> <logger name="com.twx.integration" level="DEBUG" /> <logger name="org.apache.camel" level="DEBUG" /> <logger name="org.apache.http" level="DEBUG" /> </included>     Also, I'm looking for a way to set IR log level to DEBUG mode   Could anyone please help me on this    /VR

Our Research & Innovation team at PTC is conducting a study on productivity and quality analysis using insights from work instruction execution in the manufacturing industry. We have a new solution design to help our customers optimize their work instructions and are seeking experienced professionals like you for a 30-minute interview to provide feedback on our new solution design. We're looking for production supervisors, continuous improvement team members, or manufacturing engineers experienced with work instructions or operations optimization. Your insights will help us refine our design to better meet industry needs. If interested, click the link below to provide your contact information and availability: >> Click here to register << Feel free to share this invitation with colleagues who may be interested. We appreciate your contribution to our research and look forward to hearing from you! Best regards,Tadeusz WitczakResearch & Innovat

Hello, I am using ThingWorx 9.3.9.I was wondering if there was a method to get data from a infotable, and separate each of the columns in an property. In my case, I have three columns, id, temperature, and force, and I want to separate these into three different properties in a Thing. I have written a service in a Thing that has 4 properties, 3 of which are numbers and the last one being an infotable. This is my service code that I tried to use to pull one row of information from the infotable:   let infoTable = me.MyCSVProperty; let searchCriteria = { "id" : 2 }; let foundRow = infoTable.Find(searchCriteria); if (foundRow!== null) { let id = foundRow.getValue(0); if (id!== null && id!== undefined) { me.id = id; } else { me.id = -1; // Set to -1 to indicate an error } } else { me.id = 4; }   and when i run this program i get an error: Any help would be greatly appreciated!Additionally, I am new to coding and thingworx so detailed explanation

Hey Community, here i want data from three different datatables and i want to have all the entries in one infotable. How can i achieve it? i think i need to have here infotable and collect all the data there... let data; linesArray.forEach(line => { logger.info("QControl."+line.lineName+"-"+line.lineLocation+".DT"); let thingName = "QControl."+line.lineName+"-"+line.lineLocation+".DT"; let maxItems = Things[thingName].GetDataTableEntryCount(); data = Things[thingName].GetDataTableEntries({ maxItems: maxItems /* NUMBER */ }); });  

For one of the customers, we are working on application development where Snowflake DB data (Power bi View tables) need to be inserted in postgres through ThingWorx schedular but while doing so ThingWorx Apache Tomcat went down.  We are handling here around 22 lac rows to insert it in database. While doing so we are experiencing this. Please help us to improve this. Is there other way to insert this many rows from snowflake DB to postgres without affecting ThingWorx performance?

How to start userextension properties in alphabetical order

Good day, everyone I am trying to print my webpage/mashup, (an image just for now).Following this article guide: https://www.ptc.com/en/support/article/CS319138I wrote the below in a service and I invoke this service on a button click with the hopes of getting the print page to open up (Like how it would when you press Ctrl+P).This isn't working. Is there something I am missing? The code: let table = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "dataShape_DS"});let html = "window.open('http://xx.xx.co/:port/Thingworx/MediaEntities/Icon'); html.print()";table.AddRow({htmlColumn:html});result = table.htmlColumn;

Hello,   What is the difference between thingworx and thingworx naviagte. I am working on thingworx but thingworxnavigate is also a platform or how does it works. Would anyone clear my confusion please

In thingworx navigate UI, how to upload the files directly from windchill rather than uploading from local drive.