ThingWorx

How to calculate the amount for total hours in javascript. For example: starttime :10:00am to  endtime :11:00am the difference will be total 1 hour .so for one hour amount will be 50/-.Likewise for each updated hours amount should be calculated. Please help me to write  service

Hi, I'm encountering some basic problems with Time Series Chart - i dont see any values. What i've done so far (including looking thru tons of post about it): 1. I have DHT sensor connected to arduino, which is posting requests to Thingworx, everything is working fine - values are updating. I've done everythin whats in  the https://developer.thingworx.com/en/resources/guides/display-data-charts/ddc-create-thing guide, created stream and dataShape. 2. i've created a mashup and I've put there Time series Chart, ive connected the querypropertieshistory service to chart etc. But nothing showsup.    

As the querypropertyhistory contains a lot of historical data, how can i efficiently get data for a particular time interval and write an optimized code operation.

 How can we provide separate date and time input in the "startDate" and "endDate" parameter of querypropertyhistory service and how specifically we can enter a different date and a different time as an input.  Please let me know the steps to implement the above scenario.

Hi , I installed a ThingWorx testing environment in a virtual machine. I have about 100 Things in my system.  Recently the performance of Composer become very slow when I do any operation, especially for opening a mashup .    Checking the Tomcat's monitor (http://localhost:8080/manager/status) , I noticed that lots of irrelevant requests when I open a entity(mashup, data table, or a thing). For example,  If I try to open a Data Table called "DeviceStationInfoTable ",  then I see the following irrelevant  requests :    1084 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/Mashups/MultipleCollaspseTest5/Avatar HTTP/1.1 106 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/Mashups/MultipleCollapseTest5_1/Avatar HTTP/1.1 2707 ms 0 KB 0 KB 192.168.152.1 192.168.152.1 192.168.152.142 GET /Thingworx/Things/poc.njhtzd.thing.ViewModel/Avatar HTTP/1.1 776 ms 0 KB 0 KB 192.168.152.1 192.168.152.1

Hi @drichter ,    Did you find where this is coming from? I'm having the same issue on my server.

Hi - I need some help with retrieving a proof of concept that was built on the trial version. The license for the trial has since expired and I am unable to login and extract the files. Is there a way to extract the solution that was built or a possibility for a temp license that I could use to get the files? 

Hello, When ever I export any Thing or Collections than getting rendering error. I have attached a screen shot. Can anyone please help us.

How can I encrypt fields like emailAddress and mobilePhone in the User Extensions tab for a particular user? Can I remove some of the fields that I do not wish to be displayed?

Hi,   I have tried to call Copy({ async: true, queueable: true, ... }) 13 times, and there were ONLY 10 files copied. I have figured out that there is a setting called maxOfflineQueuePerThingSize. That's fine. The problem is, GetQueuedTransferJobCountByThing() does not return a number of jobs queued when the Copy above is called => I would be unable to check when I should not queue more Copy tasks.   My Bests, Hung Tran  

Hi, We are working on ThingWorx HA using ThingWorx 8.4.4 version. We are planning use Azure Postgre sql database. In Azure Postgre sql, there are 2 options 1. Single Server 2. Hyperscale Server group which one is best option? What I understood is stores more than 100GB data using Hyperscale Server group If we use single server , can't store more than 100GB data?. Could you please suggest which one is best?   Thank You. Latha

Hi,   I am trying to loading Realtime/Simulated value inside ThingView Widget. Is there a document or a link available to guide us on this?   Avinash

Hello, I'm newbie on Thingworx technilogie and after doing the guides am trying now to develop my first application. The idea is simple: 1- Use Raspberry pi as Gateway (Done) 2-Connect EMS to IOT Thinworx (Done) 3- Configure my first Thing : Pi_Thing with auto_bind and connect it to the remote thing on the platform (Done) 4- On Mu PiTemplate, i want to develop a lua script to get json result , parse it and sent the resut to a remote property  on thingworx platform.  Reading the LUA Doc i think i have to user tw_http request: Some thing like: tw_http.get(host, port, path, headers, query) For test reason im using a public api just to test if it works: https://pokeapi.co/api/v2/pokemon/ditto/   Can you help with the lua script  to get the JSON result from the API on the file Pi_Template   I created to property: properties.JsonTest={baseType="Json", pushType="ALWAYS", value="{}"} when i call the api: properties.JsonTest = tw_http.get("https://pokeapi.co", "",

I am trying to show the windows services status (running or stopped) on thingworx? can someone please suggest how it can be done?

Hi   Has anyone had any experience implementing the "ThingWorx With Dynamics 365 Field Service" extension?  When I try to import the extension it reports the error "Unable to process import: Validation Failure: ThingShape ConnectedDynamics.ThingShape Had An Invalid DataShape [AR.ExperienceDataShape] assigned to property [AR_Experience]" when importing the extension.   Has anyone found an easy fix to this problem? If the extension is indeed broken, is there any other means of setting up a simple proof-of-concept integration into Dynamics 365?  

Hi, I am trying to return 4 values in a single column using java script. I have created a datashape to store the values and using array. But the script doesnt accept the infotable and says can not convert json to infotable. When I keep the base type as json it doesnt return anything the result is blank.  How can I return 4 rows in single column? Please help me in modifying the service.   var params = {infoTableName: "FilterBy" /* STRING */,dataShapeName: "Navistar_FilterBy_DS" /* DATASHAPENAME */};var FilterBy = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);var arrayOfFilters = [5]; {FilterBy.Filters = ["Part", "LineSet", "Job Num", "Part Type"];for( i = 0; i < FilterBy.length; i++){arrayOfFilters = [i];}}result = arrayOfFilters;     Thanks, Shalini V.

Hi, I have a UI in which I have a combo box having 19 mashup names and a browse widget in which I wanted to browse the image from pc and once I selected the image, when I click on apply button I want the selected image to be set as mashup background style for selected mashup from combo.   The basic idea is to make the background of mashup as configurable.   Please give some idea on how I can achieve this.   Thanks, Shalini V.

Hi Team,   I am creating a Time-Series chart which is getting data from a service that is fetching telemetry & corresponding timestamp from a database every 10 seconds. All the values are Logged & Persistant. My question is that i am not able to show the Timestamp that is coming from the database in the time series chart. Only the current timestamp is being plotted that seems to be coming from Value Stream. Can you please help me solving this issue.

Hi Sharon,   I'm having the same problem trying to get TW 8.4 running.   I copy/pasted a platform-settings.json I found from here and I have validated it as well. (see attached)   From Application.log: 2019-08-05 16:26:30.670-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] [message: Connections could not be acquired from the underlying database!]2019-08-05 16:26:30.671-0400 [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***   From catalina.out Caused by: org.h2.jdbc.JdbcSQLException: Wrong user name or password [28000-195]at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)at org.h2.message.DbException.get(DbException.java:179)at org.h2.message.DbException.get(DbException.java:155)at org.h2.message.DbException.get(DbException.java:144)at org.h2.engine.Engine.validateUserAndPassword(Engine.java:3

Hi experts , I'm beginner about thingworx. I'm Korean so I am poor at English.   I want to know snippets. I don't wonder definition of snippet. How it is used and What do I use it for thing?  I hope a simple exercise. Thank you.    

Hello. I'm evaluating ThingWorx and trying to import a bunch of Kepserver PLC devices into ThingWorx. Hundreds of tags via. OPC UA and the default must be to log the parameters. There doesn't seem to be an obvious way on how to ensure all added parameters are logged. What's the best way in doing so, could I do a simple API call, perhaps set a default setting on a ThingTemplate, or programatically go through the properties setting the value?   I tried the following script but it won't work for me.  Error executing service SetAllPropertiesLogged. Message :: Property [IndustrialThing] does not exist Anything I logger.debug() doesn't go to the ScriptLog making my developer experience very frustrating.

PTC's Voice of Customer team is conducting a short survey to  better understand where you are in your IoT implementation. We are going to be using this information along with other data points already gathered to inform upcoming strategic workshops. It is important that we capture your experience in your own words to bring to strategic leaders in PTC. We are not collecting in personally identifiable information in the survey.   The survey takes just a few minutes:  https://ptc.qualtrics.com/jfe/form/SV_3mYiNHFjJh5zKu1   Let me know if you have questions!    Thank you in advance for your time. Nalie

Is it possible to use the data filter widget to a collection widget? If possible, how to do that?

Hi, I am using export button to export data in a grid but when we open the excel sheet the columns are not aligned equally. Few rows are left alligned and few rows are right aligned. How can I prevent this scenario? Also the column values are interchanged in some rows. Please provide some solution for this.   Thanks, Shalini V.

I am not able to import the Java SDK extension in thingworx. Shows the following error.