ThingWorx

Hi, I’ve developed a project in ThingWorx (V9.6) using PostgreSQL as the persistence provider. We are now planning to migrate this project to a new ThingWorx(V9.7.1) environment that uses Microsoft SQL Server (MSSQL) as its persistence provider. I would like to know whether such a migration is feasible, and if so, what potential conflicts or challenges we might face during the process. Specifically, I’m looking for guidance on: Compatibility issues between PostgreSQL and MSSQL Areas that require special attention to ensure a smooth migration Best practices to avoid common pitfalls Your insights and recommendations would be extremely helpful to ensure a hassle-free transition. Thank you in advance for your support!

Hello everyone,I'm encountering an issue where a boolean property in a Thing is not updating as expected, even though it updates correctly in the associated service. I am using Thingworx 9.4.6 and KEPServerEX 6.15 version.Setup:I have a ThingShape that defines three properties:currentEnergy (Number)energyThreshold (Number)overThreshold(Boolean)The currentEnergy property is mapped to a Kepware tag value using simulation. I can see that currentEnergy updates correctly in the Thing.A service is written in the ThingTemplate. In this service, the logic compares currentEnergy with energyThreshold . If currentEnergy > energyThreshold , the overThreshold property is set to true.Issue:When I click the refresh button in the Thing, the currentEnergy value updates as expected. However, the overThreshold boolean does not update accordingly based on the service logic. Can someone help me identify why the overThreshold value isn’t updating? I’ve attached relevant references (PF

Hi,We Thingworx v9.7 in a SaaS environment, and we have a few hundredth things based on different templates, most of these template based on the RemoteThing Base template.I'm working on a specific Thing Shape that will be implemented in a bunch of those things or on the templates. I would like to launch a initialization service from a subscription when the isConnected property from the RemoteThing changes state. The issue is that from the Thing Shape, I can't set the event trigger for the subscription on DataChange for isConnected. Is there a work around possible, or maybe another way to call a service on the thing Shape level, when the connection is restored for the Things where the Thing Shape is used?I guess there is a way to duplicate the RemoteThing base template and add the subscription there, but that would also mean recreating all templates, so I'd like to avoid that solution. Many thanks in advance,H.

Hello all,I am using the Collection widget in ThingWorx 9.3.3 to display a group of two mashups with different colors to simulate a percentage bar. I have nine simulated percentage bars like this, each separated by different containers in the main mashup.On the main mashup, I am executing a service every 30 seconds using Auto Refresh. The data from this service should set the width of the mashups using the "CellWidthField" property in the Collection. I know that the Auto Refresh is working because I can see the percentage values updating every 30 seconds. However, the width of the mashups does not change accordingly, it only updates when I manually refresh the page. As you can see in the first image, the second percentage bar (which is 100% and red) should fill the entire row like the first one.The second image shows the correct behavior, but only after a manual page refresh. The width of the mashups in the Collection appears as expected after the page is reloaded. My questio

Hi everyone,We're currently facing a performance challenge in our ThingWorx implementation related to saving a large volume of image files (potentially millions over time).We’ve observed that writing files directly to a file share (network storage) from ThingWorx is quite slow, whereas saving them to the local repository (on the same server where the ThingWorx ApplicationServer/Experience Service runs) is significantly faster.To address this, our development team has proposed the following approach:Save incoming files temporarily to the local ThingWorx repository (for fast write operations).Then, in the background, run a scheduled service (e.g., every 15 or 30 minutes) that:Moves these files to the file share for long-term storage.Deletes them from the local repository after successful transfer.We’d like to ask the community:Is this a recommended or sustainable strategy for handling large-scale file storage in ThingWorx?Are there risks or performance concerns (e.g., file locking, memor

Hello, I have a flow that fetches documents form Windchill with Windchill actions. It works but I would like to fetch the whole history of that document. How can I achieve this?Thanks in advance

Anyone know of a way to change the style of a reference line on a line chart widget? Saw a few posts from years ago that didn't have a specific way to do it and was wondering if anyone has a work around

I am using ThingWorx Platform Release 8.0 and DatecodeF000license过期了，系统无法启动，需要获取新的license文件。系统启动不了，无法获取device ID，这种情况下怎么获取新的license文件。

I am using ThingWorx Platform Release 9.6I have a service in my Historian DB Thing to get the Historian data for a PiPoint for a day period from the historian database, when I manually run this service, it always return correct data. this service contains following code: select tag, FORMAT([time],'dd-MMM-yyyy hh:mm:ss.fff tt') time, value, status from piarchive..piinterp2 where tag=[[PIPoint]] AND time >= [[st]] AND time < [[st]] + '+1d' AND time < '*' AND timestep = [[step]] Then I have another service which loop through all PiPoint and load the data for each one and save the data into a SqlServcer database. This service runs every two hours on a schedule and calls the service above to retrieve PiPoint data. The isssue is when the above serivce is called in this service, it works one or two times in a day, while other times it returns 0 rows which I confirmed using logging (there is data in the historian db). The code was never changed since it was implemented last year and i

Dear Community! I'd like to ask your advise/help regarding the new feature in Thingworx 9.7 for GRID's Dropdown list.We have been waiting so long to have OOO the functionality to have a dropdown list in Grids, however we are struggling to get the most out of it. The configuration both with Service/Config is working. (Configuring Grid Columns to Display Dropdown Lists (ptc.com)) We have a UseCase, where the users need to select a given value from the grid dropdown list, however the List as normally, displays the value selected, and it is passing further to any data we bind to. The problem we are facing, that we would need many columns as dropdown, but with different Display Value, and different actual Value .(Just like a normal ptc-dropdown. Once you bind an infotable to the data property, you can choose the Display Field and Value Field)for example: Service returns infotable of RoomInformation : (RoomId, RoomName, RoomDescription)the RoomId as a primary key (us

I would like to filter the InfoTable returned by a SQL query using a ChipBasedFilter widget and return it directly to an Advanced Grid.Is there a way to achieve this without creating an intermediate service? I have several mashups with very different requirements and would rather not write a separate service for each one. Thingworx V9.2

I can pasted a call in a browser based on the documentation -https://pdm-XXXX.com/Windchill/servlet/odata/Workflow/GetWorkItemReassignUserList(WorkItems=@wi)?@wi=[OR:wt.workflow.work.WorkItem:243012721]abd  see alist of users for Reassign. This is based on the documention.  Documentation shows - GET /Windchill/servlet/odata/Workflow/GetWorkItemReassignUserList(WorkItems=@wi)?@wi=["OR:wt.workflow.work.WorkItem:232279","OR:wt.workflow.work.WorkItem:232290","OR:wt.workflow.work.WorkItem:232297"] HTTP/1.1 Using an Odata Connector I have the endpoint below that will only returns Resource errors or missing alias (v3)ThingWorx endpoint -GetWorkItemReassignUserList(/v4/Workflow/GetWorkItemReassignUserList(WorkflowItems=@WorkItems) GET) How do you add an alias to the call 

ThingWorx 9.7.1-b346 I have a mashup which is to contain multiple collections that will contain multiple cells each. The number of cells will depend on the user selected input parameters at run time; anywhere from 3 cells up to 12 is the most (I believe). Each of the collection widgets are using the same child mashup and will use the same configuration however will use data from different sources.My collections will be in a table format with each cell forming a row the full width of the container. My child mashup and the collection settings are such that each cell needs to be 100px tall, any shorter causes visibility issues for parts of the cell/child mashup.I need all collection cell rows to be visible at once, not hidden outside of the limits of a container requiring the user to scroll down in the collection container. With multiple collection cells having independent scrolls this can become a significant issue. I have not been able to have all cells visible without scrolling th

I want to freeze a column in ptc-grid widget. I am using 9.3.1 version

I am happy to release PDF Generator Extension version 2.0.0,    This is not a 1:1 replacement for the old PDF Extension, but intended more as an alternative way to generate PDF files. The usage is very simple: drop the widget in a Mashup, trigger the GeneratePDF service and you should be good to go.   Note that browsers behave different when encountering PDF files: some might open the file directly in the browser tab (Firefox) while others might trigger the download prompt. Expect that in many cases the resulting PDF will be opened in (another) browser tab.   Disclaimer: This Extension is provided as-is and without warranty or support. It is not part of the PTC product suite. As such, please do not raise any PTC Technical Support cases related to it. Instead, please open issues as instructed here. This project is licensed under the terms of the MIT license.   This extension is Open-Source: it is expected that users fix bugs or implement new functionality b

Good day everyone,   I am happy to announce the release of the ThingWorx GitBackup Extension version 5.1.0. Please (as always) read the disclaimer: this Extension is provided as-is and without warranty or support. It is not part of the PTC product suite. This project is licensed under the terms of the MIT license. Do not open PTC Technical Support tickets, instead read the instructions here.   This release is available for download here.   Changelog: Fixed bugs: fixed inability to export ModelTags fixed multiple issues that resulted in the inability to remove the Git pack objects in the FileRepository Various improvements added a basic set of integration tests in the GitBackup.Tests.Thing. These significantly help the speed of bug fixing and quality of software. switched to use the source-code for the latest version 6.10.1.202505221210-r of JGIT compatible with Java 11, instead of the JAR library; this was done because multiple issues required fixes to be done in

Would you please give me any update about this issue. I am having a same issue at the moment and my thingworx version is also 9.3.   Important info: When i connect mouse with ipad with cable and click browse button it works. When i touch i click on browse with my finger. It does not work. If you need any further information for debugging purposes just let me know about it. Thank you!

Hi,I use Thingworx version 9.6.2. It seems that the Resources["SecurityServices"].DeleteRunTimePermission first parameter type needs to be "Thing" for example if one is to remove permissions from that thing.This is the code for a service to remove all permissions that i have to far, however the error message i get is following:  Error executing service RemoveAllPermissions. Message :: Invalid Permission Type : [Thing] - See Script Error Log for more details.The point of the service is to remove all existing permissions added to a thing from a user or group, NOT changing the permissions level like read/write/subscribe etc.Code:var projectName = me.ProjectName;var projectEntities = Projects[projectName].GetEntities();logger.info("all entities in project: " + projectEntities.rows);var result = [];var things = [];var userOrUserGroups = [];// sorting things and nonthings in two seperate listsfor (var i = 0; i < projectEntities.rows.length; i++) {var entity = projectEntities.row

Hi Community,Need your help. We are doing a automation test module for Thingworx mashups. Facing a challenge in reading dropdowns using selenium webdriver for chrome using python. Strange part is in the page two dropdowns- Device and Region are getting clicked in auto test suite, but when selecting country dropdown(which is based on Region) it is failing. How can we select elements, which approach is better and how to achieve that. I tried by selecting the div id of the dropdown but then it selects the first value as text value- For example Select Country or Select Region. But even it that case the automated click does not happen. Anyone having similar experience please share your thoughts.

I am working on developing a custom widget for ThingWorx using **Angular 17**. I have created an Angular Element and successfully generated the build output (main.js, runtime.js, polyfills.js, etc.).Now I want to package this as a proper ThingWorx widget (extension) using the Web Component SDK.However, I don’t have the **ThingWorx Web Component SDK** that includes the necessary CLI utility and scripts like:- `devops/wcp_components.js`- `cli.js` for packaging the widgetBecause of this, I'm unable to generate the required `metadata.xml`, widget JSON, and other files needed for import into ThingWorx Composer.### My Request:- Can someone please share the **official way to download the ThingWorx Web Component SDK** for Angular?- Or provide a working copy (ZIP or repo)?- Any documentation link or setup guide would be helpful too.I’m not using Lit or other frameworks — this is strictly for Angular-based widgets.

Hello Folks,   do we have any solution for this same issue?

Hi everyone,I'm working on a project in ThingWorx where users (e.g., customers) should only be able to see and interact with their own data. Here's the scenario:🔧 Past Setup:I have a configuration table that includes a field subUnitMapping, which links customers to their specific datasets.When a new customer accesses the application for the first time via mobile, a dataset is dynamically created and the appropriate subUnitMapping is assigned to both the dataset and its Thing for permission control.In the mashup, users select their line from a dropdown, press a button, and are navigated to their respective mashup/data.🧩 Current Setup Challenge (new project):        I have datasets for different customer and customers land to dropdown page where they choose their name from dropdown and then enter to navigate to their own mashup. I mean i can make this with textfield that they have to write something in it and enter to come to mashup with their own dataset....In the

Is it possible to implement colour picker in Thingworx where I can choose the RGB and get just the integer values of the 3 colors ? I know for sure it is possible with a custom extension ... is there a smart way to do with current features of thingworx ?I'm using TWX 9.6 PTC cloud hosted instantes

I want to create a WTDocument in Windchill which may also contain primary content from ThingWorx (by creating a form in Mashup). I'm new to Thingworx and want to know the steps to do so.

I am using ThingWorx Platform Release 9.2 and DatecodeSP6On reducing the font size it is ended up by having a scroll, instead of the font size getting reduced