IoT & Connectivity

In a data analysis project, you are tasked with exploring an SQL database to gather insights about a company's sales data. The database contains two tables: orders and customers. The orders table includes columns like order_id, customer_id, order_date, and order_amount. The customer's table includes columns like customer_id, customer_name, and country. My goal is to write SQL queries to answer the following questions:Total Revenue: Calculate the total revenue generated from all orders.Top Customers: Identify the top 5 customers who have made the most orders, along with the total number of orders they placed.Country Analysis: Find the top 3 countries with the highest total revenue from orders.Monthly Sales Trends: Generate a report showing the total revenue for each month, ordered chronologically.Please give me some places where I may discover the answers to these queries or small samples of SQL code. Assuming the appropriate tables are present, you may provide SQL queries to get t

Hello, I am using a collection widget to display items in an info table and a chart. However, it only displays the rows and I am unable to display or put on any column headings. To clarify, I am using a collection widget and not a grid widget since I wanted to add shapes in the table, where the color changes based on a column's value. This is what the parent mashup looks like:The workaround that I did was that I added a container above the collection widget which has the column names that I want. However, that didn't work well since the column headings do not align with the columns in the container widget, as seen in the image below (mashup on runtime): I have tried just resizing the containers but it still did not work well and it does not seem like a good idea since it will just be based on my screen size.Could someone please tell me how can I solve this? Thank you in advance. 

so the Whats new page of 9.4.0 states this: Platform There is a known issue with API SetGlobalSessionInfoTableValue, where the infotable value is not stored correctly. This API will be deprecated and removed in a future release; issue will not be fixed. Update your applications appropriately.   Can i get some more clarification about this: "This API will be deprecated and removed in a future release"?   Will only function SetGlobalSessionInfoTableValue be removed or will there be more changes to the sessions?   side note: The javadoc doesn't show it as deprecated.

Hi All,I'm facing an issue with KEPSERVER EX and MODBUS TCP/IP.I have one Channel for MODBUS communication and in it 8 devices (each has 16 tags). Each of it commucating with same IP but with different ID to read data from different channels.When I have only 5 devices, all works fine. When I add more, I'm not able to read devices from ID5 to 8 (warning - device is not responding), but the first 4 still works fine.I've tried to separate devices to other channel, tried to raise the Scan rate to 20 seconds for each tag. but nothing helped.I've tried to read the IDs from vendors app, which is communication also over modbus and it works fine for all devices in same time. do you have any suggestions/ideas what to do?Many thanks  

We recently update Kepware version but start some error with a driver of control logix 5500 the plc is some old and have the firmware version 20.0, and some times lose connection and try to generate the tags but fail until we start the create tags of the driver some know why happen this or some advise

Hi. We are installing a trial verison of Kepware on our VM Hyper-V to see if the OPC server is working before we are ordering a license. But i just getting bad quality from the Mitsubishi PLC. The server is a 2019 windows server. When im trying from my Windows 11 computer is working with no problem. I have disabled anti-virus, firewall everything and still not working.Any suggestions?   

Hello everybody, I´m struggling an issue with KepserverEX 6.11 and OPC UA client. I´m trying to add a tag, "ProgramPointer", from ABB IoT Gateway 1.3 and I´m getting this message in the event log: "OPC UA Client ABB_IoT.R21 | UA data type not supported. Tag cannot be imported. | Tag name = 'ns=3;s=2600-11****_2600-11****/RAPID/T_ROB1/ProgramPointer', UA data type node id = 'ns=2;i=15108'". I´ve tried to connect to the ABB IoT gateway (OPC UA-server) with a couple of other OPC UA clients and they can read the value of the tag without any problems, the value looks like this: {mModulename | Routinename | Rownumber}. Is it because the value is divided in to three different data that KepserverEx is complaining? I might add the there isn´t any issues with other tags, just this Programpointer tag. Thanks Regards      

Team, Need your help, i am getting a syntax error while configuring the Tags for the Simulator enabled Channel-Device. Please find the attached file for your reference. Thanks,Regards   

Hi all, I have a machine model which I am showing in ThingView, List of parts is also available in grid widget. My requirement is to show/hide 3d BOM components in thing view (based on line selection in grid). How can I achieve this. I am stuck at showing and hiding part of implementation. Does ThingView support this feature or I should look for some alternate. Any idea would be highly appreciated.  Thanks in advance.

Hello, I have a value display in a mashup:Where I want it to have a shadow effect on runtime, to be similar to something that looks like this: How can I do that? Thank you in advance. 

ms error : feature omron fins ethernet is time limited and will expire

Guide ConceptStep 1: Completed ExampleStep 2: Create Session ParametersStep 3: Access Session ParametersStep 4: Next Steps Maintain cookies and security information by implementing session parameters in your application. Guide Concept This project will introduce creating and accessing session data from a User logged into your application. Session data is global session-specific parameters that can be used on the Client and Server side. Following the steps in this guide, you will be able to access the logged in User's information and their set values. We will teach you how to access session data, that can later be used to provide Users with unique experiences and a more robust application. You'll learn how to Create Session DataAccess Stored Session Data NOTE: This guide's content aligns with ThingWorx 9.3. The estimated time to complete this guide is 30 minutes  Step 1: Completed Example Download the completed files for this tutori

I have a question regarding my operating system. My computer's operating system is Windows Server 2012 R2. is it possible to install Thingworx 9.4? If it is not possible to install which version of the Windows server, my equipment is an HP XW6600 WORKSTATION (Intel Xeon processor) and possibly does not accept the latest version of the current server.----------------------------------------- Translated the content from Portuguese to English using google translate. By Community Moderation team Old Subject: Estou com Duvida referente ao meu sistema operacional Estou. O sistema operacional do meu computador é o Windowns Server 2012 R2. é possível instalar o Thingworx 9.4? Caso não seja possível instalar qual versão do servidor windows, meu equipamento é uma WORKSTATION HP XW6600 (processador intel xeon) possivelmente não aceita a versão mais recente do servidor atual.-----------------------------------------    

Hi Guys, I have noticed many nice demo apps from the PTC, and I am curiously how to get these demo's source code? Maybe I can use it in project in the future. Demo App link: https://extranet.ptc.com/sites/TDD/SitePages/IoT%20Apps.aspx  Thank you in advence     

I have a Mashup having SMTP configuration fields which will take as a input from the user. On saving this configuration I need to dynamically create a thing of Base type "MailServer" with the user given configuration through ThingWorx service. Kindly assist with the steps. Below are the configuration fields in the MashupSMTP ServerSMTP PortUser NamePasswordSSL   

Is there a way to add more than 16 tabs to the Tabs widget?    

Guide ConceptStep 1: Setup Raspberry PiStep 2: Install the EMSStep 3: Create Application KeyStep 4: Configure the EMS Connect a Raspberry Pi to ThingWorx using the Edge Micro Server (EMS). Guide Concept This project will introduce you to the Edge MicroServer (EMS) and how to connect your ThingWorx server to a Raspberry Pi device. Following the steps in this guide, you will be able to connect to the ThingWorx platform with your Raspberry Pi. The coding will be simple and the steps will be very straight forward. We will teach you how to utilize the EMS for your Edge device needs. The EMS comes with the Lua Script Resource, which serves as an optional process manager, enabling you to create Properties, Services, Events, and Subscriptions for a remote device on the ThingWorx platform. You'll learn how to Set up Raspberry PiInstall, configure and launch the EMSConnect a remote device to ThingWorx NOTE: This guide's content aligns with ThingWorx 9.3.&n

i amtrying to show simulated data in vuforia studio whenever i am done writing the script  entity scriptservices not foud error is occuring all the time is there any solution for that      

Hi all, recently I have some doubts about whether one User can have multiple Session when accessing the same mashups? Real case scenario:1. I open the same mashup twice 2. I change a session variable from one mashup > 3. I run the service GetGlobalSessionValues and the session variable changes accordingly4. I refresh my second mashup and the widget that is bound to the same session variable remains its value independently to the actual session variable shown in GetGlobalSessionValues  So my questions are:1. Can one user have multiple JSESSIONID?2. Which service can keep tracking of the session variables of each JSESSIONID?3. Which service can be executed to find how many and which are the currently active sessions of one particular user? Best, 

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 

When you create a new channel/new device and configure it for Modbus TCP/IP, Is this a Modbus Client?? How do you create a Modbus Server? 

How to change Advance Grid Columns Names dynamically in thingworx

What steps are required for PTC partners to have access to Kepware+ for customer presentations / demos?

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.