ThingWorx

Hi, I have created a services in database for updating the data of database table,  from data table, but it is not updating the integer data in database table, following is the service details, let table;let variable;let DataTableData = Things["pp_44270_SPC_DataTable"].GetDataTableEntries({maxItems: 1000 /* NUMBER {"defaultValue":500} */});for (var i=0; i <=DataTableData.rows.length; i++){var row=DataTableData.rows[i];table=me.Table_Update1({DataSource: row.datasource /* STRING [Required] */,Workstation: row.workstation /* STRING [Required] */,Model: row.model /* STRING [Required] */,Variable: row.variable /* STRING [Required] */,Value: row.value /* INTEGER [Required] {"minimumValue":1,"maximumValue":100} */,Key: row.key});var result=table;} I will be thankful, if some one provide me the solution. Thanks in advance.

Hello everyone! I have an infotable with data that I'll export as a .csv file. However, one of the fields is a link and I'd like to present it as a clickable link once the user opens the file. Is this possible? For now, the link is not clickable so users have to copy and paste it to the browser to access it.Thank you in advance. 

Hi, I have a service that is triggered based on a different event. The service takes 1 input and outputs an infotable.When I try to bind a dropdown to the output of this service I don't get any option to bind the service output to a dropdown.

Hi,I am using the following snippet, to Query on FieldName Which does not contain the "Test Question" Text in the FieldName Data var query = { "filters":{ "type": "NOTLIKE", "fieldName": "Name", "value": "Test question:\\+*" } }; let params = { t: result /* INFOTABLE */, query: query /* QUERY */ }; // result: INFOTABLE result = Resources["InfoTableFunctions"].Query(params);   Even though I get an INFOTABLE with rows containing "Test Question" in the FieldName "Name"..Where did I do wrong?Note: I have followed Query Parameter for Query Services (ptc.com) and Picked up the snippet from thereThanks,

Hi everyone,  This topic has been discussed before, but we still haven't seen a good solution. When we remove the Users (group) from the composerUsers group, all the Users other than our administrator users no longer have rights within our application. When we follow the case CS341872 then we must assign the rights separately for each Mashup,  Can this be done in an easier way? or through a global solution? Other question:  will there be a secure by design solution in a next release, so that this is no longer necessary. Best regards,Emiel

We have a scenario where we have multiple drop-downs. All the drop-downs are connected with each other in a multi-level hierarchy. All the drop downs are associated with the same Datatable with different fields. For example: we have a Datatable  named DT with 4 fields FD1,FD2,FD3, and FD4. The dropdowns viz DD1, DD2,DD3, and DD4 are binded to the corresponding fields of DT; DD1 binded to FD1, DD2 binded to FD2, and so on..So when we select a value in DD1 from the list of selections, it should filter the values in DD2 based on Selection of value in DD1. Then data on DD3 should be filtered based on selection in DD2, then data on DD4 should be filtered based on selection made in DD3. is there any way to achieve this in a mashup.

I have an error to communicate my raspberrypi with ThingWorx the same as the SSL error but I didn't enable this option how do I get the error out?

Hi all, we are facing an issue when adding a service on a Thing Template.We created a Thing Template which is based on the ODataConnector Thing. A new Thing should use the template by calling its services. So the inherited chain looks like this:Thing Test-TestTemplate-ODataConnector But when trying to add a new service to the TestTemplate and by adding a route, the following errors pops up:We did a lot of research and found some similiar issues, which were all related to missing access rights.So we assigned all groups that were suggested but still no luck:TestTemplate uses ODataConnector  TestTemplate Permissions Visibility  TestTemplate Permissions Visibility Instance TestTemplate Permissions Runtime  TestTemplate Permissions Runtime Instance  TestTemplate Permissions Designtime  TestTemplate Permissions Designtime Instance Does anyone have an idea, how to fix that error? Thanks,Jürgen

guys, has anyone ever experienced this phenomenon:how can i fixed this?

I have a few applications which have heavy queries to read and write the stream data also complex services/mashups as well. Now, We have DB and TWX foundation both in the same EC2 instance.  To reduce the load I would like to move my entire DB to AWS RDS PSQL.  It is good to proceed with this approach or should I create a separate EC2 instance to host my Postgres?Also, We have manufacturing apps in the instance it has custom tables in the main DB.  Changing the stream data to another DB is not helping I tried to use an external DB as ThingworxPersistenceProvider, it is reducing the load but still, due to a load of services and application model postgres service consumes high cpu utilization. 

I tring to study "content crawler" by referring to the following help documents.Content Crawler (ptc.com)When I follow the tutorial step by step,But after I execute the method GetExternalContent(Crawl) , there is no return value. In fact, the Datatable I'm fetching has values. The CrawlerThing and Datatable I created have been uploaded to the attachment,Can you help me figure out what's wrong. Thanks.

Developed a custom extension which is using JCIFS library. While trying to import into Thingworx getting following error,    1. *** Unable to create resource instance in Resource:SMBUtilities 2. Unable To Create Resource Instance From Class: SMBUtilities 3. Unable to process import: jcifs/smb/SmbFileInputStream 4. Unable to delete SMBFileReader:1.0.0. This is likely due to other errors: ExtensionPackage SMBFileReader Does Not Exist   SMBFileReader is a Extention name (Eclipse project) SMBUtilities is Resource name created in Extension Application log attached.   Need help on this issue? How to address this issue?  

Hi, is there an easier way to limit the maximum amount of selections in a list-widget, than to solve it using a service which counts the selections and resets them if they exceed a defined value

Hello, I would like to the items on my menu bar to expand as I hover the mouse over them. please advise! something kind of like this https://www.w3schools.com/howto/howto_css_dropdown.asp  

I have used Grid widget with multi row selection on grid.After doing so if we select multiple rows it does show how many rows we have selected on a grid as a selected rows label.I wanted to hide it or turn it off but not getting any property to do so.looking for any suggestion using which i can turn it off. 

Hi, How can I load an Image from MediaEntities in the Service? Thanks,

Hello Experts,             Application Requirement : To fetch excel or CSV file in thingworx as template, Update cells or rows in file and save with new name ( so that my template will be there for every next operation)  Current Status:  I want to only update excel/CSV file but i am unable to find any solution for same,  I have tried CSV Parser function in thingworx to Read and write file but during write operation it completely overwrites previous data. Please suggest solution for same. I am using Thingworx 9.3.2 

Hi,How can a Z-Index be used in a Responsive Mashup?, Z-Index is commonly used in spacing a widget on top of another widget; how can this be achieved in a Responsive Mashup?Thanks,

Hello,Whe  I started working with ThingWorx Analytics, I learnt a lot from a serie of videos located on Developer portal:https://developer.thingworx.com/resources/guides/analytics-training-videosI cannot find this resource material on ptc community. Did I search in a bad way? How can I find it in ptc community?Thanks in advance 

A previous installation of ThingWorx Foundation for MSSQL has been found. Uninstall the existing installation and then reinstall ThingWorx Foundation for MSSQL. If you are upgrading ThingWorx Foundation, you must first ensure that all prerequisites are met. Do you want to review the prerequisites in the help center now ?

We have installed thingworx 9.1 with postgreSQL using installer. Create more than 50+ entities and done a kind of an PoC. How to cleanup everything and make just like fresh installation instance without uninstallation?

Started developing extension to get image file from windows file explorer.    Created resource Created service [input: imagePath, output: IMAGE] Here how to convert Imge file to thingworx IMAGE basetype?

How to ping Database server using javascript code in thingworx service ?

Hello,In one of my application i want to apply custom font size to the message and button label on Confirmation dialogue box.I am not able to apply it, can anyone help me with this issue?Thanks in advance.

Hi,   I have done the following binding, but still the edited data is not saving in the data base, the binding I have given in the below picture.   could you provide some solution?   Thanks in advance