ThingWorx

Hi,   I would like to enable collection cell selection for only specific cells which has navigation.   How can I make this dynamic selection?   Regards, Janakiraman P

Hello,   Does this mean we cannot navigate inside our solutions? Not even open a popup?

Hi I met a problem when I installed ThingworxAnalytics 8.5.12 on windows.  After filling all the required information on installation page, I clicked the next button and met the error.   The error I met just like below picture.   I followed the guide from this url(https://support.ptc.com/help/thingworx_hc/thingworx_analytics_8/#page/analytics%2Fanalytics_windows_installation%2Fgraphic_mode_analytics_server_windows.html%23).   Also I have already confirmed that the thingworx is still running on 140.118.122.115:32522 and get the application key from thingworx. (It shows like below picture)     I want to ask: 1. How can I solve the error which is described at upper part? 2. Where can I find the java truststore password. (Also, should I fill in with java truststore password from the device which installed the analytical server or the device which installed thingworx?)

Hello;           I want to calculate sum of specific "timestamp" column rows data except first and last row Please suggest how do I write JavaScript code to calculate sum of "timestamp " column rows data except first and last row?? Thanks in advance

Hi   I have multiple things from a single thing template logging their properties on a valuestream . Is it possible to query the value stream to get the properties from different things, or should i use a data table instead?   Thank you in advance

Hi,  I have enabled https configuration in server.xml in Tomcat folder. What are steps to follow in Azure IoT Hub configuration to enable the https? I am using Thingworx 8.5.1 version and IoT Hub 3.0.2. I have added below configuration in environment variable. azre-iot service is not running if set below configuration. Azure IoTHub connector was working correctly without enable https and also receiving the data correctly from Azure IoT Hub to Thingworx. I have followed Thingworx help document.     "AZURE_IOT_OPTS=-Djavax.net.ssl.trustStore=C:\Program Files\Apache Software Foundation\Tomcat 9.0\conf\cacerts-customized -Djavax.net.ssl.trustStorePassword=xxxxxxx"   Also, I have updated in conf. "platforms = "wss://localhost:443/Thingworx/WS"   Regards, Latha

Hi, Can I get infotable data into a pdf? like we export the data into excel sheet(csv). The data can be dynamic. I am reading everywhere that pdf/print extension will just take the screenshot of the page.

I'd like to connect Rockwell MES, PharmaSuite data with Thingworx Server. In my installation Thingworx component manual, it requests me Industrial Gateway zip package named "EIHub Thingworx Industrial Gateway.zip". Could you help me how to get this package file?

Hello Everyone,     How's everyone doing here!  I am new to wsems and I am having some issue with starting it.  It seems the problem is "SDK: twSocket_Create: getaddrinfo() failed: [Name or service not known]".   I am not sure what name or service is this warning message referring to.   Any help would be great.  Thanks.    P.S I am on Ubuntu 18.04 and firewall is disabled.  Internet connection to outside is fine.      axiomtek@axiomtek:~/microserver$ ./wsems[FORCE] 2021-04-14 17:24:11,967 ./wsems: Initializing EMS ....[FORCE] 2021-04-14 17:24:11,967 main: Using config file /home/axiomtek/microserver/etc/config.json[WARN ] 2021-04-14 17:24:11,967 Main: Encryption is disabled on HTTP Server.[WARN ] 2021-04-14 17:24:11,968 Main: Authentication is disabled on the HTTP Server.[FORCE] 2021-04-14 17:24:11,968 httpServer: starting http server port=8000[WARN ] 2021-04-14 10:24:11,968 SDK: SDK Version: 2.2.11[WARN ] 2021-

Hi everybody,   I have some dudes, I want to know what is the best practice for devices that I want record historical data. I have Temperature/Humidity devices and I don't know what is the best practice. I have two questions: 1. Is it better to have streams as devices? 2. Now I have a value stream associated to a template for record historical data because I need temperature or humidity data, It's well done? My objetive later is make a Time series chart with the historical data, what is the best option?   pd: please I know this article Difference between Streams, Value Streams and Datatables in ThingWorx  but I need to choose which is the best option when I have remote devices that will send to a broker the data and the broker will be comunicate with Thingworx.    Thank you in advanced, Luis.

Hi, Currently I used the google map widget to display some data with different color representations, Now I have to add legends for that colors.   Is there any way in thingworx to use one widget above another widget using CSS or Z-index ??? Please take a look at this UX for better clarity....  Like in this design,  I need to display legends on top of the google map widget...   

When I run the UpdateDataTableEntry service, it does not update the source. Why does it not update the source?   var currentUser = Resources["CurrentSessionInfo"].GetCurrentUser(); Things["DTName"].UpdateDataTableEntry({ sourceType: "User" /* STRING */ , values: values /* INFOTABLE */ , location: undefined /* LOCATION */ , source: currentUser /* STRING */ , tags: undefined /* TAGS */ }); Initially, I had the source and sourceType set to undefined; however, since it did not update source with the user name, I changed it to currentUser, but it still does not update the source. The service is being executed directly by the user and not by the system user.

If I'm not mistaken, Thingworx is using DHTMLX controls and there is an option for when a checkbox is selected the parent and children nodes are also selected/deselected as needed. I am trying to get this to work but I don't see any option and my current solution is not economical (uploading data to sql server and reloading mashup and reloading the data from sql). I'd prefer to do this client-side or at the least on the Thingworx side. Any suggestions?   Click on the second grid's checkboxes to see how three-state checkboxes work. https://dhtmlx.com/docs/products/dhtmlxTree/samples/02_checkboxes/05_tree_checkboxes.html

Hello Team,   I have migrated from thingworx 8.5 to 9.0. While designing mashup unable to find layout widget in responsive container. Please do the needful.    Regards, Raghavendra

Hi,   is it possible to use the integration runtime SAP oData connector to authenticate via a token?   The process will be as followed: 1. Request with username/password to endpoint "GetToken" 2. Response is body with json values where I get my access token 3. Use the access token to authenticate to SAP   There is something for CSRF token requests. But I am not sure if this is the same thing. Right now my settings are this: Authentication type: Fixed Auth. Server ID: -empty- Rel. URL for CSRF Get Request: /v1/auth/.../token CSRF Token Name: acc_token HTTP Connector Connection Settings: Username & Password for token endpoint Base URL, rel. URL as needed for SAP...   It worked for my endpoint where no authentication is required. But for this one I've only get a 401 - Unauthorized.

Hi,   I needed suggestion on designing and IOT application.  I am going to describe it with an example flow which is similar to my existing requirement.   -> Consider there are 2 groups of users with a group head each. Each group have 4 members. -> There are 4 machines and respective 4 things created in thingworx( whose parameters are linked to machine tags) -> Each machine's data, information and related operations will be assigned to particular users from both the groups -> There is one general mashup designed, which will should the respected machine information when the respected user login's to the application. -> And there will be common set of services designed that will be linked to the mashup.   Question: How to display data and information of different machines, when that respective user log's in the application(Mashup) on that same Mashup.    I have drawn a diagram for better understanding.   Now is need some advice on how to

Hi , I am looking to display date in format yyyy-MM-dd , but returned type should be DateTime.  var d=new Date();// dateFormat(dateValue:DATETIME, dateFormat:STRING):STRINGvar formattedDate = dateFormat(d, "yyyy-MM-dd"); // parseDate(stringDate:STRING, dateFormat:STRING):DATETIMEvar dateValue = parseDate(formattedDate, "YYYY-MM-DD"); but its returning Date with Time. I need only YYYY-MM-DD.   Thanks

Hello, I followed various articles from community forum here as well as this TWX article. and I am still having issues with my code outputting to an InfoTable. I am using an API to fetch Stock Price JSON data and having it be converted to an InfoTable, so it can be displayed into a graph in Mashups.    I've attached screenshots of my DataShape Field Definitions as well as the JSON Data Output.   The TWX code, with it outputting the columns with "No Data" is below. I've tried playing around with the for loop and doing a data.array.length but that mentions length is undefined. I am not sure if that would output to it being an InfoTable either. Thank you.   var restParams = { proxyScheme: undefined /* STRING */, headers: undefined /* JSON */, ignoreSSLErrors: true /* BOOLEAN */, useNTLM: undefined /* BOOLEAN */, workstation: undefined /* STRING */, useProxy: undefined /* BOOLEAN */, withCookies: undefined /* BOOLEAN */, proxyHost: undefined /* STRING */,

Hi,   I want to Highlight Empty rows of Advanced grid widget in red color. I wrote state definition for this and give it to Row Format property of grid but it applying to all  grid rows.   Please let me know how to resolve this.   Thanks!  

Hi all,  I have two types of markers in Google Map Widget that represent two different values of a property (State-based formatting). The problem is for the selected marker, I have no idea how to set two different types of this. Any help? Thanks

Hello everyone, I am trying to manage visibility and permissions in Thingworx 8.5. The problem is that I want to set visibility and permissions on a certain mashup but when I go to that mashup and set the organization, when I then connect to the user who should see that mashup, he sees nothing (see the images). This is a example of the mashup In that mashup I put the organization which contain the user who must have visibility of this mashup. But when I log with the user, the user doesn't see anything. But If the same user is included in de default group SolutionCentralDevelopers in Thingworx 8.5, the user can see the mashup. Is it necessary to include all users in SolutionCentralDevelopers to see mashups with users who are not administrators or system users or I've done something wrong?    Thanks in advance, Luis   

Last Friday, I deleted a scheduler thing named greenhouseSimulator2_Mixing_Scheduler via Composer. Today, I want to create a scheduler thing with the same name using a service inside greenhouseSimulator2 thing, but this error appears:   greenhouseSimulator2 CreateMixingThing error JavaException: com.thingworx.common.exceptions.InvalidRequestException: Thing [greenhouseSimulator2_Mixing_Scheduler] already exists   But if I try to search the greenhouseSimulator2_Mixing_Scheduler via the search bar, there is nothing (it should be like that because I already deleted it before).   I try to delete using the DeleteThing service from EntityServices but ThingWorx can not find the entity (it should be like that because I already deleted it before).   I wonder how I can solve this. I already did these things and all were failed to solve this problem: 1. Restarted the Azure VM containing the ThingWorx server 2. Restarted the Apache Tomcat from Windows Servi

Hello all,   I have a button 'show details' in each cell of my collection. Clicking this button should show a detailed overview of my data that you don't see in the standard screen/cell (so the mashup height should increase and there should be details added to the cell).   How to handle this in the best way? I need some advice 🙂

Thingworx Platform 9.1 is already supported Open JDK, so I want to change JVM from java oracle 8 to open JDK (I tried with Amazon Corretto 11 and Adopt OpenJDK 11). I have tried to change JAVA_HOME into OpenJDK directory and %JAVA_HOME%\bin to the PATH in System Environment Variable and restart the ThingWorx services, but the JVM used in ThingWorx is still Java oracle 8. And then, I tried to change JVM version directly from apache tomcat configuration by checklist the "Use Default" check box and restart ThingWorx services, the JVM still not change And then I tried to set directory of OpenJDK jvm.dll file on the Java Virtual Machine field in apache tomcat configuration, but I got an error when I tried to start ThingWorx service.Did anyone has successfully change the JVM version on Thingworx 9.1? (especially from java SE 8 to OpenJDK)Thank you    

hii i have one database(POSTGRESQL) configure with thingworx 9.1. i have created postgresql thing which contain services(postgresql queries) for eg:- i have one postgresql query which gives me allmembers data but it shows an error  "select ch.tcr_id,concat(us.first_name,' ',us.last_name) as member_name,ch.user_id,ch.checkin_time,ch.checkout_time,ch.band_id,ch.checkboxfrom "tbl_checkin_records" as chjoin "tbl_members" as memon ch.user_id = mem.user_idjoin "tbl_users" as uson mem.user_id = us.user_id order by ch.checkout_time desc;"        this is my query which gives me an following error:- Unable to Invoke Service getAllCheckinRecordsForMember on PostgreSQL_DB : Execute Query failed: org.postgresql.util.PSQLException: ERROR: syntax error at or near "as" Position: 165 But when i was using  i have attached snapshots below for your better understanding