ThingWorx Developers

advanced grid is having rows and columns. We have datachange event of a row. But on clicking a particular cell, can we pass that cell's value ??

While the service is loading Bar chart is showing the word "error" in the place of xaxis values. Once the service passed output to the xaxis values of bar chart, the word "error" is replaced with the xaxis values.    The word error should not be displayed at all. How to fix this ?

How can we implement cascading dropdown functionality in ThingWorx.I am binding my first dropdown item from infotable, my second dropdown should fill based on selection of my first dropdown.shall we need to create a service which will take the o/p of first dropdown selection item, and it should go as service i/p for second dropdown ?Thanks. 

Could anybody let me in on the most proficient method to make custom widgets in thingworx. I have no clue about how to make a custom widget. Please help me.  Thanks in Advance

Can someone suggest How to export a prescriptive model in python?  Thanks in advance!

Good day community. I have three templates, each containing different things.I want to display the things inside of each template one at a time. I am using the tab-set widget since I want to navigate through the different templates. However I am struggling to display below the things contained in each of my template. I have tried binding values to the value and label widget property. Also I tried to write a service that outputs the things depending on the selected tabs.Please see below: if(SelectedTab === "Laptops"){var result = ThingTemplates["LaptopsTT"].GetImplementingThings();}if(SelectedTab === "Houses"){var result=ThingTemplates["HousesTT"].GetImplementingThings();}else{var result= ThingTemplates["CarsTT"].GetImplementingThings();}  How do I go about this?suggestions will really be appreciated

Hi, Please share the path from where we can download the ConnectionServicesExtension-2.2.4.zip extension file or the latest one compatible with TWX 9.3. Thanks in advance

I am creating an app that reads bit values from an opc and calculates an state based on which ones are active. Problem is sometimes they change in pairs at the same time and the subscription that is listening to that runs twice and gives two simultaneous results. Is there any way to make the service wait untils it's finished before running again? It is currently written in java using the thingworx extension library and it's already synchronous. Thank you

I am trying to update DB thing configuration parameters using services (SetConfigurationTable).  JDBD Driver Class name Connection String DB user name DB password   Everything working fine.   But, if i am trying to give some random value to 'JDBD Driver Class name' (Ex. com.yourdatabase.yourDriver) and getting an error "ERROR starting: JDBC Driver Class Not Found: com.yourdatabase.yourDriver".   Also DB thing stopped running. It can be resolved by opening DB thing and Click Save.   How to avoid this issue? How to start Thing programmatically if Thing is not running? - RestartThing() not working How to validate 'JDBD Driver Class name' in Thingworx?

Hi EveryOne, Whether any limitation there to use number of containers in a mashup? If yes what is the limit. If no such limit What may be reason of loading UI itself slower. It makes delay of loading media in UI. The image size is also 917 bytes only. Nearly 100 container, 25 images, 50 labels, 50 buttons will be there in mashup.  Thanks,MC

I want to create a hierarchy structure, i have all the data in infotable,  is it possible to bind an infotable to tree widget in ThingWorx. Which services we need to user for this activity.Thanks. 

I am trying to call the sql query service in a javascript service. While printing the length of the data returned from the sql query, it is giving null.While executing the local service, it is throwing error: Error executing service. Message ::Unable To Convert From org.mozilla.javascript.UniqueTag to INFOTABLE - See Script Error Log for more details. Can anyone please tell me where am I going wrong. try {  let sqlData = me.getAllProductsDetails_DB;  logger.info("mySQL_DB_TH   getAllProductsDetails  sqldata" + sqlData.length); // Output is null  // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(AllProducts_DS)  let data = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({    infoTableName: "InfoTable",    dataShapeName: "AllProducts_DS",  });  for (var i = 0; i < sqlData.length; i++) {    var row = sqlData.getRow(i);    // AllPro

Hi community team, How do we differentiate TWX Pie Chart color for the dynamic fields?Thingworx Pie Chart is showing the same color for all the fields. I want different colors to be shown among different dynamic data. ThingWorx Version 9.3.2@PEHOWE @PaiChung @slangley 

Hello everyone,I working through my training manual ThingWorx Fundamental overview, using software version 9.3.2Ref Page 59: Created new user XXXX password **** OK.Now I want to add this user to administrators group, as per document search for administrators User Group: Administrators  Did not find any way to add newly created user to this user group.Also tried Browse user Groups cannot see any group listed here strange? Might be something simple I am missing. 

Hi,There are subscriptions on EventAnyDataChange, but when ever there is any change in the Property the subscription are not getting invoked. There is no issue in logging the data in to the DB, that's working fine, but the subscriptions are not invoking.Restarted the VM and also the TomCat.@slangley , @PaiChung Thanks,Shashi.

Hi community team,   I want to know how many entries of state-style definitions we can make in a State Definition. ThingWorx Version 9.3.2  @PEHOWE @PaiChung @slangley 

Hi,I have created Thingshape and added Infotable type property, assigned Datashape to Infotable property.How to set default values to  Infotable properties to Thingshape through programmatically? Thank you in Advance.Latha

Hi All,I need to send an email based on certain values by inserting html tags within the body. The tag code is ready but I am facing challenge in sending dynamic values within the tag. The values are different strings generated at runtime. Can anyone help me.

Hello I am from Rockwell Automation, which is partner of PTC. I am trying to use the Thingworx partner license to handle over some customer facing events. I Want to make sure I follow all license compliance, but I couldn't find any agreement or items of conditions in terms of partner license. Could PTC give me some feedback? Thanks.

How to see Java Codes which is imported to thingworx as services ?

I already implemented the below css for the dropdown widget. It was working fine. After I updated the chrome version, It is not working now. ptcs-dropdown::part(icon){color: blue !important;} Can someone please help to resolve this issue? RegardsSugumar 

Hello, I tested with the H2 database, others might be affected. I tested 9.3.1 and 9.3.3 with the same result.When setting KEYSTORE:  from 'true' to 'false' in the docker-compose files, the database password isn't changed in the final platform-settings.json. The TWX_DATABASE_PASSWORD from the CUSTOM_SECRET_LIST: 'encrypt.db.password:TWX_DATABASE_PASSWORD' is never replaced, regardless of which password is put to replace it. I checked a bit further and found in platform-settings-overrides.json.j2:"password": "encrypt.db.password","username": "{{ env_var("TWX_DATABASE_USERNAME", "") }}" So the username is replaced but the password is set as plaintext. I believe this is intentional, to have it be replaced by finding the "encrypt.db.password" string at another point.But it never is. Building with the keystore activated is working fine and causes no problems. Am I overlooking something or is this currently not working or supported? Thanks. R

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