ThingWorx

Hi,I have a datable containing 100 000 rows.I need to iterate this datatable and do some operation for each row.Obviously I cannot do that on one service (I will have 100% timeout problem) and I cannot increase the timeout value. The solution I am thinking of: 1-Take rows slice by slice. (50 rows every time).2-When the 50 iterations are done , I trigger the next 50 rows (subscription on a property).3-I finish with I reach the count of all rows in the datatable. What do you think about this solution ?Is there a better alternative ?How to get the 50 rows I need to process since I don't have an id that increment automatically (so I cannot see how to manage the query to get the right 50 rows I need to process) Thank you for your help

Hi everybody! I'm trying to do something like this with proportional charts: This is a figma draw, but I'm in trouble to do this in Thingworx.This was how I setted data:I don't know if it is right but I want "eixoX" in Xasis, grouped "value" in Yaxis and "elements" for the legends like in the figma schema.could you help me?? 

Hi Team,   I need help in CSS styling in Menu widget - In my requirement I have list of menu items should be listed from dynamic service, in that "title" should be like below (Font-weight : Semi-Bold; upto dot and Font-weight : normal; after dot) Menu1.Sample Page Menu2.Sample Page Menu3.Sample Page I tried with below CSS it helped with me updating all text as semi bold.     .menuList .widget-menu .menu-item-name span { font-weight: 600 !important; }     TWX : 9.6.2 Thanks & Regards, Arun C

I was following this article - https://community.ptc.com/t5/IoT-Tips/Send-Messages-with-Twilio/ta-p/834729I have checked with the configuration and it is correct During executing Twilio thing to send message I got this error - 

Hello everyone,I am working on a ThingWorx Mashup where I have a flex container that contains a ptcs-dynamicpanel. This panel is divided into two sections:Left Side: Contains more widgets and occupies a significant portion of the screen.Right Side (ptcs-dynamicpanel-41 #2): Contains fewer widgets, but by default, it opens with too much width.Issue:I want to reduce the width of ptcs-dynamicpanel-41 #2 when the mashup opens. However, I do not see any width property available in the widget’s settings. I have tried adjusting the flex container settings, but the right panel still expands too much when the mashup loads in the browser.What I Have Tried:Checking the Properties of ptcs-dynamicpanel-41 #2 – No direct width option found.Expected Behavior:When the mashup opens, the right panel should have a smaller width instead of taking up a large portion of the screen.The layout should remain responsive without affecting the left panel’s visibility.Does anyone have experience with controlling t

Hi @GabrielB  When I log into IQNOX, I encounter the following error. Could you please assist me with this? Thank you in advance!    

PTC plans to end the support for on-premises ThingWorx Flow installations. But this is a requirement for the DPT integration between Codebeamer and Windchill (https://support.ptc.com/help/windchill/r13.0.1.0/en/index.html#page/Windchill_Help_Center/reqmgmt/RMThingworxFlowConfigsAbout.html) What is the future scenario for this integration without ThingWorx Flow in an on-premises environment?

I have simple SQL query: SELECT [column 1], [column 2], [column3] ...   FROM [table] WHERE [column1]= 31. In my case, conditions are chaning, sometimes I have no WHERE part of querry, sometimes I have 1 column, sometimes 3, depending on operators behaviour.So in query, I added variable filter as parameter, and make a querry like: SELECT [column 1], [column 2], [column3] ...   FROM [table] [[filter]] and filter would generated by external service and can be empty if all data needed, but can be also WHERE [column1]=31, or any other combination of WHERE. Unfortunatelly, no matter if I keep filter value empty, or I do put there my WHERE conditions, I receive   "Unable to Invoke Service ... on ... : Execute Query failed. Please check Database logs for more details."Have tried to call this service manually, have tried to call by other service, changed name of variable to be sure it's not forbidden word... no changes.  Have tried with filter as both, String and Text t

Hello ThingWorx Community, I am currently working with a ThingWorx DataTable that contains approximately 150,000 entries. Since handling large datasets in ThingWorx DataTables is not optimal, I have implemented SQL Server as a more efficient storage solution. Now, I need to migrate this large dataset from ThingWorx DataTable to SQL Server, but I am facing challenges in doing so efficiently. Here are the key concerns: Row-by-Row Insert: When I try to insert data row by row, I run into execution time issues.Bulk Insert Using SQL File: I attempted to create a large SQL insert file, but some data entries are missing or cause issues during execution.Performance & Best Practices: What is the most optimal and scalable way to migrate this large dataset to SQL Server?Has anyone successfully handled a similar data migration in ThingWorx? I would appreciate any insights, best practices, or recommendations for moving large datasets from ThingWorx DataTables to SQL Server efficie

var productionData = [];for (var i = 0; i < 10; i++) {productionData.push({"CurrentIteration": i,"Value": i + 1             //Change it as per your requirement. Like infotable columns names etc. });}throw JSON.stringify(productionData);//For Specific columns and values/items in array use this: "productionData[0].Value" 

 

In Filter widget, how to pass OR condition as default ?  

In the attached code line no 282, i used state definition to highlight row based on the value present in highlight field of infotable. But it doesnt made any changes in tree grid. 

hello community,      I have an expression which has value true and when i evaluate to fill the checkbox means to make the checkbox true then it works fine but only for the first time and now when i evaluate this validator again second time.. means it needs to return me true again then it does not return me true. any one has an idea why its like that?so its only working for only once and then not.   

Hi, I am also facing the same issue, Tomcat fails to start, and I see the same error message in the system event logs: The Apache Tomcat 9.0 Tomcat9 service terminated with the following service-specific error: The system cannot open the file. Could anyone who has resolved this issue provide some guidance or share their solution? Thank you!

Hi All, I have a lot off error messages in application_log like Unable to dispatch [ uri = /Things/PersistentSession779c7eb0-1f7c-4508-8791-7bd1585922b4/Services/AddDynamicRemoteSubscription/]: Unable to Invoke Service AddDynamicRemoteSubscription on PersistentSession779c7eb0-1f7c-4508-8791-7bd1585922b4 : Not authorized for ServiceInvoke on AddDynamicRemoteSubscription in PersistentSession779c7eb0-1f7c-4508-8791-7bd1585922b4  

Hi, I have an application starting mashup named org.proj.entity.name.typeI would like to customize this starting page url or redirecting from customized as mentioned belowhttps://<host>/Thingworx/Runtime/index.html?mashup=org.proj.entity.name.type How to customize this to https://<host>/projectHome   thanks,janakiraman P

I want to do something like this -  try{ if(someError)    throw someErrorException() }catch someErrorException{ result.message  = "someError happened" }   Expected output in postman if the someError condition is true - Status Code = 500 & response message = someError happened"   Instead of this, I am able to get it into status code 500 by forcefully writing erroneous code within the if statement but I am not able to set the error message. Its the standard error message which comes - "XYZ check scriptLog"  

Is there a way to create an infotable on a mashup that allows to click on infotables within the infotable like you get on the Thingworx composer?  When I send my data to the grid widget, I get an infotable icon that's not clickable.  I would assume this is a pretty simple thing since it's used in Composer, but I can't figure it out.  Any help would be appreciated.    

ThingWorx Version 9.4.0 Every Time I try to save an entity I have to re enter my credentials. The thing also give an error that it is not running no matter what service I try to run. Entity in question is made from the Thingworx Mail extension v. 4.1.1 Thing Template, Configured only no modification from original state. This identical configuration is working on other servers without issue. I have removed the extension and restarted the Apache service, then reinstalled and recreated the thing problem persists. Does anyone know what could cause either of these issues?

Hello Community, I am facing an issue when saving images from Vuforia Studio to ThingWorx File Repository, and I would appreciate any insights on this. Issue:I am sending four images, each approximately 3 MB in size, from Vuforia Studio to ThingWorx for storage in the repository. This means the total data size is around 12–13 MB. While I am using the ServiceInvokeComplete event in ThingWorx to ensure the images are saved properly, in this service i have am calling another service which has a code to save photos. I sometimes notice that the images do not get saved at all. Possible Causes?Could the issue be related to the file size (since 12–13 MB is being transferred at once)?Are there any ThingWorx limitations on file upload size or service execution time that might be causing this?Any other potential reasons why the images might not be saving consistently?I would appreciate any suggestions or guidance on how to troubleshoot or optimize this process. Thanks in advan

Hello ThingWorx Community,I am working on integrating ThingWorx with Vuforia Studio for multiple AR experiences, each containing a series of steps with associated information. Currently, I store step details (name, description, and image) in a static JSON array inside the experience, like this:  let Companyarray = [ { "name": "check 1", "description": "main label and check bottom", "src": "app/resources/Uploaded/pic.png", }, { "name": "check 2", "description": "cable can be seen there on the right place", "src":"app/resources/Uploaded/pic 2.png", }, // More steps... ];  Goal: Make Step Data Fully Dynamic Without Editing the ExperienceInstead of modifying the experience whenever step names, descriptions, or images change, I want to manage them dynamically from ThingWorx. My idea is to create a ThingWorx Mashup that allows users to:Select the Vuforia Experience they want to manage.Enter/edit step details (name & description) via input fields.Upload ima

Hello Community, In our ThingWorx Mashup, we have implemented a date range selection feature. When a user selects a date range and confirms, an Excel file containing the corresponding entries is generated and downloaded.Each entry includes approximately seven photos, which are stored in the File Repository. I would like to enhance this functionality by allowing users to select a date range and download all the associated photos in a single step. However,  there can be a large number of photos (e.g., 100+), I would prefer to provide them as a ZIP file to streamline the process. My question is:Is it possible to implement this functionality within a ThingWorx Mashup? If so, what would be the best approach to achieve this?Any guidance or suggestions would be greatly appreciated!Thank you.

I have stored few files in thingworx repository. And also iam giving download link to download files. Customer only wanted to see files in creo view by clicking the link provided in thingworx mashup.

Hello,   I am facing a weird behavior with grid. I am population grid with an infotable, I call it 'data_IT' . 'data_IT' is a property of a thing 'Thing_A'   In the mashup, I associate the 'data_IT'  to the grid using the service getproperties. and i check 'Automatically update values when...' so, when a row is updated,  it's replicated automatically in my mashup.   Everything works fine until I added a new field of type 'Image'. The automatic update stop working ! When i remove the image field, it's works fine again!! Is there any solution for this bheavior ?   Thank you for you help