ThingWorx

Hi all, I am experiencing some weird behavior with querying property history from the influx DB in thingworx. I am querying several properties at the same time within a time range, some of these are numeric and some are boolean. For the numeric ones I am getting good correct data, but for some of the boolean values the query shows no history and has it as blank. However, the booleans when queried individually show property history and have been flipping between true and false consistently.  I am not sure why this is occurring exactly since the properties have good history but it doesn't show when querying several properties. (I am doing one bigger query because I have a lot of properties that need to be queried in my service). Any feedback is appreciated!

Hello I would like to increase the time of status message that comes on thingworx. Currently it stays for little time and i want to increase that . Is there a way to do it? Thingworx version is 9.4 Thanks

Dear Community,    An urgent query .I am having a very strange issue. I have one user and its also in the visibility organization and in the user group which has right to propertyRead and Service inoke but still i am unable to get the fileRepository  in the mashup widget and not able to upload the picture. As you guys can see in the picture below:-   The access report on the repository is as below:- which show clearly that user can access it     as you guys can see below when i login with admin user on platform then it shows me repository in the widget ..and when i logged in with the above user then this widget does not show me repository and i am also unable to upload the picture.     In mashup widget     IMPORTANT (SERVER where this user is WORKING) there is only different in services GetNamedProperties service is there also...    

Hello , I am looking for the location where i can locate the license trust of thingworx .I am able to delete the folder ptc_p but as i can remember there were other files that need to be removed. Any help would be appreciated Thanks

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?