ThingWorx

Hi everyone,   I'm beginner with Thingworx and I'm using:   Thingworx 8.5 with Postgre   I'd like to know how can I to create a timer to get active session.   For example:   I wanna motinor for how long time an user is logged.   Is possible create a timer to do it?   Regards,   Leonardo.

Hi ,  I am looking for Downtime calculation in hours, i have two columns in table where i am logging both Downtime and uptime as timestamp with their values 0 and 1. But i want to calculate it in hours , how can we get this using javascript or any twx functions?    Thanks 

Hi, I was trying to create a developer user group in my application to which collection level access permission to almost all entities barring a few was provided.   In case of Thing Template, provided visibility to the organization of the user group and also provided all permissions in the Run time and Design time scenarios except for the delete permission.   One thing that was observed is, though I am able to access and edit certain Thing Templates, an error was getting thrown in Application log stating the the corresponding entity cannot be found.   Apart from the access and visibility permissions provided at the collection level, should it be configured at some other level also?   For reference, the error shown in Application log  mainly corresponds to 3 Thing Templates (RemoteThingWithFileTransfer, RemoteThing, GenericThing)   Can anyone suggest an approach to be taken to resolve this

Hi Folks,   Is there any capability of Edge Analytics in Thingworx?  Don't want to send data from Sensor to centralized data store but perform the Analytics on the Edge itself.   I would appreciate if anybody can provide any information on Edge Analytics within/around Thingworx.   Thanks!

We are working on making our data ITAR Compliant so for that we are thinking of using the dynamic data masking technique . DB we are using is sql server and at the database level masking works fine but the problem is that we have one DB connector thing which uses admin user for connection to DB . If we change this user to normal user, then masking works fine but masked data cannot be accessed for calculations and other business logic which creates problem for us. Is there any other way of achieving this without creating new DB connector thing ?

want to show dropdown after clicking another dropdown's list. if i have 1st dropdown which having list as member and staff after selecting member or staff, i want to show 2nd new dropdown.

Hi!! i have the authetication extension and i can use a external page to authenticate a user. But this still as it's flaws, for example: if the password or username are incorrects the page will be redirected to a formlogin.   I want to go further, i want to create a actual login system inside thingworx, is it possible ? what do i have to do ?     Thank you.

Hi, Any best practices are there to consider while i am having server, user and machines are in different timezones with Thingworx?   Ex:  Server - UTC User - UTC+05:30 Machine - UTC+08:30   Thanks in advance.   Regards, Sathishkumar C.

How to export a prescriptive model in python?

hello, i want to show some data after clicking on dropdown list. if i have dropdown "level" which contain list as "Beginner", "Intermidiate" and "Advanced". And i have mashup which contain workout list. So if i select "Beginner" then in mashup it show only "Beginner" list. Please refer below attachment.    

Hi Everyone, I want to invisible collection row depend upon drop down select without hitting DB. I know its possible on one service with drop down as a parameter but it every time it will hit the dB when i select drop down option i don't want this, Please check above image which having workout data in collection. On mashup loaded it will load all workout data once time then, When i select beginner i want to show only those workout data related to beginner without hitting database and remaining data are invisible. same goes with other two option. How can do that?   Thanks in advance

I'm following the install documentation for thingworx foundation and I get to the step where I need to create a self-signed certificate. Unfortunately my Java keystore won't except the certificate that is created. It is rejected with this error > java.lang.Exception: Input not an X.509 certificate" I've tried this solution https://community.ptc.com/t5/ThingWorx-Developers/keytool-error-java-lang-Exception-Input-not-an-X-509-certificate/td-p/623652 but the thingworx foundation installer won't accept the certificate file created. Any ideas?    

I am getting "License has not been installed" error while saving user. what need to here.   Re:  post

I recently had another ticket that got me connected to the java hosted trial but now I am getting this error associated with the ThingName I am creating. com.thingworx.common.exceptions.GenericHTTPException: Entity ExampleThing_1 does not exist or is not yet associated with a Thing   Here is the line that creates the ThingName. private static String ThingName = "ExampleThing_1";   What am I doing wrong here?

Hi, When we access the thingworx which is installed in an EST server and access the thingworx through link in local machine, the time get changed according to our local machine. But we do not want the time to get changed. We wanted to view the server date and time. How can we achieve this in ThingWorx?

Hi,   I am looking to generate reports on period basis like daily, weekly, monthly etc from infotable data  , So how can i achieve this easily in twx 8.5.0   Thanks,

Hi, i am looking to filter data based on input month and year, please tell me how can we do it using query parameter in thingworx.? i have timestamp column as below..       thanks

Hello I have a system user that needs to create pragmatically things based on template "MYTemplate"   I gave visibility and service exec permission to EntityServices->CreateThing I gave permission to Create on "things collection" the User has also visibility to all things based on MYTemplate (it is set visibility at template level)   That user can run the service CreateThing, no errors like serviceinvoke or not allowed to Create ... but I get the error JavaException: java.lang.NullPointerException: null at the CreateThing call. NOTE that the thing was created however !   I solve only if I give to User the visibility permission to all the "things collection", seems the permission only on the template is not enough for creating things.   It seems like if for an instant the Service creates the thing, but he can't see it after all , because it still don't know that is based on the MYTemplate that instead makes it visible to that user. &n

Hi, We faced a issue where suddenly the services in data tab got disappeared and we couldnt retrieve them. But the connection exists for all widgets which we could see from the connection panel in bottom but the data tab is blank.  Another issue we faced is,when we duplicated the mashup there was thing called multiple times and services called multiple times which we did not use at all. Also when we switch from one mashup to another and come back to the mashup in which multiple were called, the data got disappeared.  Is there any way to recover this issue and why is this issue occuring in thingworx more often?    Thanks, Shalini V.

Hi everyone,   I was not able to export data from my Thingworx Foundation.   To export entities is working well.   Can someone help me?

Hi,         Can we dynamically set the  from mail id and password in Mail Server Thing.   Thanks in Advance.

Hi Using QueryPropertyHistory I'm not able to fetch all rows between the specified start and end date.  I'm logging the data in "value changed" mode. It is also not related to max Item, I've checked it by increasing the maxItem. Please provide a solution because I need this for my graph. Thanks in advance.

Is there a simple way to gather a list of all permission that a specific User, User Group, or Organization (or Org Unit) has been granted?  By this I'm suggesting a Service that takes a user, group, or org as input and returns a list of the Run time permissions, Design time permissions, and Visibility permissions that have been granted to that entity. The purpose of this service would be to quickly see everything a user has access to without having to manually check every entity.  This could also help diagnosing issues with permissions.   One idea to accomplish this is to loop through all entities on the platform, run the "Get permissions for user/group/org" services against each one, and return the list of all permissions.  I know this isn't impossible, but it also doesn't seem efficient.  However, I can't think of any other way to do this.  Ideas or insight?

hello, I want to show image in new mashup which have list after uploading it in another mashup using file upload widget. Please refer below images

After creating and saving Mashup when i click on Design its keep on loading ,i wait 15-20 mins but it is not coming up. Could you please guide me how can i resolve the issue.