ThingWorx

Hello,           I'm using Thingworx 9.0 version ,I want to find specific entity in grid Advanced I have ticked EnableGridSearch property How do I search specific entity in grid advanced??please refer below attachment. Thanks in advance    

I have a service in ThingWorx 9.0.1 that is selecting a row for update to avoid concurrent updates.  The service works (in that it updates the tables correctly) but it always throws an exception.  The code:         begin; select * from opportunity where opportunity_number = 2 for update; update opportunity set description = 'testing 1.2.3.4.5..' where opportunity_number = 2; commit;       I've tried several ways to eliminate the error (changing the result type, changing from query to command, etc..)  I always get one of these errors:   --When I'm using the Query handler: Unable to Invoke Service test on Thing.DB.Forecasting : Execute Query failed: org.postgresql.util.PSQLException: No results were returned by the query.   OR   --When I'm using the Command handler: Unable to Invoke Service test on Thing.DB.Forecasting : Execute Update failed: org.postgresql.util.PSQLException: A result was returned when none was expecte

I want to create chart with strips as starting and ending range of certain value. Is there any option in thingworx 9?

Hello Community,   we decided to use some more custom CSS in our UI and would like to leverate the bootstrap CSS.For this purpose I am currently developing some Custom Widgets that should enhance our layouts and look & feel.   The idea is to use the Bootstrap Card Class and make it an container widget, that by itself contains a flexcontainer.  So it should have the structure: <div class="card"> <div class="card-header">Header</div> <div class="card-body"> <!-- Create Flex Container here --> </div> </div> I had a closer look at the tabsv2-Widget how to do this and created a simple widget with similar behaviour (attached zip), but I have a massivie issue with the placement of the SubWidget.   The Code creates final HTML like this: <div id="root_panelext-14-bounding-box" class="widget-bounding-box nonresponsive" style="top: 5px; left: 5px; width: 337px; height:&nbs

Hello, I want to select rows in advance grid after checking the checkboxe.  i have bind the service to advance grid and i have added the checkboxes in grid. but after checking the checkbox the row still not getting selected, please suggest the solution refer below attachment

Hello,   After installing Platform-Analytics, Property Transform is not working.    My environment is: - Virtual Machine 1      - THW Platform: 8.5.2      - SSL:443      - Autogenerated certificate - Virtual Machine 2      - Analytics Server: 8.5.2           - Connected to the platform and working     - Platform-Analytics: 8.5.1           - RabbitMQ and Apache Flink from the installer           - Erlang 21.0           - The installation summary said that everything went OK and Things were created   I have the following error in configuration.log: (attached) 2020-09-17 08:59:41 [pool-1-thread-1] ERROR c.t.a.d.c.FlinkStatusCheck - Error while checking status of Flink clusterorg.apache.flink.util.FlinkException: Could not connect to the leading JobManager. Please check that the JobManager is running.at

I am looking for examples to call API to validate the user name and password and generate access token  using  OAuth 2.0 while user login to Thingworx Steps I like to perform: 1) User enters user name / password 2) Thingworx call    external API (  /token)  to validate the entered user credentials 3) The external API will validate user/password against authentication system such as active directory. 4) The external API and send back access token for further calls to the external 

Hi, I have a database template thing and is it possible to configure the jdbc connection string dynamically from the mashup? When a mashup is loaded, is it possible to pass the database name, username and password as input to establish the connection between that database and thing?   Thanks, Shalini V.

Hi,   I just downloaded the newest trial from the download section and tried to install it.   The installer failed, then proceeded to delete all the log files and stack traces during the rollback.   After searching this forum I was finally able to find some logs in the %temp% dir, but not all of them obviously.   Here is what I have found, I hope it is enough to get the install going.   I replaced all the Java versions with the official Oracle Java 8 202 and set up all the env vars.   Thx for help,   Ralf

windows.location.href and document.getElementById() whats is the related function in thingworx

Is it possible to scale the icon on a button widget to fit the size of the button?

Hello all,   Currently the default for Dashboard Widget - is that the groups are expanded. I would like them to be collapsed in size for when I view the mashup.    In the attached files below you can see how the groups are defaulted to being expanded. In the second picture, I collapsed each individual group - that is what I would like it to be looking like.   Any direction would be great - thank you! 

Hi dear community.   Note: I do have a workaround for the situation below, and that is to Sort separately the result of the QDTE service, but I was wondering why this method of attaching the sorts object does not work in the way I designed it.   Problem:I have a relatively simple scenario where I encountered an issue. In ThingWorx 8.5.4, I have an advanced grid, bound to a custom service that has a query object as a QUERY-type parameter. EnableGridSearch is enabled, and the widget's QueryFilter is bound to the service's query input parameter. In my custom service I want to sort the results of a QueryDataTableEntries based on a "timestamp" field (DATETIME) to make sure the grid always displays the most recent field as the first item in the grid. Because of the fact that the grid will always supply a "filters" section in my query object, I would like to attach my "sorts" key to what comes back from the grid. I can attach the "sorts" key to the object (by setting it straight as

Hi, how can i solve this problem?   I configured self signed certificate and changed everything in Tomcat.(like in Article - CS307906) But still have this Warning. Thanks in advance! BR Vladimir

Hi everyone,   My environment:   ThingWorx 8.5   Custom Chart 3.0.3 - Time Series Chart V2   Is there any way to change the x-axis size and y-axis size?   I have tried looking for Properties and Style Properties but I did not find anything.     Regards, Leonardo.  

Hi,  I have an error in the Template.lue script. Error msg   [INFO ] 2020-09-14 08:32:57,138 PiThing: Attempting to GetPropertySubscriptions from server failed. code: 504, result: [ERROR] 2020-09-14 08:32:57,167 luaScriptProxy::execute: [-1242565552] Error executing script PiThing, Error = Error: ...oads/microserver/etc/custom/templates/PiTemplate.lua:32: attempt to perform arithmetic on global 'sf' (a nil value)[ERROR] 2020-09-14 08:32:57,168 luaScriptProxy::app_unlock: [-1242565552] Attempt to unlock app_mutex while not holding it.L= 0x16f3c38 PiTemplate.lua error line BOLD   module ("templates.PiTemplate", thingworx.template.extend)properties.cpu_temperature={baseType="NUMBER", pushType="ALWAYS", value=0}properties.cpu_freq={baseType="NUMBER", pushType="ALWAYS", value=0}properties.cpu_volt={baseType="NUMBER", pushType="ALWAYS", value=0}serviceDefinitions.GetSystemProperties(    output { baseType="BOOLEAN", description="" },    description { "update

Hi,   Is there any way to cache or disable "GetAllStyleDefinitions/ GetAllStateDefnitions" from loading every time for a mashup in Thingworx version 8.5 to 9.0 ? Its consuming loading time everytime a mashup loads with same style/css and wondering if it can be avoided for the same media,style,etc.    

Hello all,   Could anyone help me to create Winchill OData connection in Thingworx Flow. I can see only Windchill Connection  Thanks in advance   /VR

I have a problem perfectly described by the article "CS227181 - Runtime Mashup does not fully render in browser, for non-administrator Users on ThingWorx Platform". Unfortunately, the solution is useless, because, as far as I can tell, what they say to do was already done by default. The PlatformSubsystem is apparently visible and the GetAllStyleDefinitions service is apparently visible and executable. I keep using qualifications, because I'm not really sure. The only place I've found any mention of these things is in the User Profile, and the only way you have to be able change them is a check box. As a result, I'm not sure if the check box is what makes them visible and executable. I'm not even sure if that is the right place I need to be to fix it, as no one really walks through where to make the fix for this problem. Thanks in advance for any help

Hello everyone,   Is it possible to add Google Authentication to a Mashup, let's say, as it's opened?   Thanks and best regards

Hi All, I wanted to use breadcrumb widget but need to change separator from "/" to ">". I am using Thingworx 8.5.2 version. Current Test1 / Test2    Desired  Test1 > Test2   Thanks for help   Regards, Vishal Vaidya

Hello,   i want show data in collection widget by using dropdown data selecting. I have one dropdown which have three levels as Beginner, Intermediate and advanced. and i have one collection widget where all levels combined. if i am selecting level Beginer in dropdown then in collection it shows only beginner level. Please suggest any procedure. Refer below attachment for your better understand.

I just performed an upgrade from TWX 8.5.7 to TWX 9.0.1 and in doing so, several mashups had widgets completely removed.  Bindings were also removed.  This means that I have no choice but to re-create these mashups manually...   Is anyone else running into this?  If anyone has any ideas on why this might be happening, or any ways to get around, please share.   EDIT: Looks like the disappearing widgets were related to browser history.  That fixed some issues.  However, I still had to go through the app, retest, and make changes to some change widgets.

Hello Community!   After installing and configuring the TWX Azure IoT Hub connector:   Connector: 3.0 Thingworx: 8.5   I am traying to run the edge-device-demo, but I’m not able to see telemetry data sent by the simulated device from the demo.   Attached you will find screenshots:   Successful execution of the smoke test The IoTHubThing connected status The log from the edge-device-demo execution The AzureIoTThing (demo thing) connection and properties status (not updated) Can you please tell me what I am missing?   Regards,   DJ

Hello.   I am using the new Value Display widget from 8.5, and I need to be able to change the fallback-text colour (TextIfNoValue colour) through css. Can someone please indicate me how can I access this property, so I can change it?   Thank you.