ThingWorx

Hi, is there a way to extract a value from an infotable row based on the column index. Normally you extract the data by referencing the field name i.e.  var myVal = myInfotable.rows[x].fieldname ;   However, I am using GetLoggedProperties() service to create a list of property names. I then iterate through this list and use the QueryNamedPropertyHistory service to create the table using an enrty from  list of logged property names as an input. Ideally I'd like to be able to extract the data values from the resultant infotable using something like: var row = myInfotable.rows[x] ; var myVal = row.Fields['xxxxxx'] ; (where 'xxxxx' is the input property name)   Is there a simple way to do this? I do know that because I only pass in 1 property name that the column I'm interested in will be the second one, so perhaps I could use an index?   Thanks, K      

Hi, Thanks in advance. I had a query on the Expression function in Thingworx. I was using the Expression widget for some simple calculations and check, it returns Output only when there is 'no' parameter or 'one' parameter. When I try to add more than one parameter, after saving the Mashup when I check it the Output is set to null. Attaching the screenshots of the same.

Hi all   I have imported the CreatePDF widget from the markeptplace. And under services it has a service "CreatePDF" wherein we have to input the mashup server address etc in order to generate the PDF. It also has an input field for appKey, just wanted to know is it necessary to input the appKey if yes where can I procure one from?   -Ketan

Hi, Will the thingworx foundation not run without the license installed? The ThingWorx foundation is installed in our server but we have not applied the license. Whenever we start the tomcat and try to run without license, the tomcat automatically stops. Is there a dependency of license for apache and thingworx foundation to run? Is it not possible to up the thingworx foundation to run as unlicensed version and import entities and apply the license later?    Thanks & Regards, Shalini V.

Hello everyone,I've developed a extension widget in typescript, using the template below from github:https://github.com/ptc-iot-sharing/ThingworxDemoWebpackWidgetWhen i add this widget to a mashup alone, the widget works fine:          

When a user clicks an option on a drop down on a mashup when using an iPad , the tool tip appears at the top left corner. (see image) This only seems to be an issue with drop downs. Tool tips appear to work currently on other widgets using the iPad. Any fixes? I need tool tips to function, so I can't hide them.  

Hi TW Gurus, Need to know, How to connect to SQL server from a thing, I have created using base thing as database. I was using trial version of TW.   Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver Connection String: jdbc:sqlserver://XXXXXXXX:1433;databaseName=XXXX Privided user and password   in the log - I am getting this below error: Unable to start thing ConnectSQlServer, JDBC Driver Class Not Found: com.microsoft.sqlserver.jdbc.SQLServerDriver   am I missing anything? ~PC  

Hi Team,   Is it possible to change the style of the confirmation popup of a button. Like to change the width and height of the confirmation popup.   Thanks,  

Hello everyone,   I'm new to the front-end side of development regarding ThingWorx. Recently we had an issue on our Mashups.   We use a 'Master Mashup' (Header Only) to create a 'Navigation Bar' so we can navigate between our dashboards.    The 'Master Mashup' Header (Flex Container) is set to Grow and Shrink all nested containers. And this is working accordingly (child containers are resized accordingly). However, we have some 'Label' widgets inside those child containers whose dimensions are set in a static manner (for e.g. Width and Height '50' px).    For some resolutions (For e.g. FULL HD) we have no issues. However, if we keep decreasing the resolution we note that the 'Label' widgets do not Grow/Shrink accordingly, and this is causing some deforming to occur.   Any pointers on how to make the 'Label' widget resize itself accordingly?   Best regards

I want to install thingworx foundation on windows 10. but it it always asks me to uninstall previous installation of thingWorx-foundation.  Actually, i have uninstalled the previous. how can check if i uninstall completely? 

Hello   I need to get binary files from integrity web site With attachment file URL, ID, Password, how to download attachment files.   I saw getbinary() service. Can I use getbinary() service? if possible, can I get sample code? especially parameter   Thank you BS

Hi All,   I have an infotable to store marks of students which has a field named "marks". Can I get the count of students who got 90,75, 35 etc.... Example 7 students scored 90, 3 students scored 50.   I need the percentage of students that scored particular mark. In above case 70 percent scored 90 marks, 30 percent scored 50 marks.   I am trying to use Donut chart to represent the percentage of occurance of each mark.   Thanks and Regards, Bhanu.   @CarlesColl 

We have a data table in Thingworx of usernames and passwords. Using these the user would enter his/her own username and password and it would retrieve that info from the data table in Thingworx to check if its correct. Is there any way this could be achieved?

I want to reorder the rows of a grid advanced after the data of the grid has been loaded already by dragging & dropping a row in its desired place. Is this possible? Thanks in advance.

Hi, Though we can use the Home Mashup field in ThingworxSSOAuthenticator under User Defaults to set the home mashup corresponding to the users who are using SSO to login, believe it would be for uniform for all the users irrespective of the user groups they belong to.   Is there any possible way to specify different home mashup for users belonging to different user groups.

Blank screen is coming after login with Thingworx user on Form Login page of my organization   My user is part of user group and user group is a member of Organization   Home mashup of organization is already assigned with landing mashup and that mashup is being given the required permissions, Application log is showing error Entity Not Found : [PlatformSubsystem] but platform subsystem is present in my Thingworx 9 environment   Thanks in advance.

Hello! I was wondering if I could have an image that while hovering it with the mouse it would show some information (labels and buttons) in front of the image. Is it possible? Thank you in advance. 

Hi everyone,   When I try to change to navigate to another dashboard through of my menu happens it:   "Could not load "Mashup Name", internal exception 4"   Can someone help me?  

Hi all,   Could anyone help me to change Thingworx Flow Port from 443 to other port.   Thanks in advance.   /VR

Hi,   I am implementing a workaround for a custom toastr extension, Iam using a Mashup as modal popup with animations using custom css to display the toastr. I need to change the panel/Mashup color based on an input like to show green when its a success message and red when its a warning. The Input need to passed from another mashup to the toastr mashup. Toastr mashup contains a panel and label widget., I am using thingworx version 8.5   Can anyone please point out a way to change the panel color using a custom input?

Hi Team,   I'd like to export some data in a grid. I have attached the all data from my service to the grid, configured the grid columns so that they are user-friendly (Ex. OwnerEmail to Owner Email) and removed the grid columns, that I do not want to see and download. I bound the Data Export widget to the edited table, but the mashup will not download the edited table. How can I get the export widget to download the edited table?   When i bind the data from the service directly, I can export all the data. However, the column titles are not user-friendly and there are columns I do not want to download.   The solution given in the topic https://community.ptc.com/t5/ThingWorx-Developers/Data-Export-an-Edited-Table/m-p/503130 is to create a  custom service. But If I am using multiple grids in my solution it is not feasible to create service and provide the numerous changes in the column names to it. Is there a way around it?  

Hello,   is there a way to open a specific web page in a mashup , when clicking on a row in the tree widget? So that I can configure for each Thing in a tree widget (which is defined by a Network of things)  a URL which will open up, when clicking on it?    

I have a problem when I import “MYSQL Extension Package” on the ThingWorx Platform, it gives me this Error “Error Occurred during the import” also when I press Validate button it gives me the same Error “Error Occurred during the Validation”.   I have been tried many versions of Database Extension but I faced the same problem. notice i have tried to find another version but i cannot find anything in the Marketplace.

Hi,      How to retained the message in topic when we are in offline. There is any ways to retained messages in ThingWorx using MQTT template. Please explain detailed.       Regards, Saranya.S

Hi, i'm still new to thingworx.    Is there a way to export the entire project and import it back safely without loosing any of the connections.   Thanks in advance.