ThingWorx

So basically i have a service which takes some ID (Number) as input and gives the details of that specific ID. The given details of the output parent infotable are:numberdeeplinkrelatedIssuesownercreatedDatedaysOpentargetCloseDate So this "relatedIssues" property is another infotable which has another infotable as a property called "fieldData"and i want to pick the property "CreatedOn" of the fieldData infotable and compare it with the "createdDate" property of the parent infotable. And parse it to have the difference as an output of the service alongside to display it later.   

Hello there, I try to make a Infotable from JSON, I have already see some example, every time I try to do this I have error that thingworx told the JSON is Null. I dont know If I am doing something wrong or if is error in the Thingworx platform. The code is: // Function to check if a key exists in a JSON object and return its value function check_value_yt(input_json, key){ // Initialize return value to 0 var return_value = 0; // Check if the JSON object is not undefined if (input_json != undefined){ // If the JSON object exists, assign the value of the key to return_value return_value = input_json[key]; } // Return the value return return_value; } // Function to check if a key exists in a JSON object and return its value as a float function check_value_mtd(input_json, key){ // Initialize return value to 0 var return_value = 0; // Check if the JSON object is not undefined if (input_json != undefined){ // If the JSON object exists, assign the value of t

Hi, All I have queried influx db and got min, max and other aggregate functions for some properties. I am however in need of figuring out how to query influx in order to get the standard deviation for a property's history. Does anyone perhaps know an article that I can reference? If so please drop the link in here. Many Thanks.

I want to handle multiselection in grid on a click or somethingThis property is bindable, but I am unable to use it properly. The issue arises when I input 'Multiple' through the expression; the grid does not transition from normal to selection mode.

 I tried to develop 3Decharts on thingworx using Eclipse, but it failed, and there is no detailed tutorial on the internet, or is there any other way to make 3D pie charts in thingworx?

I need to change the heading of Custom Task Collection to some other name, how to do that? 

How to show File uploading status popup while uploading a file using file upload widget. Note: i'm using TWX9.1 so in the File upload widget there is not Upload Start event in it. Please suggest some workaround for this.

Hi All,Suggest some deployment activity from Dev environment to prod ENV. for best practices with out solution central.due to local instance need for best practice to follow the process for the deployment.Assistance required.Thank you advance.Regards,Hareef.

Hi,   I want to restrict the User from choosing a future date. For example, today is 24-08-2023 1:00:00, and the User shouldn't be able to select 25-08-2023 1:00:00. All the future dates should be disabled for selection on the Runtime.   I have restricted the user from choosing the future date by giving the value to the Max Date but the user can select the time 2:00:00 from the widget in the Runtime. How can I limit it? Thanks  

I am attempting to import GitBackup Extension into my Eclipse IDE, however I get errors during the import process. Here is what I'm doing:When closing this window, the project does show up in my package explorer, but I seem to be missing functionality (can't add other JAR resources). 

I am looking for a way to use a tool to create the ThingWorx docker containers. We use Azure DevOps on Prem, and I am wondering if there is a way to load all the files from the thingworx docker download, put the needed files in the staging folder, and then build the docker container and push it to a repository, so multiple instances of ThingWorx can download the latest container.  Thank you! 

Hi,We have been  encountering significant issues in executing RSU even for 100 assets in the field . Every time we attempt to deploy RSU to the field be it 100, 200 or 500 assets , the ThingWorx application hangs and need to be restarted.  There are times, where in order to purge the RSU , we had to reboot the DB Server. So the RSU functionality within ThingWorx is pretty much non functional at this time. Our set up is as follows. Apart of standard TWX installation, there is a external DB  where the files from the assets from the field are written to and also TWX  crypto extension which makes a call to Crypto tool to decrypt a file .The TWX version is 9.2.11PTC Support recommended quiet a few configuration changes.  Some of them are ,1  Even thread subsystem - Increase the event threads to 100 2. Increase the max DB connection from the to the TWX DB to 100 3. Increase the external JDBC connections to external DB to 250.4. Changes to SCM

Hi Community,   Can you please let us know how to initialize default values for Edge property with Base Type : Infotable and set values later in LUA script?   I have initialized EDGE property in LUA by following the syntax below. I could see the property "MeteringApplication" on ThingWorx platform and could successfully do remote binding. However, post binding, I was not able to see the default value being populated on the Sub-property "StatusMessage" as per syntax below: dataShapes.MeterReading({ name = "Temp", baseType = "INTEGER" },{ name = "Amps", baseType = "NUMBER" },{ name = "StatusMessage", baseType = "STRING", aspects = {defaultValue="The meter is currently offline"} },) properties.MeteringApplication = { baseType="INFOTABLE", pushType="ALWAYS", dataShape="MeterReading" } So, I would like to hear from you how to set Default values for Infotable as baseType on Lua and how Get/Set Sub-property values under "MeteringApplication" property during later point of time to pe

has this been implemented actually ? I tried it out but its not working .Even i tried by removing the 404 handling code from web.xml still its showing status message . Is it actually dependent on entry in web.xml ?

How to create Database ER diagram. Which is change with change in database connection. 

In kwpware quality tag of all properties showing bad but  in my thingworx remote thing whereI bind the properties it shows quality tag  for all properties good also to my local thing it shows good. I remove the binding of all properties and again bind the all properties still face same issue. How to fix this issue.

We have created 2 Edge Things (EdgeThing1 and EdgeThing2) that have auto-binding names in config.json as *EdgeThing. Each Edge Thing Template has Task code set to run at different intervals. However, we notice that only one of the Tasks runs while the other never runs even though both Things report as connected on the Platform. How can we fix this?

I would like to access the NFC of a mobile device from thingworx running on Mobile.How can we achieve this scenario?

Hi Community,We need to provide an FTP secured connection details to our client for ThingWorx Flow solution. I am referring following PTC documentation for same : "https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Integration_Orchestration/FTP/FTPConnectorTypes.html#" Here in step 6, secure list we get following options: 1)false2)true3)control4)implicitCan someone please explain me difference for these parameters.   Thanks,Sid 

Hi  @VladimirRosu_116627, I installed the extension in ThingWorx (version- 9.3.1) which is available under Build section from the github link you shared (in topic) and tried to execute the services - GetLastMessages, SendMessage with the following configuration: but the result is, ErrorCode(6bbd1442-4b7b-4b88-ab6b-125feb8812e2), Cause(null), Reason(Access was attempted on a null reference variable.), Possible Resolutions(Remove the reference to the null variable within your extension code. Note: ActiveMQ is up and runningCan I get any help to resolve this?

Hi! im new to thingworx and we are trying to create a drag and drop planer for or production with machine integration. Is it posible to code a ui in js and use thingworx for the backend or is it posible to make somthing like this in thingworx. we want to be able to se what is producing in the macine both art:nr and amount.and plan whats next and whos responsible for the machien via drag and drop like a canban board. has anyone done this or have any tips and trix on how to do this

I Want to set group name programmatically through service of Resources->InfotableFunctions-> Services->TOJSONI need standard service code to do programmatically. Please check the below screen shot   

Hi community, I am trying to visualize in a grid or in a text field the data info after having clicked on a data point on my combo chart. (Chart Type = Line).I have already bound the selected data from the chart onto a grid, But I only see the datashape of the service on the grid instead of seeing data that I have selected. Does someone know how I can go about this? Regards, 

I have used a validor to check textfields text are empty or not and if not empty then i am executing a service because validator will return TRUE otherwise i show message with status message FUNCTION to show that please enter the text into fields but it is not working. if i normally write output= true or false then only it works. can anyone please guide me in this regard. I have put a screenshot of bindings and my parameters also please have a look into it. I am using Thingworx 9.3          let Output = true; // Initialize Output as true // The isValid function should accept a single parameter to check. const isValid = (param) => { return param !== null && param!=="" && param.trim() !== ''; }; try{ // Check each parameter individually if (!isValid(emailAddress)) { console.log('Invalid email address'); Output = false; } if (!isValid(firstName)) { console.log('Invalid first name'); Output = false; } if (!isValid(lastN

I have a service takes infotable as an argument and gets some data in the form of a datashape infotable for a piechart which are just 2 counters "open" and "closed" being displayed on the pie chart.This is the code for the service for a better understanding: let result = DataShapes.ex_NumberWithLabel_DS.CreateValues();let buckets = {  OPEN: 0,  CLOSED: 0};let localizationstate = Resources.RuntimeLocalizationFunctions.GetEffectiveToken({  token: "ex.mu.disposition.IssueState.CLOSED",});for (let i = 0; i < objectData.rows.length; i++) {  let row = objectData.rows[i];  if (row.workflowStatus == localizationstate) {    buckets.CLOSED++;  } else {    buckets.OPEN++;  }}result.AddRow({  label: "Open",  value1: buckets.OPEN,  DisplayField: Resources.RuntimeLocalizationFunctions.GetEffectiveToken({    token: "ex.mu.disposition.IssueState.OPEN",  }),});result.AddRow({  label: "Closed",  value1