ThingWorx

Hi all,   I'm trying to reduce the height of the text-field widget, I'm not able to reduce it below 34.   Is there any way to control it using CSS?   /VR 

 Unable to Invoke Service <service name>on <Thing Name>: Execute Query failed: org.postgresql.util.PSQLException: ERROR: procedure public.<stored procedure name>(character varying, character varying, bigint, bigint, character varying, character varying, double precision, double precision, character varying, double precision, double precision, character varying, double precision, bigint, bigint, double precision, bigint, bigint, bigint, character varying, character varying, character varying, character varying, character varying, character varying, character varying, bigint, character varying, integer) does not exist Hint: No procedure matches the given name and argument types. You might need to add explicit type casts. Position: 6

Hi Team, I'm trying to put a tooltip to navigate button but failed. the property is the below. is there any needed configuration in addition to the text setting ? 

Iam using same thingworx version 9.2.3-b189 in two different servers. In one server iam able to pass datepicker data to string input in service and iam getting proper output. But in another server, the output is undefined. why??

I developed a packet to send by HTTP and method PUT a valore for properties inside the object on Thingworx.When the sent is completed in Thingworx stay the connection open.Why that in the package I closed all services used. 

II migrated Thingworx 8.4 with add persistence provider influxdb on thingworx 9.2 (with same add persistence provider). If I define in the new instance one Values Stream present in old instance (same name) is it possibile to referred at the same data present in the Value stream of old instance.

Hello folks, I have an EMS running on a docker container with ubuntu. With the help of the Lua script two parameters are read (CPU frequency and temperature) and then shared as remote properties with Thingworx. Then i added a value stream to display the historical data (queryPropertyHistory).My problem is that no history exists. I am also not sure if the values are really updated. The timestamp is always the same (timestamp= start-time Lua service). When I press "save" on the remote thing, the remote properties are reset and after a short wait, new values appear. However, the timestamp remains the same. I found a post in the forum where another user had a similar problem. (Raspberry-Pi-EMS-Value-Stream/td-p/603659)  After editing my utils.lua as described in the post, I get at least a new timestamp/line after "saving the Thing" on the queryPropertyHistory. I need a correct ValueStream with all historical data. Attached is my template.lua-file, the lua.log

Hi,   Which service in ThingWorx 9.2 is used to convert image into base64 code.   Please share the snippet of reading the image from repository and converting it into base64 code.   Thanks in advance.

Unfortunately if we deleted any entries or modifies any colums in a entry in datatable means... how to retrieve it back? any option is there? please let me know.

Hello all, I am working with ThingWorx Analytics 9.0 and I want to perform a Signals analysis. My dataset is a time-series dataset and my goal variable is from type ordinal. My question: Is there a possibility that I can perfrom a signals job with this dataset? Thank you already in advance. Kind regardsDavid Falkenstein

 Hello , We can read the csv file from the thingworx csv extension. Is there a possibility to read the excel having multiple tabs by specifying the sheet name or something..?  . What is the best way to read excel with multiple tabs.   Thanks!!

Hi Folks,   I came across a requirement to Edit grid row and meanwhile it should be selected as well but thats not working when using Advanced Grid. Once isEditable property is checked, SelectedRows stops working and viceversa. I want to make grid Editable and row should be highlighted while editing. Also the selectedRow should also be used as an input for a service. If anyone figured out any workaround for this, do share your ideas.   Thingworx version: 8.5.6.b110   TIA.  

I am trying to execute following SQL query statement in MSSQL with Thingworx. SELECT [C1] FROM [Table 1]UNION ALLSELECT [C1] FROM [Table 2]; Getting following issue,Execute Query failed: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'allselect'. But its working without "ALL"

Hi everyone.   I want to access fanuc's mongoDb and get data. Do you have a Solution or Example ? Or can you tell me how to do it?

Hi, have you reached a stable solution for the connection proposed by the this user last year? Are there some documents/guides about the possibile solution? Many thanks

Hi ,I require to get the source template of a property in thing level. Can you help ?

We have developed an Custom Extension for Thingworx for adding Tables in Excel sheet, in eclipse (Java). How to add Charts (Pie-chart, Bar-chart, Line-chart, etc.) in the same excel file?    Is it possible to export charts from Mashup to excel?orIs there any library(xssf) available in eclipse (Java) to generate pie chart directly by providing input data? Please share the sample examples if available for the same.please refer the following screenshots, I want this kind of result :  

How remove additional spacing between two containers in mashup?It seems around 5px spacing is there between responsive container. Is there any CSS or anything available to avoid the additional spacing?

I want to display a data which is dynamic with respect to Rows as well as Columns. So, I have chosen collection widget to implement this UI.1. Developed parent mashup which repeats in a Row. (Dynamic row)2. Each row having its own columns So, it is having nested collection widgets.(Dynamic columns) Sometimes, UI completely frozen. Not able click or change anything.Any best practices to implement nested collections? 

Hi, I'm having infotable which dynamic with respect to Rows as well as Columns.  And I have to update multiple times by clicking each cell value. What is best way to display,1. Grid 2. Collection ( dynamic with respect to Rows and columns so 2 collections). Regards,Sathishkumar          

I want to send mails with email type usernames and normal usernames.   To be able to send emails with 'name@domain.com' type of usernames, I followed the next article:   https://www.ptc.com/en/support/article/CS297478   However, now I cannot send mails with 'name' type of usernames.   Thanks, Mikel

I see in custom CSS ,@import (url ) be used to add a css file from repository ? is it also can be used in Thing's service js coding, to import 3rd java scripe modules

I had writter a service in the thing,I had use md5 function to hash my json data and post  to another http api,but I do not kown how to use md5 in the thing service with js.Anyone  please help me Thanks

Hi, In the latest release of ThingWorx 9.2, is the timezone issue resolved? In the previous versions the time would always show the local system time instead of time in which the application is installed. Is that issue resolved?   Thanks in advance, Shalini V.

Hi, We have 2 questions regarding the logs in ThingWorx. In the thingworx foundation stderr logs, its returning all the logs from info to error. Is there an option to log only errors in the file?      2. How to break the thingworx stderr & stdout file based on date or size? Because right now everyday logs           are logged in the same file unless it the tomcat service is restarted.   Thanks in advance, ShaliniV