ThingWorx

I need to open a page with HTML code generated by a service, I can use: a standard mashup with the  Html TextArea widget inside (passing to it the html generated by a service)this works if edit mode is enabled, but if I set "read only" to hide the editing bar, the HTML is not rendered correctly (there is a basic table <table> <tr> <td>..... it just shows text, not the table grid. May be a bug) Generate the .html file on a repository, and open with browser.I didn't tested but it should work .. are there other options ?   // I have thingworx 8.5.9

Hi Everyone, I have used Thingworx 8.5 then I have shifted all my backups in thingworx 9.0 it's fine and there is no issue with any entity but now when I have shifted all the Thingworx 9.0 backups into Thingworx 9.1. It totally strange, some widgets that I have used in thingworx 9.0 mashups are gone. I have used PostgreSQL queries in Thingworx 9.0 but after shifting backups in Thingworx 9.1 it's not running I haven't modified any query after shifting as it is I have shifted. a select query is running in the database thing but not running JOINs query in the database things Spoiler (Highlight to read)SELECT workout_type_id,workout_type FROM "ref_workout_type" ;SELECT workout_type_id,workout_type FROM "ref_workout_type" ; Like above query is running but not running below types query i.e JOINs   Spoiler (Highlight to read)SELECT mem.member_id,concat(us.first_name,' ',us.Last_name) as fullname,ci.city_name,us.is_active,mem.checkboxFROM "tbl_members" AS memJOIN "tbl_users" AS

Hi All, We are trying to connect Dynamics 365 (not CRM) with flow with very little success. I can and have successfully connected to Dynamics CRM so I know that part works. After discussions with PTC we were told to use odata  to retrieve the information. I have the endpoints and I can view the entities in a browser. I know that in flow I need to setup a OData basic connector but that's where I fall short. I was pointed to  Configuring and Loading OAuths > OData Shown below. OData Perform the following steps every time you want to add an OAuth provider for your OData instance: 1. Configure OAuth on your OData instance, and as per your OAuth configuration, provide values in the OAuth configuration JSON file. The following are example values that you might provide for loading OAuths: ▪ Provide header information in the "oauth2_validate_headers" array, as shown in the sample array: {"oauth2_validate_headers": ["{\"Authorization\":\"Bearer {access_token}\"

Hi,   I am trying to call a Sql sequence in Thingworx . i wrote a sql query service in a thing and tried executing it. But it shows the following error "Execute Query failed: com.microsoft.sqlserver.jdbc.SQLServerException: NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set, or the query contains TOP or OFFSET."    how to resolve this?   Thanks in Advance Sadagopan P

How to disable the Apache Tomcat version returned in HTTP headers while loading Thingworx.

Hi , I am using container and in that i added two layouts(Containers) one is responsive with fixed height and another is fully responsive contains bar chart but appearing scroll bar . how to resolve it? please see below snap for ref.. Thanks

Even Though I have 20 Entries in the Database, the Repeater and Collection widget is showing only last added Data in all the Cells as shown below: The Only Binding I have given to them is GetDataTableEntries .....!    

Hello, I have an issue with an advanced grid (V4.2.1) where it does not render my last column.  It is fed by a service with output type <Infotable> but no datashape defined. The service executes fine and I can see all the columns in composer. As well, I have a configuration service output <string>, result fed to the configuration binding of this widget. Everything was working well with V4.0.1 but it is deprecated and I cannot get it to render properly with the new version.   I am using TWX 8.5.3, attached pic for reference. Any ideas?

Hi, I am running prescriptive analysis with the same input data. But I am getting different optimized result but within a specific range. why it is happening?   Regards Shyam   Re:  post

Hi,   Advanced grid widget headers disappear when double clicked on the header and appears back when reloaded. Is it possible to make it not disappear on double click?   Thanks in advance, Sadagopan PSSKP

I recently spent some time checking how different stuff can be done in Thingworx and the Elasticsearch integration was one of the mini-projects. It turned out to be somewhat standalone and completed, so sharing it here in case someone would find somehting interesting from it.This project is an MVP / PoC enabling indexing of documents (in common formats like PDF, Word / Excel / PowerPoint, TXT) stored in ThingWorx repositories with the help of Elasticsearch and then performing full text searches against the documents' content from ThingWorx (mashups or services). The project is simple and small and only consists of 4 entities, 2 of which are there only for demo purposes.The implemented functionality only covers the main use case - performing full-text search. Advanced stuff, flexibility and additional features are to be implemented depending on the requirements of the particular project and intended use cases.See the accompanying readme and video for the installation steps and the demo

Hi All,   I had read the solution in the community, but still not able to get a transparent background, for the Grid Advanced   I had tried the following: 1. Created  a Base theme with both the background removed   2. Remove the background for both Row and alternate row..   but i still cannot make the background transparent. can anyone guide me?  I am working on Thingworx V9.10 - Grid Advaced.    Thank you ! Newbie Kek  

Hi All,We'd like to access files in repository folder of ThingA from another things which are in the same project like ThingB. Can we do that ?    

Hi! I'm wondering if there're some ways to show relationship between Mashup and Thing services? Typically, a Mashup will bind some Thing Services and internal Expressions/Validations, the relationship is quite complicated and working in different level. So I'm wondering if there're some ways to show relationship, or extract data from .xml source code and show it in diagram? It will be very very helpful to design review and documentation. Thank you very much!

Hi All,    I ma getting a error when I am importing google map widget in Thingworx 9.1. Can you please have a look and let me know why is the issue coming.  Below is the error message -   ERROR [widget] "CustomCSS" widget type is missing required member widgetProperties()   I am also attaching the widget zip file for reference.    Regards Swaraj Ostwal

How to convert Thingworx Image Datatype to String in thingworx Services

Hi, I'm a beginner, trying to import the analytics extension, but occurs validation error as validating some extensions.I know "ThingWorx-Analytics-8.5.7-r2-Extension" need to be extracted and import those zip files one by one, but these 4 extensions can not be validated and imported.Here is the error I met: But "Thingworx-Analytics-analysisprovider_ExtensionPackage" has already imported.How can I do ? And here is my email: m10902214@gapps.ntust.edu.twThanks a lot.

I have the same issue. This ServiceableTS was never created in this course. How should i create this ThingShape?

Hi,  I'm working on integrating ThingWorx 9.1 with a 3rd party IdP product (not microsoft active directory and azure).  In this case , I could use PingFederate as Service Provider to the IdP and use SAML authentication to get the user info according to the help document.    However ,  the IdP product seems only support OAuth2.0 and PingFederate as SP doesn't support OAuth2.0 (see the attached picture).    So, what's the official solution for the case to enabling SSO ?    Is it feasible to create a  customized authenticator which communicates with IdP via OAuth2.0 to authenticate user and get user info ?   The customer use Flow as well and ThingWorx servers are deployed in cluster mode ,  will this situation affect the customized authenticator ?    Regards, Sean      

Hi All,   We wanted to pass parameters to our application which is rendering in an iFrame of external application (build on angular). We wanted to utilize window.postMessage() API as part of iFrame contract where we can send information from external application to thingworx app.     Is it possible ?    Thanks and regards, Vishal Vaidya

Hello,   I would like to know if it is possible to measure the Internet data consumption of my KEPWARE to communicate with the Azure cloud.   I have a customer who does not provide his local Internet for KEPWARE operation (because of data security).   To make the sale of the project viable I gave the idea of using a mobile internet (3G / 4G) but I need to measure how much internet I will consume to buy the best data package.   If I can measure how much a TAG consumes on the internet I can multiply it by the total TAGs I have and get an idea of the total consumption.   Is there any way to know this?   My environment:   KEPServerEX 6.9 consumes data from a ControlLogix PLC (Rockwell Automation) and makes this data available to the Thingworx platform (version 8.5) installed on an Azure cloud.

Hi, I Have created an organization tree as shown in the attached image.And also created different groups and assigned it for each branches. Most of the branches have different Homepage, for example here  machines and Line Supervisors both have different Homepages. My requirement is,When a user from groups assigned to 'Machines' login, he should see Machines Homepage. The same goes with 'Line Supervisor', when a user from that group login he should be able to see the Line Supervisor login page. The organization tree only have option to add Home mashup at the 'Company_Name' level and at the individual user level(not to a group). If i am login with url: .../Thingworx/FormLogin/Company_Name . It will show the common home page assigned to 'Company_Name', which is incorrect. How do i resolve this Problem?     Thanks, Sri1

Hello,   How to set maxpagesize as greater than 2000. I have custom odata api which would return more than 2000 records. So I wan t to return all the records in single responce. Please assist.   Regards Prem

Hi, I am seeing that in Scheduler we can assign a user in RUN AS USER field in General Information entity. I have a Doubt that will it be Runnable for All users in a Group if we keep Run as user (only one user)? because it allows only one user to add.     Thanks

Hi All,   I am building a mashup in Thingworx 9.0  where I have to display status of machine i.e. either running or stopped. I am getting that status via a service which I have binded to a data shape. Requirement is to show status of machine in green if machine is running and red if machine is stopped. I used value display to show the value status and in background I placed a shape whose colour will change as per status of machine. I have binded data of service to shape, but i am not able to find exact state formatting to achieve this result. Currently i have configured ALERT TYPE(as shown in attached image). Kindly suggest how to achieve this. I have attached an image showing the objective that needs to be achieved.