ThingWorx

Hi , I'm Newbie to ThingWorx. Kindly help me to Write JS service or Query service to fetch data from two or more  Database tables as table or grid. Help me Javascripts to fetch data from database to display in mashup   Thanks all in advance.

Hi team,   I am trying to work on a large infotable. Which will be faster to filter the data Query or EQFilter?   filtered_table = Resources["InfoTableFunctions"].Query({t: large_infotable/* INFOTABLE */,query: {"filters": {"type": "EQ","fieldName": "field","value": somevale,}},});     Resources["InfoTableFunctions"].EQFilter({fieldName: "fieldname" /* STRING */ ,isCaseSensitive: undefined /* BOOLEAN */ ,t: large_infotable/* INFOTABLE */ ,value: somevalue /* STRING */});  

We will host a live Expert Session: "Thingworx Flow Overview" on December 10th, 8h00 EST.   Please find below the description of the expert session and the registration link.   Expert Session: Thingworx Flow Overview Date and Time: December 10th, 8h00 EST Duration: 1 hour Host: Antony Moffa; Vinay Vaidya - Thingworx IoT Platfom Senior Directors Registration Here: https://www.ptc.com/en/customer-success/expert-sessions-for-thingworx-foundation-webcasts    Description: Overview of Thingworx Flow, an application for integration and orchestration between systems. This will focus on use cases, main features such as triggers, connector options, main enhancements for Thingworx 9.0 and a short demonstration.   Existing Recorded sessions can be found on support portal using the keyword ‘Expert Sessions’. You can also suggest topics for upcoming sessions using this small form.   Here are some recorded and upcoming sessions that might be of your interest. You ca

Dear community,   Thingworx does not support multiple inheritance of ThingTemplates. This alone is worth a feature request from my point of view but I doubt it would ever come and even if, I need it now.   I understand well that a Thing or ThingTemplate can use multiple ThingShapes, that's how it is designed. But there are situations where this is not enough. Here my example: I want to create a FileRepository Thing which exports data on a scheduled time. I need FileRepository and Scheduler, both available as ThingTemplate, not ThingShape.   Of course I can create two separate Things, the Scheduler Thing can call the FileRepository Services at trigger time but I consider this an ugly workaround and I wonder whether you can offer me better solutions.   Thank youBenny

Hello everyone,   I've been trying to invoke a service from a Stream, in order to retrieve data based on a DATETIME.   However, the only functions I see available retrieve the full Stream data. This is something I'd like to prevent since we are aiming to store millions of records on this stream.   Is there any way to query this data from the Stream with the out of the box solutions ThingWorx provides?   I'm using ThingWorx v9.0

Dear community,   I am uncertain about the capabilities of the data filter widget. The "ShowAdvancedOptions" flag lets me choose between "And" and "Or" but only on top level, no nested filters possible.   In this example I would like to query Timestamp greater than <date> AND (   EventId = 40 OR  EventId = 99 )   I know that this is possible using code but having this option also available for the widget would be very convenient.   If this is not possible, what is the best workaround?   Used version is 8.4.4 if that is important by any means.   Thank youBenny

Hi all, I was a little shocked that Thingworx 9.0 requires JDK 8U241 or higher. No alternative support for OpenJDK or Coretto is available. As a consequence every commercial user upgrading or installing Thingworx 9.0 is forced to purchase Oracle Java SE Subscription Licenses which might be quite expensive depending on the underlying architecture. Does anybody know about any plans to support Open JDK or Amazon Coretto in upcoming releases of Thingworx?

I want convert hex data into text or readable format please check below hex data   55 55 00 5A 21 41 02 00 00 38 36 31 32 35 31 30 33 38 30 33 39 33 39 39 A5 08 D1 5D FC 2C 82 39 F9 6E 34 BF 14 B1 61 89 B5 E3 A4 2C 88 F4 A8 AA 0B 43 78 EE 7C 37 6A 94 27 A1 20 BF AF C7 3D F0 FE 25 B1 6D E7 4E F6 3A 35 3A D5 0F 91 83 0D 80 36 97 70 F6 DC E8 0A 81 AA AA    please suggest the way how we can do it in thingworx

Im having problem making Query parameter for QueryInfoTablePropertyHistory  service used in mashup to populate advanced grid. I made service with query output and simple filter to give me only entries with Rack_ID  1                 This service output is linked to query parameter input of QueryInfoTablePropertyHistory. But this doesnt filter my data table. Using filter widget as query input I can get needed result.   Also service that gives me infotable result directly with this filtering works as well.   But I want to make query service to do this to see results in mashup grid.   Am I missing something?          

Hello,    The error state "Unable to connect, check your port". I am using the PTC Cloud trial version from developer portal. I have checked some alternatives for the error and I notice that my problem same with his. Unable to connect to the Thing Worx academic simulator - PTC Community But the problem still unsolved. Here I attached my error. I hope anyone can help me. Thanks.    

Hi   I am trying to setup an analytics server for my TWX platform, for which I am stuck on getting the UploadThing zip file to be installed on the server. Attached you will find the extracted Thingworx_Analytics_Extension files in which UploadThing.zip should also be present however it is missing. Workaround needed   Regards  

We are aware of using the application log or script log when error arises. But, sometimes it also happens like when you check the application log for an error, it again says to check the log, like check log for more details. We get quite confused at such points. It would be helpful if you could give any input on this.

Hi,  Sometimes the log, including the Application log and Script log,  doesn't tell which line the error occurs like the screenshot below :    How can I know where the problem is ?  (except print logs in the service to guess )         ThingWorx version : 8.5.5   Regards, Sean

Hello everyone,   I am trying to login through the Thingworx academic simulator using the URL, app key and port no. but I am getting an error : "Unable to connect, check your port"   The server URL is : https://pp-2004130945zw.devportal.ptc.io/Thingworx/Composer/index.html  I am only using pp-2004130945zw.devportal.ptc.io  from the above URL in Academic simulator. I have checked my Device ID as well as port no also properly. Port no - 443 since it is https I have tried modifying the port as 80 but no use. I have tried running TAS as administrator but no avail.   I have also made sure that my server is running by going to the server and launching it. Read many threads on the same error and tried everything. But still I am getting the same error.   I have tried downloading the desktop version of the Thingworx foundation also but the device configuration requirement is 16 GB whereas I have only 8 GB in my laptop. So, I could not install that. &

Hi ThingWorx Enthusiast,   Which service, resource to use to decrypt the property value which is encrypted using below snippet?   var params = { data: "<Some_Value>" /* STRING */ }; // result: STRING var result = Resources["EncryptionServices"].EncryptPropertyValue(params);   I didn't find relevant decrypt service under EncryptionServices resource and wonder how to get back the original value.   Thanks, Shirish

Hi all   i've the same problem 1. Anyone have the solution?   thank u all

Hi Team,   I have an infotable with a single column. for example the column name is fruits. There are multiple entries in the infotable and there are duplicate entries also. I need to get the count of occurance of each value in the infotable. I know I can use distinct function to get unique records in the column. Later i can loop through the infotable comparing the unique string and increasing a count variable. But what I want is to know if there is any way to get count of "orange" in below infotable using inbuilt function.   Example infotable records : orange apple apple orange lemon     I need output like   apple 2 orange 2 lemon 1.

Hi,   I`m using Button Bar widget, in the state definition display text is N/A but instead of showing N/A it is showing some other HTML text.   i.e: N\2f A   How to solve this?   Regarding, Janakiraman P        

I am using google maps widget, I need to show number values per country on the map it self. eg. in japan 20000, china 15000 like that i have to show values in map without any additional mashups. For better understanding i uploaded screen shot for how data should be displayed in UI.

We can see there is a property of Remote Access widget named "ListenPort". But I cannot find this in RemoteAccessClientLinker widget. How can I use it?

Sorry if this was already mentioned somewhere. I searched and didn't find it.   In ThingWorx 9, the EnterKeyPressed binding now behaves like "Focus Lost".  If you have textfield with the EnterKeyPressed action bound, that action will be fired whenever focus leaves the text field.  I opened a case with PTC when I discovered the behavior and was told it is working to specification: "this event is triggered when a user clicks an area outside the widget or presses the enter key after updating the widget value".   We're most affected with some mashups that have several text fields for optional user input.  Prior to ThingWorx 9, the user could enter something in one of the text fields and press enter to trigger the action, or tab to the next field and optionally press enter there, etc.  Now if the textfield has the EnterKeyPressed action bound, that action runs when the user presses tab to go to the next textfield.  

Hi,  I found a very strange phenomenon,  the ES6 syntax like "let", "const" work well normally.  But in certain situation,  the Lint will report error, see the attached picture.    The line #315 and #325 define the same variable name , but it's not the root cause.  Changing to different variable name has the same error.    It seems the error occurs when the code lines exceeds about 310, but I'm sure .      Regards, Sean

Hello IoT Community! I would like to build my mashups in a way, that some buttons (or other widgets) are Enabled/Disabled depending on whether the user has the permission for the underlying service (e.g the service executed when clicking that button).   For that I thought I could write an expression that checks whether the current user has permission for a specific service. Do you have any Ideas how to write a simple expression for that? As far as I know, an error is thrown when a user tries to execute a service he has no permission for. So maybe I could somehow "catch" the error in the expression?Maybe something liketry(functionToExecute()) { return true; } catch(error){ return false; }   Unfortunately I have no idea how to implement this behavior...Any advices are appreciated very much!Best Regards,Dominik

Hi,   I have a iFrame widget which shows webGL 3D model returned from external system. There is a button on the mashup to send post request to the external system. I want to make visible = true for the iFrame only after external system responds.   What I did; - Made async service to post request to the external system. - The service wait until the external system responds - The service set session parameter to true after the external system responds   Problem; - Session parameter is not updated by the async service   Any other solution?

Hello, After upgrading to thingworx 9.0, I created a mashup with some of the new widgets, specifically the line and bar chart. Everything is looking good until I added that mashup into a master. Then the chart widgets became scrunched and stretched (See attached screenshots) I then tried with a new, from scratch master and mashup. Same result. Any help on this would be greatly appreciated.