ThingWorx

I'm sure this has been answered, but I cannot for the life of me find it.   I have a report in Windchill written in Query Builder that I would like to leverage inside of a Thingworx thing.   It takes two parameters partNumber partView   The id is 12345   How do I call this report?   Any help is appreciated!

Hi,      I am installing thingworx 8.4 on top of sql server 2017. After Installation when I go to Composer, message showing as "503 Service Unavailable". So I have checked the Application Log showing message as "message: Unable to initialize and start system: Connections could not be acquired from the underlying database!".      For reference I have attached Application log, platform-setting.json. We are following the document for installation as https://support.ptc.com/WCMS/files/172634/en/Getting_Started_with_MS_SQL_Server_and_ThingWorx_1.pdf. Could you please help to resolve this.   Thanks, Sheetal         

Hello, I have checked this solution, it won't work from my side. Anybody else come up with alternatives?

I want to convert data that I receveid from arduino board via serial to float.When I use ParseFloat on the service that I created on a Shape, i have the following error : >Error executing service. Message ::Unable To Convert From org.mozilla.javascript.UniqueTag to NUMBER - See Script Error Log for more details.   I don't know where I can search to correct this. I only found who has to convert into infotable.If someone know example of similar javascript service on thingworx that are working. It would be very useful for me. In my service, Inputs are string and Output (result) is Number. This is my code :   me.value1=parseFloat(value1);me.value2=parseFloat(value2);me.value3=parseFloat(value3);me.value4=parseFloat(value4);me.value5=parseFloat(value5);me.value6=parseFloat(value6);me.value7=parseFloat(value7);me.value8=parseFloat(value8);me.value9=parseFloat(value9);me.value10=parseFloat(value10);me.value11=parseFloat(value11);me.value12=parseFloat(value12);   Thanks in ad

I have to display grid dynamically(But multiple rows in sql have to displayed in single row in grid). Its keep on change based on value selecting in combo box. For eg: am having this table in sql    Now this "wi_id" in combobox Based on the selection i must diplay this field_name, and field_value. But i must display in a single row. Here number of rows is not fixed. It keep on change    like this. Field_name becomes header, and field_value in rows. (eg: i took wi_id=3)     To get this result :   Get TAble From SQL var params = {WiName: WorkInstrn /* STRING */}; // result: INFOTABLE dataShape: "BOBCAT_SpecifcationDetais_DS_C"det = me.Wi_FieldDetails(params);   Create INfoTAble var params = {infoTableName: WorkInstrn/* STRING */}; // result: INFOTABLEa= Resources["InfoTableFunctions"].CreateInfoTable(params); Add Field NAme for Created Infotable for( i=0 ; i<det.length ;i++ ){var newField = new Object();newField.name = det.rows[i].field_name;ne

I read the advanced grid widget extension documentation and also the other post... https://community.ptc.com/t5/ThingWorx-Developers/Grid-Widgets/m-p/578640  but can't seem to figure out how to get sorting to work with an advanced grid.   What am I doing wrong?  I am trying to sort an infotable and not a datatable.  Please see the bindings below:  

I have two thing templates "Plant Thing Template" & "Department Thing Template". While creation of "Department Thing Template", I have inherited the "Plant Thing Template" as base thing template, to inherit & store certain properties.   Now, I want to get the list of implemented things from "Plant Thing Template" separately and "Department Thing Template" separately. The issue is "GetImplementingThings" of "Plant Thing Template" is returning things implemented by both "Plant Thing Template" & "Department Thing Template"   Can someone please suggest a solution

Isn't the UpdateQuery service supposed to update the infotable passed to it in the "t" parameter?  In this support document, InfoTableFunctions the service description states that the UpdateQuery service will "Update rows that match a query with a provided set of values."  However, when I use it (see the example below), the result infotable contains the updated records, but those updates are not saved to the infotable passed to it in the "t" parameter.  Am I missing a step?   For example: In the code below, the result infotable contains the correct records filtered from the FrameComponents by the query and they are updated properly with the values infotable.  However, the cooresponding records in the FrameComponents infotable are not updated.  What do I need to do to update the FrameComponents infotable?   var query = {"filters": {"type": "EQ","fieldName": "gath_cart_no","value": row.gath_cart_no}}; var params = {t: FrameComponents /* INFOTA

We are currently using the .NET SDK for thingworx. out of a security perspective we are interested in which security-terms are part of the default SDK-Connection.   -Are there Certificates (Which Type/Class) -Is there an internal VPN tunnel used ..   Where can we get such information? At the moment we're asking the question if there is any security point we have to implement or wrap around the connection for our securitystandards, or if the Thingworx connections are safe enough.

Hello Community,   I`m currently using OPC Aggregator on my PC to collect OPC UA data from a server running in a Raspberry Pi. I was wondering if there was an option to run a version of OPC Aggregator on the Raspberry Pi or Linux so I don`t need to use my PC as intermediary.   Cheers

I made a ThingShape "Searchable.TS" which let me get all of my searchable things in a collection widget. Now I want to show a little indicator wether the Thing is connected or not. So is there an option for me to write a Service in "Searchable.TS" which gets the Connected property of the belonging thing?   Something like:   -> Me.GetProperty("Connected")...  

I want to display the selected value from the drop down list on the LED display. I have used the selected item from a List widget, bind the Selected Row(s) from the Service used to populate the List. But still data is not loading in the LED display. How can I get the data to display.  

Hi ,   How can we add multiple recipients(mail Ids) in send message service of thingworx mail Extension?I would like to add 3 recipients in CC  and 2 recipients in to.Please let me know, how a mail notification will be sent to many people at once.

I need to get the timestamp of tags updated in kepware to Thingworx. Using GetPropertyTime() we can only get the property update time in Thingworx rather than the timestamp of Kepware. Is there any way to get values directly instead of running GetPropertyTime()?

I have created a time series chart. The data is created using a python script that I have wrote and is taken via GET method. I am able to create the graph initially but I am unable to update the graph using the 'updateChart' service. I am getting the new data every second and would like to update my graph. What do I have to do to be able to update my time series chart?

Hi all,   I am using the widget OpenStreetMap and always when I refresh my screen, the map's zoom show as:     I would like the view the map with less zoom, for example like the image below:     How do I do this?   Regards, Leonardo

Hi, I have a problem with configuration of Advanced Grid columns via JSON. My goal is to create one editable column, no problem with that.And I also need to capture the values of the selected row.The problem is that when the Editable property is set to true, then row selection does not work. When the Editable property is set to false, then the row selection works very well. My TWX Version: ThingWorx 8.4.0-b2013 Configuration for single selection row: "rows": { "selection": "single", "defaultSelectedRows": "", "minHeight": "20px", "autoScroll": false } Configuration for edition:1. Activation of table edition mode "cellEditingEnabled": true, 2. Definition of cell to be editable { "targets": 0, "fieldName": "priority", "title": " ", "width": "23px", "autoWidth": false, "overflow": "wrapped", "headerTextAlignment": "center", "textAlignment": "center", "hidden": false, "inLayout": true, "columnFormatter": { "type": "integer", "format": "0", "cellEditor": { "enabled": true }

I have a menubar in my header flexcontainer and set all alignmentsettings to "right". But the result is shown on the left end.      Could you provide me some help?   This is in editor                                   And this is the result    

I made a pop-up window which displays an infotable in Mashup. How to return value of the selected field for processing by service, after closing of a pop-up window?

Hi,   I am facing an issue in session parameter , as am getting it empty. I need to pass my mashup name as parameter to another mashup. I am getting seeion as emty as shown below   and when i looked into Subsytem--> usermanagementsubsytem--> it is not running. see the below screenshot.     Please help me to solve this issue? Reply as soon as possible,   Thanks in advance, Sheetal

Hi ,    For a customized widget, sometimes the callback function updateProperty is triggered as my expected, but sometimes not.     I found the following situations that updateProperty will NOT be triggered :  afterRender is empty Div doesn't has nested div/span inside it . for example,  <div class="widget-content widget-helloWorld"><div class="DisplayText"></div></div> works,  but <div class="widget-content widget-helloWorld DisplayText"></div> doesn't work call this.setProperty function in afterRender won't be helpful in the above cases I'm really confused about the behavior of triggering updateProperty , could someone give me a detailed description for updateProperty ?    =============afterRender==================== this.afterRender = function () {   //this.setProperty("BarTitle", 'test');   valueElem = this.jqElement.find(".DisplayText");  &nbsp

Hello,    I have a stream that I am attempting to add entries to by calling the .AddStreamEntries() method. I have tried passing two different infotables - one whose datashape is identical to the datashape on the stream which I'm trying to edit, and one which is defined by a new datashape, where I added the fields for 'location', 'tags', etc (to match more exactly with all stream fields).    Both methods throw a null pointer exception. I know that the infotable I'm passing it is not empty - already checked that.   Any ideas?     Things["MY_STREAM"].AddStreamEntries({values: MY_INFO_TABLE /* INFOTABLE */});

Everyone knows how I can generate an device-id respectively licenceRequestFile if thingworxs is not starting because the licence is not valid any more? We renewed our licence and would like to activate thingworxs via offline-mode because we have a  strict company proxy which we cannot deactivate and ptc don't think about implementing an proxy setting for communicating with the licence-server. Anyone has an idea?

Hello guys,   I'm facing a strange problem.   There is a thing with some properties that have Alerts configured.   If I set manually some of these properties to "TRUE" the event of Alert works and the History populate normally. On the other hand when a service manage automatically the Alerts, the properties change, the Alerts be active, but the history doesn't populate the infotable.   Could you help me, please?   Thanks. Christyam

Hi.   When I try to start the thingworxs plattform it shuts down before even starting with the error:"Unable to retrieve license from FNO server because Connect to fnoauth.ptc.com:443 [fnoauth.ptc.com/52.2.0.42, fnoauth.ptc.com/3.216.245.130] failed: Connection timed out: connect - Shutting down the Platform."   I'm sure this is because I'm behind a strict corporate-proxy. How can I set up thingworxs to use this proxy to connect to the license-server?I know there is the possibility to generate a licence-file manually, but I would prefer setting up the proxy.