IoT & Connectivity

Hi, Added a advanced grid in a Responsive Container, but the Advance Grid doesn't show vertical bar's.Thanks,Shashi.

I am using TWX 9.3.1 , trying to get JSON output thru a JS service using GetJSON/LoadJSON snippet.I checked it thru POSTMAN and it worked perfectly. This is my code:var AuthVal = "Bearer "+token;var ServiceHeader = {"Content-Type" : "application/text","Accept" :"application/text","Authorization" : AuthVal,"maxItems":7000};var url="http://apps-dev.xylem.net/ApisManager/api/MES/Get/BrazedBOM?partNumber=BY568504016017";let params = {headers: ServiceHeader /* JSON */,url: url /* STRING */,timeout: 0 /* NUMBER {"defaultValue":60} */};// result: JSONvar result = Resources["ContentLoaderFunctions"].LoadJSON(params);  and this string output:{"headers":{"Authorization":"Bearer e6c336482a7d4767883c2268bd1836fe","maxItems":7000,"Accept":"application/text","Content-Type":"application/text"},"responseHeaders":{"X-UA-Compatible":"IE=Edge","Server":"Microsoft-IIS/8.5","Access-Control-Allow-Origin":"*","Content-Length":"6209","Date":"Thu, 25 Aug 2022 06:30:00 GMT","Content-Type":"application

I have two infotables parent and child, i want to update the parent infotable rows based on child infotable unique columns. what is the best approach to achive this, tried with UpdateQuery function, its not updating the parent infotable rows.

Hello Comunnity :), I'm thinking how to manage some alerts in TWX and for this I need a subscription. If I've created a subscription in order to send one emain when a alert trigger, if I create the subcription in a thing template, this subscription is gonna be repeated in each thing? So if I have 10 things with this subscrition(any alert) I will have 10 subscription checking the conditions for send one email, for example? So this can be inefficient, It's better to have this subscrition in a external thing? Thank you Luis.

HiIs there a way to get the client screen resolution on Load of Mashup, such that based on it, Mashup made for that particular Screen resolution can be loaded.As we know a perfect responsive Mashup can't be made since there are less Responsive Widgets present in Thingworx, eventually end up showing the scroll bars in the Mashup.Thanks,

Sometimes you have to work with XML in Thingworx, e.g. when processing the result of a SOAP Webservice call.This can be done using E4X, but it's not comfortable to use, especially when there are namespaces involved. Therefore, I took a publicly available (GPLed) script which converts the whole reply to JSON and adapted it to Thingworx. It creates an object from the XML and returns the JSON.stringify representation of it. You can take it and extend it to  your needs. If you know what you need from the reply and E4X, using E4X directly is probably faster, as it does need the intermediate object and JSON creation, but this is much more convenient (you can work with either the object or the JSON). Beware this only works with valid XML, so an error message returned from a failed WS call, which could be HTML will not be parsed.The thing was exported from TWX 9.2 but should work with older versions as well.

Getting Undefined in GetFilters;Followed Below Article to add an Filter Category in the Asset Advisor:https://support.ptc.com/help/thingworx_apps/r8.5/en/index.html#page/thingworx_apps%2FThingWorxAppsCust%2Fadding_properties_and_fields_on_assets_lines_and_sites.html%23@paic @slangley @c_lowy @CarlesCollThanksShashi.

Hi,There are projects that are deployed from one Environment to another Environment by Extension method.1st Env ---> Entities are Exported by Extension type 2nd Env ---> Extension is imported in to the EnvNow these Entities can't be edited, is there any way we can edit the Entities, mainly Mashups... there are few bugs need to be fixed over hereis there any configuration that can be done to edit the entities that are imported by extension in this scenario ?Thanks,Shashi.

Is ThingWorx on-prem validated against MS/Windows patches? If so, is this posted information posted anywhere?

Hi all, I'm using the Menu bar widget for navigation in my Thingworx app. I'd like to implement an "Info"-button into the secondary navigation items of the main menu, which would navigate the user to mashup providing info and help related to currently selected mashup. It would be nice to have this as modal popup over the currently selected mashup.For example in the pic below, user has selected the "Factory" mashup from the Primary Navigation items, and it is open in the view:Now when user clicks the "Info"-button, I would like to have the "Info"-mashup modal over the selected factory mashup in the view area. Is such functionality possible to implement with the current menu bar in Thingworx 9.3.3? I know I can implement it in by including the info button and a navigation function into each mashup, but it would be nice to have it in the master and menu bar instead.  

How to set minimum row height for adv grid widget?

Good afternoon! The mashup needs to be displayed at all times. But with a frequency of 1 week, it steadily stops displaying data or a page with an error opens. It would be possible to configure the update of the tab itself (f5), but in this case, the selected item in the drop-down list would have to be manually selected again.How can I analyze the error and try to fix it?

I am trying to convert json code to xml code. I am getting errors for the following code. Help me to fix it.  js code: try{let JSON = "{College:{entry: [{ Student : 'shiv', Roll_No: 12},{ Student : 'yadav',Roll_No: 56}]}}";let result = OBJtoXML(JSON); function OBJtoXML(obj) {var xml = '';for (var prop in obj) {xml += obj[prop] instanceof Array ? '' : "<" + prop + ">";if (obj[prop] instanceof Array) {for (var array in obj[prop]) {xml += "<" + prop + ">";xml += OBJtoXML(new Object(obj[prop][array]));xml += "</" + prop + ">";}} else if (typeof obj[prop] == "object") {xml += OBJtoXML(new Object(obj[prop]));} else {xml += obj[prop];}xml += obj[prop] instanceof Array ? '' : "</" + prop + ">";}xml = xml.replace(/<\/?[0-9]{1,}>/g, '');return xml;}}catch(e){logger.error("jsCodeToConvertJsonToXml: error is "+e+" in linenumber "+e.lineNumber);}   errors: 1. error is TypeError: OBJtoXML is not a function, it is undefined. in linenumber 3. 2.  

Hi,We have Postgres as an Model DB, InfluxDB as an Time series DB. Will it be possible in a Thing, few logged properties can be stored in the InfluxDB and few on Postgres ?Because we run a retention policy every month for Influx DB, which purges Data on Monthly basis, there are few properties that are getting logged to be excluded from the Purge.So if I assign a Thing with ValueStream of InfluxDB everything gets purged, there are few properties that should be excluded for client data Analysis.Thanks,

Hi, I'm storing less frequent data in configuration table, however when i ty to fetch the data using  getConfigurationTableRow service only one value is fetched that too old value. How to fetch latest value from configuration table. Is there any way that updates value of config table instead of adding more data,Thanks,Adarsh

How to convert infotable datas to xml in thingworx . Kindly tell me any rest call or js code or extension.

how to read and write .xml files in thingworx

Hi everyone. I have created a service that adds stream entries to only a few specified columns if a certain boolean condition is true. If the boolean condition is false then the service updates the stream entry by filling in the rest of the column values. I passed the infotable that holds the values and a current streamID to the updateStreamEntries snippet. This does not work, I keep getting the error :  Invalid number of values provided to UpdateStreamEntry. How can I fix this?

I see that the maximum rows handled by INFOTABLE is mentioned as 500. Can we store more than 500 rows Infotable in a variable? like if we call a service say GetImplementingThings() inside another service which returns more than 500 rows,  can TWx still can iterate through that INFOTABLE variable and carry out rest of the process say inspect  or update a property? What is the best way to handle 

Hi all, I want to reset all the properties of a thing to respective default values, how can this be done? Thanks,Sujith

  I want to push values to child infotables dynamically using nested for loop, in the above code the "infoname" parameter is the child infotable names which are dynamic.  While executing the code i am not getting any issue, but the infotables are showing blank.if i am passing the actual name instead of "infoname parameter" the values are showing in that particular infotable. Is there any way to pass values to child infotables dynamically?

I am logging the service checkpoints using logger.info and calculating the total time using logger.debug functions. But I cannot see these messages in script logs. Where else can I find them?

Hi,I am trying to add rows with new values to a stream.By doing the following:  But I keep getting the error above. Can someone please help me understand what the error means and do you know how I can fix this? Many thanks 🙂

Hi team, I want to change the default tooltip format on the Line chart. We have a requirement where we are using the Line chart as a step chart on Thingworx 9.3 version. The default tooltip is "Wed Mar 02 2022 02:59:16 GMT +0530(India Standard Time), Signal:1", which I want to change to "2022-03-03 02:59:16, Signal:1". I came across the Localization tables in TW where you can customize the tooltip. By following this link https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/CreatingCustomChartTooltips.html I created a new token, now I am getting "Signal:1" on the tooltip, but I am not able to understand how I can customize the Timestamp. The default token is "${label}, ${series}: ${value}".   Thank you!!

Hi , After clicking on upload button, Is it possible to disable the Upload button available in file Upload widget.After successful file Upload , Upload button should be Enable.  Regards,Hareef