IoT & Connectivity

i've created a service for creating folder in the repository, how can i get the created folder name in the output as string/text? thankskeerthi

I have requirement to find unmatched rows from two tables.Basically need to compare one table data to another table and save the unmatched records from first table into new table.I used intersect to solve this.but getting Unable To Convert From org.mozilla.javascript.UniqueTag to INFOTABLE error.  try {let Status = 'Accepted';let Project;let WorkPackage;let WorkOrder;let Jobcard;let InsertProjectData;let currentuser = Resources["CurrentSessionInfo"].GetCurrentUser();var currentdate = Date.now();  let EIDWData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DWM_ DB_EIDWACTIVITYVERSION_DS"});let DWMProjectData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DWM_DB_PROJECT_DS"}); let DWMWorkPackageData = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DWM_DB_WorkPackage_DS"});let DWMWork

I tried to export the complex tags (advanced tags) created in one instance to other using Export/Import CSV it is not taking the mapped tags within them. How can i get it done with the mapped tags along with complex tag. 

Hello @AB_10607533, we have the same issue you marked as resolved in this thread, we want to read and write inside the address #10095 via the Fanuc Focas Ethernet protocol using the "Open" model. How did you managed to solve the problem? The documentation linked in the answer (link) clearly states that the "#" variables range is limited to #9999: Thank you,Riccardo

Hi PTC, In my thingworx service am trying to query influxDB to get the moving average and the standard deviation of one or more properties. Below is my code: //AggregateFunctions_Inputs is an array of inputsAggregateFunctions_Inputs.forEach(functionName => {if(functionName === "stddev"){//stddevfluxQuery += 'from(bucket: "thingworx")' +'|> range(start: ' + start + ', stop: ' + end + ')' +'|> filter(fn: (r) => ' + Measurements_Inputs.map(m => 'r["_measurement"] == "' + m + '"').join(' or ') + ')' +'|> filter(fn: (r) => ' + Fields.map(f => 'r["_field"] == "' + f + '"').join(' or ') + ')' ;}else if (functionName === "movingAverage"){//movingAveragefluxQuery = 'from(bucket: "thingworx")'+'|> range(start: '+start+')' +'|> filter(fn: (r) => ' + Measurements_Inputs.map(m => 'r["_measurement"] == "' + m + '"').join(' or ') + ')' +'|> filter(fn: (r) => ' + Fields.map(f => 'r["_field"] == "' + f + '"').join(' or ') + ')' +'|> movingA

I have a main grid widget on my mashup and I would like to display another grid widget upon clicking a cell on the main grid the way a popup would work. Is this possible on Thingworx version 9.4?

I have a scenario where I am executing a  child service (inputs: ThingShape, Thing and Boolean) from another wrapper service. Now the child service fails if I pass a ThingShape that does not exist, so I am trying to write something like:If ThingShape Exists :TS = TS_NAMEElse:TS = undefined.How do I achieve this ?I have checked many OOTB services but none help with this.TWX v9.3.4

Hello.I am implementing mashup for a client and he wants to display on screen various bar charts, similar to those  you see in the picture. I used Themable  Bar Chart in Thingworx 9.3I used collection widget, each collection cell has only has this single chart widget.The problem is that client screen has small resolution and I can not allow to widget to have 32px padding. (see picture)Is there a way to remove/modify this two CSS rule (:host{} and [part~="chart-layout"])  from Shadow DOM?Thank you.Illya.

Hi,I am currently working on a project where we want the pageNumber to be controled via a session variable.When for example selecting an item and then clicking back, we want the last viewed pagination page to show. The property pageNumber is updated correctly when switching pagination page. But when clicking an item and back, it is not taking into account the last pagination page,How to solve this?// Oskar Berntorp

Hello, I have a csdk prorgam, i need to search specific element on infotable.I am trying to use the function twList_Foreach(twList *list, twForEachHander listHandler, void *userData) to find and update row on the infotable, but i am not succeeding.Can someone provide me with a sample to use this method please?my infotable contains 4 strings [field A , field B , field C , field D] , i am searching the row where B=='some specific string'if true update the row. Thank you very much for your help  

Trying to fetch the outgoing dependencies of a thing as an infotable  using the GetOutgoingDependencies service in the  PTC.Resource.RelationshipUtilities,  but facing this error : Error executing service. Message ::Unable To Convert From org.mozilla.javascript.UniqueTag to INFOTABLE - See Script Error Log for more details. Here: var thingName =   "sampleThing"var mxItems = 10;var mxDepth = 2;let params = {    target: thingName,    maxItems: mxItems,    maxDepth: mxDepth};    var relData = Resources["PTC.Resource.RelationshipUtilities"].GetOutgoingDependencies(params);

I am looking to use the API's put method to update an infotable property on a specific thing. Using postman I currently get a 406 - Not Accepted with the message being:JSON Content for HealthAndSafetyReport Was Not ValidProperties. When I use the Get method, I get the following response:  { "dataShape": { "fieldDefinitions": { "HealthAndSafetyReport": { "name": "HealthAndSafetyReport", "description": "", "baseType": "INFOTABLE", "ordinal": 24, "aspects": { "isIndexed": false, "isPersistent": true, "isLogged": false, "dataChangeType": "VALUE", "dataShape": "HealthandSafetyReport_DS", "cacheTime": 0.0 } } } }, "rows": [ { "HealthAndSafetyReport": { "dataShape": { "fieldDefinitions": { "Daily": { "name": "Daily", "description": "", "baseType": "STRING", "ordinal": 0, "aspects": { "isPrimaryKey": false } }, "Date": { "name": "Date", "description": "", "baseType": "STRING", "ordinal": 0, "aspects": { "isPrimaryKey": false } }, "Month_

If I am an Administrator is it possible to run a service temporarily on a Thing in a user role that is less privileged? I am working upon a use case wherein the user is not an Administrator. For this I need to keep removing myself from the Administrator's group, check if the mashup/services work, and if they don't request other team member to add myself back to the Administrators group and keep working. I would like to avoid this. Scenario is: 1. User Jack is an Administrator2. When service GetData on a Thing runs it has to do it in a user role which is less privileged than an Administrator3. Jack's user roles should not be affected in any way if this service runs. Thanks,Ashish Tamhane 

Hi,How to merge grid multiple headers into one header in thingworx version 9.4.3? (I have attached screenshot need to do like this in grid please check it) or any other for highlighting same featured headers in a grid like apply same css to the same featured headers? I tried to apply css in 9.3.4 twx version but it's not working for headers.Please suggest me asap.   

How to Reconnect ThingWorx to Kepware?   Translated by the Community Moderation using Google Translate ----------------------------------------------------------------------------------------------- Como Reconectaar o Thingworx ao Kepware ?

Hello! I'm configuring a PLC device inside a local network (a S7-1500 with endpoint opc.tcp://192.168.0.190:49320) and already configured a NAT device to translate the local IP for a public IP at the VLAN (10.10.230.235). From my server I can ping the NAT but when I try to configure it into Kepware (installed at the same server) it doesn't find any available endpoints. I tried also to configure it using "Discovery Server" function. Any ideas in how to configure a endpoint behind a NAT address? Thanks in advance!

I'm currently binding a grid configuration from a service to the Advanced Grid. Everything works fine - except I can no longer see the binding to get the EditedTable.  Please let me know how this can be done? Using version 9.3.4

Hi Team, If data is not available in dropdown and after hitting button need to show status message for it how to do?please explain step by step. It will be helpful.  thanks.  

Hi everyone, I am using a service which is calling windchill data and then storing it in thingworx local database postgres sql now I want to automate this service on a specific interval so that it will automatically execute after a certain time what I am thing is using a scheduler thing template but not sure how can I implement it and the Thing  on which this service is present already using database template so I can't use two template in a single thing  so please give me a  better understanding if anybody's have any Idea. Thanks and Regards,Lav.

Hi ,  I created a  custom script function called GenerateUid.  This function generate a unique id(Long type) for every call using the snowflake id algorithm.      It works in the backend of the extension, I can see the unique id is generated correctly in debug.  However,   the last two digits  of the value returned to ThingWorx is always "00".  For example,  the generated id is 569467214119305221, but the value in ThingWorx's service result is    In debug you can see the uid is 569467214119305221.   but in ThingWorx it's 569467214119305200 ===========Version ========== ThingWorx 8.5.5 Database: Postgresql 10.x OS: REHL 7.6   ======================================Update======================== I changed the return type from LONG to STRING and everything works.  so there must be something wrong for LONG ?    Regards, Sean

Hi,I am trying to figure out how to display an external webpage in thingworx. I am trying to use an expression which then outputs html as a string of an iframe, The output of that expression is bound to the data property of the value display. I have also tried to enter the html into a textinput, But the value display will only display the raw text and not the page which should render. The value display is set to render the data as html. Am I doing anything the wrong way, if so please advice me how to do.KindlyOskar Berntorp 

In Thingworx 9.5 there is one feature of "RowSelection" that  is bindable.I want to control the grid property from none selection to multiple selection through this  Upon clicking the button, I pass the result as 'Multiple' to the RowSelection grid property and reset the grid on change. The issue is that I am unable to switch to multiselect.  

Is it possible to get a list of all bound properties and their source and VTQ on a Thing by executing a service? Ideally I would like to monitor bad endpoints and create some notification to help track and fix any problems. I have tried the getBound Items function with no success, even though I have quite a number of properties bound on my thing.

When selecting the data of the grid using the mouse, random data is unselected as can be seen in below image:  Can anyone suggest how to fix this, as the requirement is to select and copy the grid data.

Hi, I had try to disable timeout session by enter 0 in value ..... ( SetPlatformSessionTimeout service in User Management Subsystem )But  now, I loose access in Composer and Runtime  😞 Who I can reset 30 minutes ?