ThingWorx

Hi, I want to build a D3 Bubble chart using ThingWorx how to do this? can someone provide necessary steps to do that.

Hello,             I am displaying some Windchill part information in my mashup on grid. There are many rows in grid with column name as :- name , number , state and version. I am able to select multiple rows using  ctrl + mouse click.  After selecting multiple rows, I want every Image associated with that particular part should be displayed beside the grid.   I have drag a Image widget . I am able to display Image after selecting single row. I tried using collection and repeater , but can't able understand how to use them.     Below I am providing an Image , which illustrate ,how my output should be .     When I select 3 rows or more , an Image should be displayed.

Hi, Is it possible to get the selected row of a text in a popup with text boxes or a grid with just that row? Please provide some idea.   Thanks, Shalini V.

Hello Team,   1.Firstly, created an extension from java imported on thingworx. 2.Then deleted the extension and reimported the extension with some changes(after building and packaging extension in java). 3.But now the changes are not getting reflected it is showing the same old imported extension data and status.    What needs to  be done on this?   Any help is appreciated    

Hi ,   Please help me in letting know the ways/steps to connect the Oracle DB to ThingWorx .   Regards, Abhiram

I have a .NET SDK edge application written in C#.  I am using the GetNamedPropertyValuesVTQ call to return a set of properties from a THING.  One of the properties is an image.  Casting to IMAGEPRIMATIVE or byte[] shows a length of 0 in debug mode.  Double question set is: 1. How can you convert an ImagePrimative to a C# image to be able to persist the image to client folder.  2. Is there an alternative way to download the image property into an edge application (C#)?

Hi,   I wanted to add the button in the advanced grid column/cell. Can anyone please help me out how to create it?   Thanks & Regards, Khushboo Jain

Hi all, i am new in thingworx. I would like to read data from SQL db and write to OPC via THX. Could you, please, help how? I connect successfully OPC to TWX I try connect MS SQL 2014 to THX via Relational DB extension, but I have some troubles - Unable to Invoke Service test on SQL : null  JDBC Driver Class Name com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc:sqlserver://localhost:8080;databaseName=thingworx  Error Getting Tables : The TCP/IP connection to the host localhost, port 8080 has failed. Error: "The driver received an unexpected pre-login response. Verify the connection properties and check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. This driver can be used only with SQL Server 2000 or later." If I try port 1433: firewall is off Error Getting Tables : The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make s

Hi,  I am researching possibilities of Thingworx platform.  One on the requirements I have, is to connect to external database and display it's data in the mashup (I have MSSQL and PostgreSQL database engines). Also I would like to modify records in that database (i.e. submitting value from mashup).   There are few guides for older versions of Thingworx platform, but those seems outdated and confusing when it comes to downloading jdbs drivers and creating Database things.   Can you include a simple guide here, or narrrow my searches and give us a clue how to accomplish that.   Thank you in advance, Jarek    

Hi all,  Can i able to create a data for menu with user group?   Thanks & Regards, Sathishkumar C.

hi Everyone  I am  trying to  stored image directly in SQL database  and then retrieve that image from table and display it on mashup. so after storing image on DB by taking image as base type of that Column and while fetching it from db by writing service it is giving me that encrypted text so my question is how i can convert it to actual images and what should be that return type of that service ?    Thanks in advance 

I'm wanting to check whether the Thing's properties have been updated within a certain period.  I've tried the "HavePropertiesChangedSince()" service, but it seems to include the metadata properties such as "name," "description," "tags," and "thingTemplate" in its decision.  I only need to know if my custom properties (Temperature for example) have changed.   Any ideas on a way to accomplish this?  Is there a way to get a list of the custom properties on a Thing without the metadata properties?

Hi, I wanted to use the data filter widget but am not able to get the exact out. This is the service i wrote for filtering. var query ={ "filters": { "type": "And", "filters": [ { "type": "Matches", "fieldName": "ParameterVal", "value": "*" }, { "type": "Matches", "fieldName": "AlarmCategory", "value": "*" } ] }}; var params = { ValueQuery: Query /* STRING */, CategoryQuery: Query /* STRING */}; // result: INFOTABLE dataShape: DataFilterTesting_DSvar result = Things["TestingThing"].DataFilterTesting(params);   DataFilterTesting is another query which has (select * from AlarmType where AlarmCategory = [[CategoryQuery]] or ParameterVal = [[ValueQuery]])   How am I suppose to proceed? Please provide some help. Thanks, Shalini V.        

Hi, In order to represent a hierarchy of data in tree widget where should I fetch the service data? I tried to get a table from sql using select query but I was not able to display any runtime data in tree. How should I approach this to get output like the attachment? Thanks, Shalini V.    

On click of button file got save to repository. How can i download the file from repository. Is there any widget i can use please suggest.

Hi, I am using the PDF extension to send out pdf reports. For the static mashup able to generate pdf report by using Create PDF service but, for the dynamic mashup getting blank screen in pdf report. I want to pass the parameter's to the create pdf service. How can I do this job?   Please provide some idea?   Please find the attached screen shot.   Thanks & Regards Nagaraj Enamate

Hi all,    I am using PDFExtension to create pdf for my mashup. When I pass the server address and executing the CreatePDF service I am getting empty pdf.   Please help me to resolve it. Please find the attached screenshots.

HI,Is it possible to edit a grid?How can we do that?Thanks,V.Shalini.

Hi, I am using Editable grid to add, fetch and edit properties of a data table. But for few properties whose values are null at present, i am not getting empty field in mashup so that i can add or edit the respective property. Instead i am getting either an empty but non-editable field or a field with 'Object object' text content. Attaching sample image. Any solution for this please.   Thanks and Regards, Kiran

Hello, I am new to ThingWorx and I am developing an Alexa Skill (Service Provider) which wants the data from ThingWorx (resource provider). I want to Authorize the users who enables this developed skill by asking them to sign up to the thingworx application for the first time and the communication between the Alexa and Thingworx from then on would happen with Access Token and not AppKey or Passwords. For this mechanism to work, ThingWorx should support OAuth2.0. So far I could not find any documentation (except the one describing SSO using PingFederate), which is totally a different scenario. Could anybody give some hints regarding this Alexa-ThingWorx-Access Token scenario. Thanks in advance 🙂

Hi,   I have some columns which have null, double values. I want to replace the null value with previous reading.I am fetching the data from oracle database.I want to manipulate the result of the sql query service using thingworx.   Thanks in advance.

how to display the hierarchical data in form of tree in mashup as shown in the image.    

I'm having issues viewing custom widgets in a mashup (ThingWorx 8.2).  I followed all of the steps on Article CS246176 (https://www.ptc.com/en/support/article?n=CS246176&source=snippet) but I still get the "<widgetName>does not exist" error on run-time.  At first I tried a widget that I created with the d3 library.  Then, just to check my sanity I created a simple "hello world" like widget in Eclipse.  Both of them throw the same error.  Are there any newer widgets in the marketplace that, if installed, cause issues akin to what the aforementioned article addresses (i.e. d3 tree, network, and custom chart widgets)?  Or has anybody else found a solution to this issue?

Hi I am trying to display browser time zone in one of my mashups label, But it is giving me server time when running my service.  Attaching screen shots of how I need to display time Note : I am able to display the format but it is giving server time.  Highly appreciate if any one could help me on this.   Thanks in advance,      

I have a service retrieving a json file from several devices via the contentloaderfunction getjson. After the json is retrieved I parse the data and output an infotable and display the values in a mashup. If the service fails the widgets displaying the data show errors on my mashup. I would prefer to show no data vs an errored widget. Is there anyway to have the service return an empty infotable?