ThingWorx

Has anyone tried to migrate ThingWorx from Microsoft SQL server to PostGreSQL. Currently we are using ThingWorx 9.4.2 version.

Hi Everyone,I have grid widget which data is populated through a SQL service, and I want to export that data which is in the grid into an excel file , can I do that if so then please share the solution.   Thanks and Regards, Lavkush

Dear Community,    So below in attachment is my datashape of my datatable and currently i am getting all the entries in one of my service. Is there anyway that with infotable capabilities i can get entries which are created in the last 30 days. As you can see i have one of the parameter qualityCheckTimestamp which records the datetime for the entry. Now i would like to use pre existing function of infotable to get the entries created in last 30 days and if its not possible then i would have to iterate through all the entries to get the desired entries which would might be slow process. so anyone have a clue about it? Thank you 🙂   

Hi all, I have a dropdown on my Mashup that gets display data from one of my properties which have an infotable as output and Datashape of GenericStringList. It used to work fine but one day it just stops working and I can't figure out why after troubleshooting for half a day. Any help will be greatly appreciated.Below is the settings for my dropdown widget:Cheers,Deon

Hello ! Background :My application has several mashups that are loaded onto computer screens to display information. These computers start up automatically at the beginning of the day, then a script loads a mashup link. The link contains an Appkey, linked to a virtual user with rights to view the mashup. So these screens have no real user in front of them, they're just there to give information to people looking at the screen.Note that I have several different screens in different locations. Each screen works like this, using the same Appkey, linked to the same virtual user.   Problem:After a while (more than an hour), a login pop-up appears at the top of the mashup (see screenshot). The application continues to run in the background, but the pop-up is still there. I don't understand why the mashup requires a login, when it's still working and has an Appkey.   Solutions tried :I've tried changing the mashup session ID at regular intervals (every 5 minutes). I thought that if

Hi! I'm trying to post to thingworx.  Is it posible without creating the thing via post?   Is there an easier way to send JSONdata from a node.js application to ThingWorx?   Thanks for the help 🙂

Hello All,      I have a datagrid widget in which i am showing some entries as you can see in the picture below i can choose which parameter to show and which do not. when i select the parameters and save changes then it appears and shows me but then when i open the mashup next day again then its again gone and do not show me the parameters which i have selected to display on the mashup in datagrid. I want the parameters which i selected to show me always there until i do changes. anyone has an idea about it?    

Good day all, I have a table that contains a timestamp field.I want to replace the values in this field with a specific dataDifference calculation that I make. The two dates that I use to find the difference are inputs.I have written the code below. It seems like the issue occurs when I assign the new timestamp value to the table.  if (testMode) {    // Get data directly from the property for testing purposes    searchTable = Things["ThingName"].ChartData[0].Data;} else {    searchTable = data;}  let params = {t1: searchTable /* INFOTABLE */};let clonedTable = Resources["InfoTableFunctions"].Clone(params);  // Find the row in searchTable with the matching timestamplet searchForTimestampRow = clonedTable.Find({timestamp: currentTimestamp});if (searchForTimestampRow) {    // Calculate duration    let duration = dateDifference(currentTimestamp, otherTime);     // Update the duration fi

Hi Everyone,I have a requirement in which I ahve data like this  Now i want to sort data Based on Approved state , Sports Category Mainly Approved State and then want to show the data on line or bar chartso Basically requirement is in the drop down all the approved state will be there and when I select one of the approved state the data will populate in the Bar/ Line chartso how can I implement this pls share your solution  ThanksLav

Needed to copy some properties from one Thing to other. To avoid manual work, created Service with AddPropertyDefinition (later wanted to add service to copy values). It creates no error when running first time, but properties are not generated. So, started script - and it answer "Property [name] already exists".Manual refreshing of Thing in web service does not help. Restart Thing by code also makes no difference. Here is sample code: myList = me.GetPropertyDefinitions({category: "MyCategory" /* STRING */,type: undefined /* BASETYPENAME */,dataShape: undefined /* DATASHAPENAME */}); for each (var x in myList.rows) {Things["MyThing"].AddPropertyDefinition({indexed: undefined /* BOOLEAN {"defaultValue":false} */,defaultValue: undefined /* STRING */,remoteBindingAspects: undefined /* JSON */,description: "my desc"/* STRING {"defaultValue":""} */,readOnly: undefined /* BOOLEAN {"defaultValue":false} */,type: 'INFOTABLE' /* BASETYPENAME */,remote: undefined /* BOOLEAN {"defa

Hi,   I have changed the port to 80 in the server.xml:   When I looked into the Catalina.out, I get the below error:   Does anyone know the solution?   Thanks,

In TWX 8.5, it was possible to enable sorting for all fields in advanced grid widget without enabling it for each field. In TWX 9.5, the new grid widget requires the sort functionality to be enabled individually for each field in grid configuration. Is there a way to make all fields sortable without enabling it individually for each field in grid configuration?

Dear PTC,We are in the process of planning an AM deployment. The purpose of this discussion is to gain a comprehensive understanding and documentation of the capabilities of PinkFederate and ADFS, as well as the differences between the two.Background Information:We configure an Windchill to Denodo connection on our network utilizing PinkFederate and OAuth2.We seek your expertise in determining the most suitable approach between PinkFederate and ADFS for our requirements and can we do the same setup using ADFS.Thank you for your assistance.

var lastMinDate = new Date();lastMinDate.setSeconds(0);lastMinDate.setMilliseconds(0);var result= lastMinDate;

Hi, I am using a date picker widget on a popup  on ThingWorx 9.5, for some reason when I select a data from the calendar, the pop-up closes automatically. Is it a known bug? and is there any work around? Thanks in advance.

I'm currently installing Thingworx server on linux.While installing the database i notices the following: 6. Configure pgAdmin:$ sudo pgadmin4◦ In pgAdmin, click on file->Open postgresql.conf◦ Open /etc/postgresql/x.x/main/postgresql.conf◦ Put a check next to listen addresses and port. The default settings of localhost and 5432 are usually sufficient.◦ Save and close.◦ Click on file->Open pg_hba.conf◦ Open /etc/postgresql/x.x/main/pg_hba.conf◦ Double-click on the database ‘all’ line with address 127.0.0.1/32◦ Set Method to md5◦ Click OK◦ Save and exit◦ Close pgAdmin(Sorry i'm unable to quote!!) I'm not happy that MD5 is used for Hashing. MD5 is not a really secure algoritm anymore and i would like to use Sha-2 (what is current default) if possible! Is this possible? if Not Why...More info on MD5:https://security.stackexchange.com/questions/19906/is-md5-considered-insecure https://www.freecodecamp.org/news/md5-vs-sha-1-vs-sha-2-which-is-the-most-secure-encryption-hash-an

Hi Everyone,I have a grid data of 1000's row now I want split data into different pages using pagination widget please help me to write logic and implementation as I am new to thingworx so not much idea on it Thanks and Regards,Lavkush.

Lately I have been working with some UI widgets extensions. It seemed to be a repetitive task to do the initial developments, version it, deploy , look for bugs and repeat. So I thought of develop an Eclipse IDE plugin (As is the primary IDE supported for extensions development), which can automatically increase the path number of the extension, build it and upload to a target Thingworx server, preferably Development. Attached is the jar file of the plugin that you can use with eclipse. If interested you can follow the following steps and try it out,1. Download the .jar file and put it into drop-ins folder of your eclipse IDENow restart the Eclipse IDE, Once restarted you will see a new icon in the toolbar of your IDE, You can now use the plugin, on click of this the following download would appear, In the dialog, select the extension project, set the server address, and add an appKey with Admin level access, don not forget to click on Update TWX details. That would store the

I am using ThingWorx Platform Release 9.2 and DatecodeSP6Hi,Regarding the case Article - CS250386, to update element in the Configuration table of a Thing by custom script service, we should enable and restart the Thing after calling SetConfigurationTable. This documentation is available for Thingworx until 8.4. Is it really what we have to do to update the Thing Configuration? We didn't find anythhing about that in the documentation.What about the next version (9.2 -> 9.5)?

Hi,  I am trying to use the validation inputs for a text box widget. If I manually set these parameters then it works as intended and looks like this:  But if I try to bind validation functions to these parameters for when the text box has a comma, then it simply doesn't work. I have already verified that my service is working correctly and is bound to the properties correctly, but for some reason it just doesn't work when I bind it over on validation. Any ideas? 

var date = new Date();for (let index = 0; index < 12; index++) {    let startDate = new Date(date);    startDate.setHours(18 + index, 0, 0);        let endDate = new Date(date);    endDate.setHours(18 + index + 1, 0, 0);        console.log("StartDate " + startDate);    console.log("EndDate " + endDate);}

Hi all, I have a line chart widget that I want to remove the markers from only one line on a multi-line line chart as such:I want the grey and red dots gone since these are just limits, but to leave the purple ones. I have found a way to remove all the dots and a way to change the size of all the dots but no way to only change some of them. Note: I have many dots on the limit lines instead of just the endpoints of the time range because when trying to use the zoom feature, the chart the lines disappear unless there is data within the zoom time range, so I found this to be the best solution if I can get the dots removed.

Hi all, I am trying to zoom into a line chart that has limit lines made: I want to be able to see these limit lines still if I zoom into the image, but they disappear even if I keep them in the zoom range:Any tips on how to get this line to stay even after zooming?

Im having trouble making the mashupcontainer the same size as the container im placing it, tried to solve with css but no luck, anyone know how to make so mashupcontainer has the same size as container?

Hi Team,   What SQL Commands can be used to Change the Collation/COLLATE of the MS SQL SB?   Thanks,