ThingWorx Developers

Hi, I am new to ThingWorx Environment. I did some research on TW Community and based on that I Configured my DATA FILTER Widget. I put the following codes in my Service: var params = {t: Things["SQL_Connection_Testing_DB_Udit"].sql_Output() /* INFOTABLE */,query: Query /* QUERY */};// result: INFOTABLEvar result = Resources['InfoTableFunctions'].params.query;   Till now my assumption is that the Query from Data Filter widget will pass on to the input Query of my service and that query in turn will execute the DataTable which I provide under "t" Variable.   But somehow I am getting the following error : Error executing service Service101. Message :: TypeError: Cannot read property "query" from undefined - See Script Error Log for more details.   i am guessing, i am doing something wrong with Service query part. DO I need to write any more query than what I mentioned earlier, If yes, Please help me with what kind of structure the query should follow, Considering I want fil

Hello all, I am looking for Search feature for Tree Widget .I have list of assets falling under Network Connection which I am trying to show in the form of Tree widget.I am able to display the List of Assets in the Hierarchy for Tree but faced Issue while searching a particular Asset.So, for search functionality I had added the textfield  widget which has input parameter of  AssetName coming from my service.My service works properly if able to showcase in Grid but while searching for Asset in Tree Form , asset doesnot show up properly. I am attaching the screenshot for the Issue faced along with the service used. Inshort,to explain I am looking for the feature which is already available in "Networks" section for search In Thingworx Composer .Please let me know if I had missed out something for Tree Widget? Can anyone please help me with this usecase. Thanks In Advance !!

dear expert  I created multiple DynamicSchedulerThing, but through single services. How to implement on multiple dynamic schedulers? i need java script code for above   

The "Properties and Alerts" tab of the Database Thing Template lists "isConnected" property as derived from GenericThing.Also, when listing properties of an inheritance hierarchy, Thingworx will only list them all (wrong) as derived from the parent.While function of the inheritance mechanisms is not affected it is clearly stressful and needs to be fixed to enable communicating the layout to your colleagues.Affects at least V 9.1.8 Can I use some workaround to get a clear picture of existing ThingTemplate assets without having to inspect them one-by-one? The "Properties and Alerts" tab of the Database Thing Template lists "isConnected" property as derived from GenericThing.Also, when listing properties of an inheritance hierarchy, Thingworx will only list them all (wrong) as derived from the parent.While function of the inheritance mechanisms is not affected it is clearly stressful and needs to be fixed to enable communicating the layout to your colleagues.Affects at least V 9

I was trying to insert some data into a table that had a UNIQUE key constraint on one of its columns. The purpose of the constraint was to ensure that no two rows in the table had the same value in that column. However, when I attempted to insert the data, I received an error message that said:  "ERROR 1062 (23000): Duplicate entry '123' for key 'my_key_constraint'"  This error message indicated that the UNIQUE key constraint had been violated because there was already a row in the table with the same value ('123') in the column covered by the constraint. As a result, the insertion failed and the data was not added to the table.At first, I thought the problem might be with my SQL syntax or my data formatting, so I checked my code and my data carefully, but I could not find any obvious errors. I search online and read about the specific problem with unique keys from here but couldn't get through it.I also tried to insert different data with unique values, but I kept

Hello Community :), My question is the next: My use case: I have one temperature sensor that send to me data each hour and I receive 4 measures (1 each 15 minutes) in order to have a correct implementation I use the fuction AddNumberValueStreamEntry to record the historical values (the measures in the moment that the device record they) with the correct timestamp.How I can generate one alert if from the sensor I receive historical values? One of  the methods that I thougth is uncheck the logged type property and to have only persist checked, set the data 2 times:1. Things[deviceName].property = valueProperty; (JUST TO GENERATE THE ALERT)2. Use AddNumberValueStreamEntry  (To record the values with a correct timestamp)but the problem is that the alert is not going to have the correct timestamp. Exist any solution in thingworx to do this? Anybody had this problem and can help me? Thank you in advance :), Greetings. Luis.

 

As per the Original Post.      hi expert   I need sent mail  how do write script , event how to add please structure of program

Can we change the color of the scroll bar in mashups? If so, please suggest?      

Hi guys,I try to install thingworx foundation, but close to ending process appears error popup " there has been an error. fundation instalation Failed the application wil exit now"Windows Server 2019Fundation vr: 9.3.8Java :11.0.12RemoteMSSQL 19.02  

dear  all expert  i plan to multiple users  dynamic scheduling every user separate scheduling time how to implement. i have done for single user   email sent massage scheduling. but how did multiple user and dynamic scheduling  email sent .      

Good day community, I have some alerts with limit values on the template levelShould the user need to change these limits there is a service that dynamically changes the alert limits for a particular thing.Therefore the alert values on a thing level are overwriting the template values (which is fine). These alerts do get fired. However after getting fired they are mean to execute subscriptions, which is not happening. The alerts are not executing the subscriptions that listen to the alert property.  Has anyone come across this issue before? Do you know why the subscriptions are getting ignored? Regards,  

How can I transfer documents automatically from Thingworx application to a windchill application and delete the document afterwards from thingworx? Is there an API I can use for it or any other available code? Thank you in advance! 

diffviewer widget was very useful in gitbackup extension to see differences between different commits. Now it's not available. do we have any alternate approach/widgets to see diffs between commits ?

I have an infotable (from SQL query and processed in JS) in which one column is "Serial number" which sometimes has pure number data type and sometimes it is alpha-numeric. and hence the column values is converted into varcharWhen this infotable is provided to "DataExport" widget, it downloads a ".csv" file, which shows the "Serial Number" column formatting as "General" and hence the pure numeric values displayed as "2.303036E+13".Where as it should show something like 2303601000059.I tried the filed definition datatype as "Number" as well as "String", but getting the same result.Please suggest a solution on this.Please find the screenshots below.Thank you  

Hi, My application log is filled with these errors. Not sure what this is. Can someone help me out with this?   2023-02-01 07:54:30.175+0000 [L: ERROR] [O: c.t.p.i.InfluxdbDataExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: pool-63-thread-5] [2,002] No connection. Contact the administrator. 2023-02-01 07:54:30.375+0000 [L: WARN] [O: c.t.p.c.ValueStreamEngine] [I: ] [U: SuperUser] [S: ] [P: ] [T: pool-63-thread-5] Entries persisted successfully after retrying 1 time for 10203 milliseconds.   Thingworx Version: 9.3.4 Database: Influx DB   Thanks,    

Hi All,I have recently installed Thingworx 9.3.7 on MSSQL 2019 with DB name as ThingworxHome as a persistence provider.Also I created 1 DB thing on same as ThingworxExt to test sql queries from platform. I am not able to establish connection.I am sharing details as below along with screenshots: JDBC Driver Class Name : com.microsoft.sqlserver.jdbc.SQLServerDriverJDBC Connection String : jdbc:sqlserver://127.0.0.1:1433;databaseName=ThingworxExtconnectionValidationString : SELECT NOW()Database User Name : TwadminPassword : 123xxxAny suggestion to track and trace how I can confirm all my settings are correct or not. Thank you in advance,Sid 

Hi PTC Developer team,I am looking for example code of how to connect to IFS Cloud where I need to use OAuth 2.0 Client from ThingWorx Platform. (I would like to find a way without using ThingWorx Flow)  Steps I like to perform:1. Connect with OAuth 2.0 from the platform (looking for example code).2. Extract data using the REST enpoints (this we have already done in postman and will be able to use in TWX when the auth is configured).  Link to IFS Cloud documentation: https://docs.ifs.com/techdocs/22r1/030_administration/010_security/005_security/030_authentication/#bearer_token_usage 

Dear TW community We would like to connect a smart torque wrench, which can send and receive torque values, to thingworx.If you could can share know how for any of these issues, we would be very grateful:What are the options for connecting these tools (Kepware or direct to TW)Which products are available?Does someone have experience with connecting torque tools?Best wishes Alex

Hello Community, As I have started working more with permissions in Thingworx recently.I was wondering how other people in the community use permissions when setting visibility or disabling widgets in mashups. My current thought is to set some different session parameters when the master mashup loads like;Master loads -> SetGlobalSessionPermissions The service SetGlobalSessionPermissions could look something like this:const userGroups = Resources["CurrentSessionInfo"].GetCurrentUserGroups(); const isAdmin = userGroups.rows.toArray().find(e => e.name === 'Admin'); if(isAdmin) { Resources["CurrentSessionInfo"].SetGlobalSessionBooleanValue({ name: "IsAdmin", value: true, }); } const isViewer = userGroups.rows.toArray().find((e => e.name === "Viewer")); if (isViewer) { Resources["CurrentSessionInfo"].SetGlobalSessionBooleanValue({ name: "IsViewer", value: true, }); } Then in any mashup we could use these session parameters to set visibility or

I use logged property functionality to save history change of the value, very fast to use.On the advanced settings it's possible to set the "data change type" (and thresold if needed) is it possible to disable the "automatic" logging, but trigger it with a service call? It would really useful for example to save the value every 1 hour (timer subscription+service_call), but keep the current live value to change normally. This would save unnecessary data logging ... because for historycal analysis may be a point every 1 hour is enough.

Hello community, I have a use case where the users wants to be able to export an asset structure using either the export widget or by sending an email. In the end for both options I will create a CSV file. From the export widget and from the WriteCSVFile service to be able to attach it to an email. The issue is that I have structures in several different languages.Portuguese, Swedish, French and others. What I noticed was that out of the box, both the export widget and the WriteCSVFile service provide quite strange encoding for some languages: "Associação" for what should've been: "Associação". I found this PTC support article which provides a fix for the export widget by using the "IncludeBOM" option of the widget. However, I can't seem to find a way to do the same with the WriteCSVFile service.There is some setting that is described in this PTC support article.But I don't know if I can or should use UTF-8 for everything as some languages doesn't play w

Hi all,This question seems super basic but I still don't quite understand the significant difference (e.g. in using) Display Field, State Field, Value Field in Drop Down widget.Thanks in advance!     

dear expert   ThingName already exists or not how to find any services , any script share   requirement: I write JavaScript code ,how to compare already  thingName present or not   

Hi,I have been following article https://community.ptc.com/t5/IoT-Tips/Connect-Azure-IoT-Devices-Part-1/ta-p/833021As per article version of HubConnection Extension should be azure-iot-hub-adapter-extension-4.2.0.4 but I found for thingWorx 9.2 has version "Thingworx-Azure-IoT-Hub-Connector-4.3.0.3". I also notice that azure.iot.conf (below) has just 3 properties but article has 10. I dont know from where read value for "hub-thing-name". When I run "azure-iot.bat" I get "java.lang.RuntimeException: Unable to connect to platform" error.Please help to point to most current article/lab or fix existing one. cx-server {protocol {file-upload-events {// Should the receiver for file-upload notifications be started?enabled = true// Name of the Thing (using template AzureStorageContainerFileRepository) which is associated to the storage container// linked with this IoT Hub (within Azure Portal: Hub > File upload (under Messaging) > Storage container).//// This thing doe