ThingWorx

I have data in a table (Datatable) and want to modify one record.AddOrUpdateDataTableEntries service creates me a new record , instead of modifying the old one. 

What is the best practice way to create/design external database tables and columns in Thingworx? BR/ Simon 

How to change Advance Grid Columns Names dynamically in thingworx

The text field widget used to have an auto focus (built into it I assume?). This was how it worked in 9.1.1. We recently upgraded to 9.3.2 and it no longer auto focuses. We looked for a way to resolve this but cannot seem to find one. How do I get the autofocus to work again for this widget? We have popups that need this functionality.

As per the original post.      Where is 'Title' in the Master? 

I did chip-data-filter to adjust it into the Grid-table, though, it does not displayed the value of any chosen condition, and here is the code written into the service as display the info-table drag to the widgit chip-data -filter and it return to the query parameter: workItems = Resources["InfoTableFunctions"].Query({t: workItems,query: query }); so anything could add or edit to display the value to display it at the Grid Table    

Hi, I tried to edit cell in Tree Grid Advance in Thingworx 9, but it is not editing.   I will be thankful, if someone provide me a solution.   Thanks in advance

i have problem with long text and want the grid to trunc the view and give full string on tooltip. but when i set the overflow in grid configuration to elippsis, it still too long (making it double lilne) until the data trunc itself. and even then, the tooltips got same trunc as the grid itself. anyone can help the problem ? this is the config."targets": 6,"fieldName": "brand_name","title": "Brand Name","width": "200px","autoWidth": true,"overflow": "tooltip","headerTextAlignment": "center","textAlignment": "center","hidden": false,"inLayout": true,"columnFormatter": {"type": "string","format": "full","cellEditor": { // optional: defines cell-editing options for this column"enabled": false // *{boolean} to indicate whether cell editing is enable for this column}}}

how to provide visibility permission to all media type entity? If I have n no. of media type entities and I want to provide my test user to have visibility permission to all the existing media type and new media entities.what will be the ay to do this?  

I have ptcsdatepicker version 9.3.8 with Date Range enabled, when the control is loading in a mashup, i want to have the start time as "00:00:00" and end time as "23:59:59" as default. But I dont see a property available to set a default value. Can you please assist with it? (sharing a code snippet is much appreciable).     

Hello, I have noticed some strange behavior in our collection widgets on the 9.1 version platform. We have a collection widget that contains a collection widget which in turns shows a mashup.This mashup contains a label and a button which will show different things depending on the service data.The issue I am facing is that if I scroll the outer collection widget horizontally. The data in the inner collection widget "moves" to different collection parts:You can see here that the dates have moved from 1300S to 1200S.At times the circle also moves to different collection parts. Has anyone had similar issues? I haven't been able to test this on 9.3 yet, but will try to do so in the near future. Thanks,Jens  

Automatically export to PDF/Excel report. Not able to generate PDF reports like SSRS and other reporting tool.Also, unable to export pie chart /bar graph or analytics dashboards to pdf neither excel/csv.Many life science -GMP compliance use cases where PDF report is must, not allowed CSV or any editable format. Request you to consider this point for development.           

Ptcs-ChartLine widget not loading completely on initial data load. But when i try to load by giving next set of data it is loading. Can any one help me to solve this

Hello I would like to create a half progress gauge, using the standard gauge widget by changing the properties and style. Could someone please tell me how I could create a gauge widget that looks similar to this:Or this:  This is what I have so far with the standard gauge widget, and I am not sure where to go from there: Thank you in advance. 

I would like to add button Confirm / Reject for users as to be implemented service : createButtonHTML for creating HTML with button for user action:1) the created HTML should contain the button elements2) Also inline JavaScript for Calling: "CompleteWorkItem" service please I need guidance on this since it is my first project in ThingWorkx   

Good day community, I have an issue on my mashup.On the Line Chart widget you have the option 'ShowDataLoading'. If this box is unchecked then:In ThingWorx 9.4.0 when the data refreshes the chart flashes, which disrupts the view of the chart.However, In ThingWorx 9.3 when the data refreshes that chart is not interrupted and the new data is just added in, this is definitely preferred over the screen flashing in 9.4.Can this be changed back to how it use to be displayed in 9.3?I am not sure if this issue occurs on other chart types. There were changes in 9.4 to the loading icon and error indicator, maybe this change effected the do not show data loading option. It appears as if the loading icon has a white background, and this background is still shown even when the loading page is not meant to be shown. Best Regards. 

Hello, I have the following error (JavaException: com.thingworx.common.exceptions.InvalidRequestException: Language preferences can be changed only by the user or an administrator ) when trying to change the language of a user. The service is in a thing for which all users have visibility but only the System user has permissions to run it. How can I solve it? 

Hi Community Experts,I have a requirement to integrate Thingworx application with AVEVA ERM 17.1 to fetch manufacturing job related details. With client we got information that currently it exchanges data via file transfer (for eg csv/xml) to other systems. Now we have proposed for thingworx solution. Just wondering if anyone has worked on such integration before and is there any better way to read/write data to our thingworx application.Any leads would be really helpful. Best Regards,Sid

Hello Team,I have a requirement to render pdf document in Thingworx Foundation 9.4It should have ability to edit pdf document and add comments. Can anyone please help me for same.I do know about web frame widget but it is displays url instead of actual pdf content so not able to go with this.Can anyone please help me for same. Regards,Sid 

Hello community. I would like to have a progress bar as a column in a grid widget based on a percentage value from 0-100, how can I do that?I am aware that progress bars could be done by a shape widget, so perhaps it could be possible to have a column as a shape that can take a value? The goal is to have the grid look like this:  Thank you in advance! 

I have a problem with the fact that I cannot maintain the order of Data Shape properties in the service.For exampleDate Shape:IDPartNamePartNumberChildEqIDSomeNameWhen I check what the list of properties returned by the service as an infotable in All Data looks like, I see this:ChildEQIDIDPartNamePartNumberSomeNameHow to keep the service result in exactly the same order as in DataShapeI need this order to generate an excel report  

I have a Thing Template of type Scheduler, where I have a Subscription. I have written a some scripts inside that Subscription, which is working fine. But when I try to call a Thing Service that Subscription is not getting executed.Kindly share a sample code snippet. Thank you  

Hi,We need to integrate ThingWorx with a company web application.The application receive json as an input than it returning response with a base64 content inside the body.Using postman for testing we can see the body in the response.Our issue is we could not find a way to see the body in the response using ThingWorx service using  ContentLoaderFunctions services like PostJSON.Anyone know how can we read the body response of a post request using ThingWorx? BR,Tomer.    

After upgrading from 9.3.8 to 9.4.0, the MenuSelectedStyle is not working, making it difficult for a user to know which page they are currently viewing. I have investigated in the Dev Tools, I cannot find the class that controls the Menu Selected Style, which is present in version 9.3.8. Is this a bug in 9.4.0 that other users have experienced?  We can implement a custom CSS workaround, for the time being, but it then requires rework. Is there another more accessible work around or will the issue get fixed in a new patch soon?

Dears,     I set up remote property on thingworx, but quality of tag is inconsistent on thingworx and kepware.    quality of the remote property on thingworx is GOOD as the the screenshoot   but I checeked this tag on QC which is provided by kepware. The tag quality is UNKONWN, and _system._Error of this tag is also true.         I am so confused with this inconsistancy, could anyone tell me which quality is correct?