ThingWorx

how to set the time to zero.   where I am using startDate = '2021-01-01' date1 = parseDate(startDate,"yyyy-MM-dd HH:mm:ss.SSS");   I want the the date1 to be date1 = 2021-01-01 00:00:00.000;   where I am getting it as '2021-01-01 10:00:00.000';   how can I make time as zero.

Hello Experts,    I have some sql queries that retrieve data from DB and by default it accepts as base type of the output only an infotable, i would like to convert the output to integer!!   Regards,  Youss

Hi,    How to build a thing that has both of the services of DatabaseThing and RemoteThing ?   is it possible in Thingworx ?    Regards, Sean  

Error when I follow step 3 of the f section on this guide and run the file 'thingworxMssqlModelTablesDataUpdate.bat' https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Installation/Installation/manual_inplace_upgrade_windows.html#wwID0E6WJS   Error: Migration failed at applicationkey_model.[expirationDate]. Rolling back the entire transaction.Error message: Invalid object name 'applicationkey_model'.

Hi Everyone,   I am having following scenario :-    One master page and one Mashup both I embedded into one (mashup having master page), where master having  there own customized Theme & mashup having there own separate Theme, when I am executing mashup (Runtime) then master theme influence mashup page UI (mashup page label, button , text box etc getting display as per master theme instead of mashup theme).    I know there is one property inside mashup named as "UseMasterTheme" which is Boolean one, I also Untick that property but still facing same issue.    Using Thingworx version 8.5.9    How I can resolve this problem & is there alternative ways to do this (having master & mashup different Theme & its work as independently like master theme only limited to master page component & mashup page utilized mashup theme only ) ?   Thanks in advance,  Shubham. 

In my Thingworx composer, I created an industrial connection, then I tried deleting it but failed. "Unable to dispose thing" always show when I delete it.  I then found I can only create but can not delete industrial connection. I used Administrator account. I googled this question but found nothing can help. Hopefully here someone can help.

Hi everyone, The issue is about infotable enhancement. When a value is set, it is displayed as a string and not as an infotable. All this in the data shape. If I create a property under the thing this doesn't happen. If I restart thingworx though, I see infotable valorized correctly but when I send a new value it returns string. Immagine 2021-07-06 233205 as it is. Immagine 2021-07-06 233300 as it should be. Thanks for the support

Hello amigos,   I'm a noob in Thingworxs and Im trying to color a grid cell (variable value) using as reference his setpoint. Does anyone know how to do it? Formatting just allows numbers, or Is it possible pass a variable name as value?    Thank you in advance masters!

I'm trying to use event router to channel two output into one. One is coming from grid's edited table and one coming from service1 . while creating the event router I have selected the same datashape for the service1 and the output of service which is passing data to grid. still when I try to bind grid edited table to event router it gives error as both router input and grid edited table need same datashape.

I tried to create Postgres persistent provider to store stream and value stream data.  I am able to connect DB( checked using isConnected service) but not able to store and retrieve data, when I use the default service of add stream-entry I am not getting any errors. but I tried to access row count by calling GetStreamEntryCount then I got the error below-mentioned error message.      I am getting errors like this :  Unable to Invoke Service GetStreamEntryCount on Demo.Manual.STREAM : com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]

Any side effects in giving force edit to the entities ??(except loosing updated datas)

Is there a way to reduce the verboseness of the console message output level with the .NET edge SDK? At the moment the TwApi Wrapper is output the following debug message every few seconds.   30 39 3A 33 31 3A 33 312021-08-14 09:31:31,389 [5] DEBUG com.thingworx.communications.client.TwApiWrapper - twWs_Receive: Received Pong2021-08-14 09:31:31,389 [5] DEBUG com.thingworx.communications.client.TwApiWrapper - msgHandlerOnPong: Received Pong. Data: 09:31:312021-08-14 09:32:16,305 [5] DEBUG com.thingworx.communications.client.TwApiWrapper - sendCtlFrame: >>>>> Sending Ping. Msg: 09:32:162021-08-14 09:32:16,320 [8] DEBUG com.thingworx.communications.client.TwApiWrapper - sendCtlFrame: >>>>> Sending Ping. Msg: 09:32:162021-08-14 09:32:16,380 [9] DEBUG com.thingworx.communications.client.TwApiWrapper - twWs_Receive: Read 2 bytes into header buffer2021-08-14 09:32:16,381 [9] DEBUG com.thingworx.communications.client.TwApiWrapper - twWs_Receive: Got Header: B

Hi Team I am working on showing data on graphs. I want to show below statewise population data on the graph.   State Population Missouri 9826732 Kansas 7838493 Newyork 2348890 Washington 332948   When clicked on particular state, user have to be shown population of specific county on another graph.   County Population Wandotte 8494 Johnson 892834 plaza 493784   Can you please suggest any graph that can be used for this purpose?    Regards,  

Good afternoon.   Could you give me a hand with the following doubt?   I have been working with property transformations in Thingworx Platform Analytics. I have an Azure VM with the following hardware configuration:   I have installed the following components successfully:   + TWX 9.x+ Analytics Server+ Platform Analytics+ Vuforia Experience Service+ Vuforia Studio+ Kepware   In the installation of the Platform Analytics, I configure the Analytics server integration, and all the installation steps run successfully as shown below:   Also, I followed all the steps to configure successfully the Property Transform Settings in ThingWorx, the RabbitMQ password encryption, and finally, I left by a defect the Property Transforms scalation.   Using a dataset I emulated a remote device with a Pressure signal. I used a timer to stream the pressure signal each 1, 10, 50, and 100 ms.   The pressure signal has the following form:     I created th

I am trying to push my entities to gitlab repository using the push function available in gitbackup extension 4.1.0 in thingworx 8.5.8.  The exact error message is org.eclipse.jgit.api.errors.TransportException: <repository> redirection blocked

Any properties available to customise/styling confirmation dialogue box?

Hello, I am newbie to Thingworx and C SDK.  I would like to know how to debug the C SDK code using gdb. I use SteamSensor C SDK as a hands-on exercise. This SteamSensor use C SDK and it connect to Things from Thingworx and register property and services.  I compile the main.c by using  "make" command. Then inside the folder "linux/bin/gcc-linux-x86-64/debug/" there is a binary file called "SteamSensor". When I command "gdb SteamSensor", it can debug the C SDK but the problem is that while I am debugging the main.c C SDK code, the thingworx is not connected so I cannot debug the thingworx part.    May I know how can I debug the C SDK code using gdb in order to debug both C SDK and Thingworx?  Thank you.

To upgrade, Thingworx 9.2/9.1/9.0 is best? and why?  Does Twx 9.2 have any legacy widgets or entities?

Pleas tell me concretely the processing for text data that TW Analytics can do.

I have data's in a grid as a string type, want to do translate those dynamic data's, but have no idea to do this, Kindly assist me to do this if any options.

I am reading multiple csv files one by one. If one csv file not exists error occurred, the code stopped. Instead i want to move on to reading next csv file. So i tried try catch inside for loop only for ReadCSVFile method, but that doesn't worked. What to do.

Is it possible to set Calendar (select date) to start weeks with Mondays instead of Sundays? Meaning the Sunday column below would shift to the far right.    

Hi, I am on TWX 9.1 and using Line Chart. We have multiple datasources to it. There can be values in datafield for datasources. In service, if there is no data to show, we are setting datafield value to be NA. Because if we don't set datafield value then then chart doesn't get displayed. Could you please tell if there is any way to hide the legend which have datafield value as "NA" Thanks Anirudha

 Hola everyone,   I was wondering weither there's a way to find out how long does it take to run a script inside a subscription ?   Thanks in advance

I have 100 rows in CSV File. I want to replace only one row. This snippet: Resources["CSVParserFunctions"].WriteCSVFile(params2); is not accepting one row as an input. Iam getting an error "JavaException: java.lang.Exception: Unable To Convert From com.thingworx.types.collections.ValueCollection to INFOTABLE ".  1. How to update only one row of csv file?   2. Shall i pass arrays tothe input data?  var params2 = {path: filePath2 /* STRING */,data: rowCSV /* INFOTABLE */,fileRepository: "SystemRepository" /* THINGNAME */,withHeader: true /* BOOLEAN */};Resources["CSVParserFunctions"].WriteCSVFile(params2);