IoT & Connectivity

hii i have one database(POSTGRESQL) configure with thingworx 9.1. i have created postgresql thing which contain services(postgresql queries) for eg:- i have one postgresql query which gives me allmembers data but it shows an error  "select ch.tcr_id,concat(us.first_name,' ',us.last_name) as member_name,ch.user_id,ch.checkin_time,ch.checkout_time,ch.band_id,ch.checkboxfrom "tbl_checkin_records" as chjoin "tbl_members" as memon ch.user_id = mem.user_idjoin "tbl_users" as uson mem.user_id = us.user_id order by ch.checkout_time desc;"        this is my query which gives me an following error:- Unable to Invoke Service getAllCheckinRecordsForMember on PostgreSQL_DB : Execute Query failed: org.postgresql.util.PSQLException: ERROR: syntax error at or near "as" Position: 165 But when i was using  i have attached snapshots below for your better understanding

Hi,I work with Dygraph widget but can not understand how to connect a valuestream to PTC.SCA.SCO.DygraphUtils services How to connect input for GenerateDygraphData - Chartseries in mashup. Are there any examples I can look at.

Hi All,   I am using progress gauge to show shift advancement as well as machine state. To explain clearly my thought I am taking an example of machine running an 8 hour shift in which runs for 4 hours goes down for half an hour, starves for next half hour and starts producing. So as of now we see 5 hour of machine time which include 4 hours run time, half an hour downtime and half an hour starving time.    Now I am looking to shows various states of machine in different color and with respect to advent in the shift time. I am attaching a sample screen shot of my functionality. I want to show this on a progress gauge. I am receiving the machine state as 1-warning, 2-Running, 3-Planned downtime. 4-Unplanned downtime and 5-unavailable.   I used a progress gauge assigned data and did state formatting but no luck. Can you Please help me with this?   Kind Regards SO

Hi,   I have some base 64 content of a PDFs. I want to show them on mashup. Using Iframe I can show it normal html page but, not in thingworx mashup.   I have done showing pdf from external URL, pdf from repository but not getting successful using base 64 content. I am attaching few files for the reference.   Save as attached file into .htm file and you can see it in browser. I am using same text in TEXT property of "htmltextarea" widget  in thingworx (9.1.0-b10877). But it is not showing anything. By inspecting the page I can see it only show html tage with empty body.   Regards Shyam  

Hi, Where I can find Thingworx Eclipse Plugin & Extension SDK. I've tried in few articles and posts but Not able to find them. Also tried accessing Marketplace for the plugin not able to find. It will be helpful if someone shares the actual file link. Thanks in advance.

I need to have clarity on effects applied and customized which is launched by thingworx about fizos food demo in ptc portal.   I have a doubt how hover effect is applied for each container in below image. Can i have code or logic used in fizos food app and also how menu items are arranged in center  total customization code of fizos food demo     

  Hello everyone,   If you’re like me, you’re always looking for the optimal or most efficient way to do something. Today, I’ll share a quick trick and two tips to help you develop your awesome IoT solutions with ThingWorx.   #1. Trick: Finding Dependency References We are targeting a new “Where Used” Composer feature in an upcoming release of the platform to help you find your references of bindings, properties, mashups, and services. In the meantime, did you know you can get some of that information yourself today with a quick service call?   As of ThingWorx 8.5, a new service is present on Project entities; the service crawls the contents of your project and highlights the full external dependency list to help you find references. On any Project Entity, ListExternalDependencies() shows output like this in 9.0:  ListExternalDependencies() output   For each entity (“A”) in the project, the service calls out any entities (“B”) that it is refere

This is a fairly simple question that I can't find the answer to anywhere. I'm dealing with a DataChange event - Update - and I would like to know what the EntryChangeEvent data shape field definitions 'id' and 'type' indicate in the system. I have a theory that they have to do with specific entry that was changed in the data table, but I can't confirm it.

Dear community,   I would like to build a responsive mashup with overlapping widgets. I want to display a text over a circle shape. Label does not work since it is not responsive, so let's go with value display.   When adding/copying the value display into a container that already contains the shape I get the error message "Container supports only one responsive widget". I am not sure why this is prevented by the mashup builder, it should be up to the designer how many widgets I want to overlap (using Z-Index).   Using Panels does not work as it loses the responsiveness. I don't see any other option than writing my own "shape with text" widget. But then I will have the same issue again in a few weeks when overlapping two other widgets.   Thank you Benny

Hi! I want to know if it's possible to modify the default loggin form of Thingworx (see image).  Is it possible to modify the style? If the answer is yes, how or ? if the answer is no, have you use another framework like Angular to create a logging page and connect that with Thingworx or exist a extensión or there are other ways to create it in Thingworx?    Thank you in advance! Luis

Hi I want to get the difference between the timestamp value logged when a property updates on a thing. The thing has an valuestream. Do I need to write a service for this? Which snippets would I use? Or is there an existing service which would do this so it can be displayed in a mashup. Thanks in advance.

Without making changes to the mashup itself because it is deployed as a package, is it possible to have a thin informational banner at the top of the Thingworx application in the web browser using tomcat. We want to use it to let users know they should use Google Chrome to view the Thingworx app. We want to do something similar to the license expiration banner in the image I attached.

I have a custom group created -  SupportAdminGroup who are less privileged than Administrators group.   When SupportAdminGroup  member  was unable to execute Resources["EntityServices"].GetEntityList(params)  I gave the run time permission to read and execute for  SupportAdminGroup  in  "EntityServices" I was able to execute the service as a SupportAdminGroup  member . However , I want to use the service Subsystems["PlatformSubsystem"].GetEntityUsageReport();. I have given Run time execute and read permission to the group , yet it errors out  with   Entity [PlatformSubsystem] service [GetEntityUsageReport] requires Administrator privileges .   How do I get to use the PlatformSubsystem services for a non Admin user?

Hi Team,   Is it possible to show tree structure in tree grid advanced widget just like normal tree widget?   Because tree grid advanced widget displays data in the form of grid.   If yes, then please share the solution.

Hi Team,   We have a grid populating data from one service as AllData to data and 2nd service for populating AllData to SelectedRows of advanced grid, but it is not showing as selected rows on load.   I tried same behaviour with List using SelectedItems property. It is working properly as selected items of list.   Please provide the solution as we need advanced grid and not list for our application functionality.   Thanks in advance.  

Hello,          I want to apply below state formatting to label chart .Please suggest how do I apply state formatting??? and please refer below attachment  Thanks in advance

Hi all,   for some aggregation in memory I used an Infotable. So my Thing has an property of type INFOTABLE and I can access the rows to read/write single entries. e.g: var now = new Date(); me.tab.rows[0].ts_set = now; var result = me.tab; Thingworx 8.4 & 8.5 give me a result with the correct now() timestamp in the first row. I now tested this code in Thingworx 9.1 and it does not give me the correct now() timestamp in the first row!   So is it not possible to modify single entries in INFOTABLES in place any more? Do I really have to copy the INFOTABLE every time I access it and change the code to: var now = new Date(); var tab = me.tab; tab.rows[0].ts_set = now; me.tab = tab; var result = me.tab; Any suggestion, please?   Greetings   Andreas    

Whenever I try to use the endpoint GetPartInPartsByID I get the following error :   Unable to execute service GetEndpointDefinition on AG_Odata_Connector : JSONObject["PTC.CADDocumentMgmt.AssociationTypeEnum"] not found.   I saw that there is a support article https://www.ptc.com/en/support/article/CS332815  for this and it has the following info : Reported to R&D as JIRA ticket as PSPT-70331 If using Thingworx Integration Runtime version 8.0.9 or earlier IR versions with Windchill Rest Services 2.1 then errors can occur. PTC strongly recommends to upgrade to Thingworx Integration Runtime version 8.0.10 to work with Windchill Rest Services 2.1. But check ThingWorx Navigate Product Compatibility Matrix and confirm if IR 8.0.10 version is supported and compactible with current Thingworx Navigate version before you proceed for upgrade . If current Thingworx Navigate version is not supported with IR 8.0.10 version then upgrade Thingworx Navigate to latest Navigate

I have the same issue. An entity having services completely disappeared from the data tab, yet it is still visible in the connection tab. Importing an older version and reimporting it didn't work for me. When I'm trying to readd in the data tab the entity, then it create a new entity with the name "SAMENAME1" or "SAMENAME11"...   It's really bothering.   Regards,

By Tim Atwood and Dave Bernbeck, Edited by Tori Firewind Adapted from the March 2021 Expert Session Produced by the IoT Enterprise Deployment Center The primary purpose of monitoring is to determine when your application may be exhausting the available resources. Knowledge of the infrastructure limits help establish these monitoring boundaries, determining straightforward thresholds that indicate an app has gone too far. The four main areas to monitor in this way are CPU, Memory, Networking, and Disk.   For the CPU, we want to know how many cores are available to the application and potentially what the temperature is for each or other indicators of overtaxation. For Memory, we want to know how much RAM is available for the application. For Networking, we want to know the network throughput, the available bandwidth, and how capable the network cards are in general. For Disk, we keep track of the read and write rates of the disks used by the application as well as how

Hi,   In pagination widget , 'previous' and 'next' labels are not visible , instead it shows '???'. Please let me know how i can resolve that ? Attached is the screenshot for reference.  

Need is to turn off Autocomplete for fields like Password entry in Form as in the Login Page, so that the browser does not prompt user to save the populated values for later use.

Hi,  I was working on user creation script. few users has been created by non editable mode. I am able to see those users via GetAllEntities() not in composer, Also, i found a way to see users in composer by creating one service to add users in particular usergroup after adding them I am able to see added(non editable) users in that usergroup. In Usergroup if i click and delete user nothing happens,if I try to change property I get you can't delete non editable users. Now I added 10+ undefined users in that group. Now, I need to remove the users from my instance.. I tried via deleteuser service but users are not deleted and still I am able to see them via GetAllEntities()...

Hi, I try to execute a Thingworx service (Action "Service Execute") with a boolean input value in a Flow. The Boolean input parameter for the executed action is given from the input parameter (also Boolean) from the Flow itself.   The issue is that I cannot bind the Input params (oder params from other actions) to the Boolean input (like I could with any other input type like a String). I only can choose between a fixed true or false; see attached image. There is a option to not use the "Form" input a apply a JSON, but that does not work either. Because my second input variable (which is a String) is getting ignored somehow.   (i.e. {"BoolVar":{{$Service.BoolInput}},"order":{{$Service.orderNo}}} )   I don't like workarounds like: - Duplicate the action (one with "true", the other with the "false" input) - Change the input variable of the Thingworx service from Boolean to String because this is a fairly simply use case and it just would make things more complicated

Hello, I am part of a development working to push AWS data into TWX and vice-versa. Can you help with the steps involved for overall process.Thank you in advance.