ThingWorx

Hi, I am using the MQTT template to subscribe to MQTT values, but when I query for property history I only get the values which I set manually. I think it's a permission problem. Any help is appreciated. Thank you!

Hey @krishnakomal ,   Do you know how to change the color of dropdown scrollbar by using CSS? Here I attach SS. Please help me in this.      Thanks.

Hello. i have the following pareto with small values that i cannot use the 'SeriesClicked' event because the values are so small. is there a way to click the cumulative line 'dot' or the label and trigger an event? 

Are there any best practices regarding installing RTPPM w/ MS SQL on an existing ThingWorx running w/ PostgreSQL?

Hi, I have created an account to access the trial. While logging with my credentials, i am unable to see the server option to launch. Do helpful to resolve my issue.

Hello, I have a problem to solve this : I have an Infotable create in Thingworx and I want to use Java Edge SDK in order to enter data in the first row.Today, I got this : ValueCollection row = com.thingworx.crypto.functions.HTTPRequest(pictureFolder, urlHTTP, predictionKey);FieldDefinitionCollection fields = new FieldDefinitionCollection();fields.addFieldDefinition(new FieldDefinition(NAME, BaseTypes.STRING));fields.addFieldDefinition(new FieldDefinition(DATE, BaseTypes.DATETIME));fields.addFieldDefinition(new FieldDefinition(C, BaseTypes.STRING));fields.addFieldDefinition(new FieldDefinition(Z, BaseTypes.STRING));defineDataShapeDefinition("ds", fields);InfoTable resultInfoTable = new InfoTable(getDataShapeDefinition("ds"));ValueCollection entry = new ValueCollection();entry.clear();entry.SetStringValue(NAME, row.getValue(NAME));entry.SetDateTimeValue(DATE, row.getValue(DATE));entry.SetStringValue(C, row.getValue(C));entry.SetStringValue(Z, row.getValue(Z));resultInfoTable.addRow

Hey everyone !I am design a good loking ui interface, anyone know if it's possible to change the color/style of the scrollbar in the mashup ?here is a screen of my front-end application : 

Hi All,Do we have any kind of decoders available for ThingWorx to read the MQTT data with Sparkplug Specification? Currently I can read the data in encrypted format but I wanted to get it decrypted and get it as a JSON. Any help to understand this is appreciated. Thanks.

Hi,  Do we have a solution to that since that question was asked ?

Hello,  is there any way to clean a selected location in the google map widget?

There are a few things mentioned on this site about this "SAMEORIGIN" error along with suggested fixes.  But the easiest fix I have found is when entering the URL, add the following parameter ("?rs:embed=true") (without parens and quotes, of course).  You should then be able to open URLs within the Webframe widget.  Your URL should then read something like https://my.domain.com/myreport?rs:embed-true&otherparams=asneeded.   I ran across this when attempting to pull down a report from SSRS into ThingWorx.  The on-screen error was not helpful at all (On-screen rror message:  <URL> refused to connect).  But when I opened Developer Tools, I saw the full error (“Refused to display <  URL > in a frame because it set ‘X-Frame-Options’ to ‘sameorigin’ ”).  Adding the above parameter allowed the report to open very easily, and then you can then print a full paginated report from within ThingWorx from SSRS.   E. Shaffer

Hi Developers,I'm seeking on how we can get over 500 records with 1 SQL query.currently we can get maximum 500 records with 1 query. can we make this limit bigger ?  

Hi, I would like to move the ExpandCollapeSelection to right side. Tried with below CSS but didn't get any solution. Also attached video for reference. Need your help ASAP. .tree-toggle::part(tree-toggle-icon){position:absolute !important;right:0px !important;}#root_ptcsgrid-120-bounding-box::part(tree-toggle-icon){position:absolute !important;right:0px !important;}

I am currently working on configurator application and it looks something like this We haveSome configurations on leftA Thing View with a model loaded in the middleA list of selected configuration on the rightI want achieve two things here.Some how get a list of all parts that are currently on this model and I will make them checked by default in the left menu.Hide and show specific parts based on my selection on the left menu. For example, when I unselect Bucket from the menu it should be removed from the model and when I check it , it comes back.This feature I want to add is similar to the Windchill Visualization option. But I don't know where to look for this in Thing Worx and what option of Thing View I need to update.   

Hi all, is there any way to retrieve the token name using the token valuesThere are multiple entry for token name which has same token value. For example ui.testpassed= test passed , also test_passed = test passed. Need to clean up duplicateThanks in advance 

I have a mashup with an advanced grid that displays data coming from sql server database. I want to be able to add and remove rows in order to add or delete row data. I was able to add two two advanced grids. Grid one showed all my data and grid two was empty. I was only able to select multiple rows by holding ctrl button. That's the only way I could pass data to the other advanced grid. Is there another way of doing this? I want a user within the mashup to be able to add/delete rows.

Hello, i keep getting these info server stats every 30 mins and would like disable it. any suggestions? 

hi, i have a thing with several service each of them add a entry to stream when is executed, the process for add this entry is same on all services but not all services add entry, and i don´t know which is a problem. can you help me?

Hi Everyone, I am having troubles while creating Java extension for converting data from JSON to INFOTABLE, I have tried multiple methods and no seem to work. @ThingworxServiceDefinition(name = "JsontoInfo", description = "", category = "", isAllowOverride = false, aspects = {"isAsync:false" })@ThingworxServiceResult(name = "Result", description = "", baseType = "INFOTABLE", aspects = {"isEntityDataShape:true", "dataShape:DemoDS" })public InfoTable JsontoInfo(@ThingworxServiceParameter(name = "input", description = "", baseType = "JSON", aspects = {"defaultValue:{\"name\":\"Abcd\",\"salary\":25000,\"married\":true}" }) InfoTable input) {_logger.trace("Entering Service: JsontoInfo");_logger.trace("Exiting Service: JsontoInfo");return input;}ERROR:  Unable to Invoke Service JsontoInfo on TestResJson2info : Cannot cast org.json.JSONObject to                        com.thingworx.types.InfoTable if anybody

Below is my code: //creating an infotablelet Log = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DataShape"}); //Defining date variablevar currentDate; //assigning valueList variable to my infoTable property that contains values (current it only has one row)var valuesList = Things["TestThing1"].infoTableThingProperty; //loop through the infotable abovefor(var i=0; i<valuesList.length; i++){// new object newEntry = {duration:valuesList[i].duration,source: valuesList[i].Source,Name: valuesList[i].Name,Type: valuesList[i].Type,StartTime: valuesList[i].StartTime,EndTime: valuesList[i].faultEndTime,Voltage: valuesList[i].Voltage,Text: valuesList[i].Text};//adding my object values to the infotableLog.AddRow(newEntry);} //adding my infotable to the stream var newLog = Things["SinkWorx.PwrSupplyError_Stream"].AddStreamEntries({values: Log /* INFOTABLE {"dataShape":"StreamEntryWithValues"} */});&nbs

Some background, we were having some issues with properties connecting that do not change often. We changed the push type of the property to "Always" and this allowed good quality. According to best practices though, we shouldn't do this for many properties. In the same article, it mentions setting the Cache time would pull from the Edge device so we tried this in hopes these properties can pull these static values and connect. Issue: We're having trouble with setting the cache time of a remote property via service. Here's the code, cacheTime grabbed from this article.    // properties and addresses from Kepware propertiesAndAddresses = ["FlowMeterFlowRateAV","S7E_1501_1032.1032.3.DB74,DBW10",.....]; for(var i = 0; i < propertiesAndAddresses.length - 1; i+=2){ var aspects = { "tagAddress": propertiesAndAddresses[i+1], "scanRate": 500 }; me.SetRemotePropertyBinding({ propertyName: propertiesAndAddresses[i], // STRING aspects: aspects,// JSON cache

Hi Community, We created a grid using collection widget, which is working fine for us and is showing data as per expectation.But only two users are facing this issue that no data is loading for them on screen, but service is returning data in response. Although, I can see child mashup name in headers of network with Request Method as GET and Error code as 404.Is data loading on response and not on runtime because of this 404 error or can this be due to something else?Permissions seem to be working fine for user.

Hello,I develop a thingworx application and our application is in a site that publishes us as an iframe. But in this way, the cookies do not work anymore. Indeed, the domain name on my browser is no longer the one of the Thingworx application. And I have the impression that it does not fit anymore. Is it possible to configure the cookie domain name so that it works as an iframe? Thank you for your help. 

I installed ThingWorx 9.1.1 (Postgres, Java 11, Windows) using installer. After the installation, I can't see ThingWorx-Foundation.exe in tomcat/bin folder. 

Thingworx Version: 9.3When ever the Mashup is opened as PopUp on a button click, there is white border on the button (button on the opened Mashup).Thanks,Shashi