ThingWorx

Dear community, I am having trouble with the QueryDataTableEntries Service of DataTables, Build 9.3.0-b20. I prepared an example and attached it to this thread, it contains a DataTable Thing with an according DataShape. The DataShape has 3 fields, each is defined as part of the key. The DataTable has 8 entries (2 different values per field, permutated), they are added by the Init Service which is called on ThingStart. The Service VerifyQueryDataTableEntries performs 4 tests to query the data. The first two are working well. The last is failing, it doesn't return any row but I would expect to receive one.The third test seems to be an act of randomness. First it succeeds but if you execute the Init Service (or restart the DataTable) a second time it also fails!??? I consider this behavior a bug. Or at least it is a change in behavior since 8.4.15, in our old environment all tests succeed. Thank you for checkingBenny

Hello everyone, I've created an extension that convert a file from csv to parquet and send it to Event Hub. The creation of parquet is based on spark-3.3.0-bin-hadoop2  libraries installed on file system and referred by an enviroment variable. This scenario is working well but i wondering if is possible perform the same action loading the spark-3.3.0-bin-hadoop2  as a Thingworx extension. In this case how  can I referred the library in an environment variables ?Answering question  could solve the problem when Thingworx is installed in a cloud environment.  Thank you

Hi Community! I would like to know if would be possible to create mashups from services using mashup template, exactly like we do to create things dynamically.Just to better exemplify my use case, I would like to create a mashup for each thing created dynamically because on this mashup everything is equal besides the values on the collection widgets. Thanks in advance!Felipe Duarte

Hello,How to write Media query for label and ValueDisplay, making a responsive mashup, so based on the Screen Resolution, the font size of the Label and ValueDisplay should Increase and Decrease.Can someone help me to write a Media Query?Thanks,

Whenever in a Thing a subscription on the DataChage of a property is activated, it is necessary to save information on this activation in a table. In addition to inserting in the data table I trace the event with a logger.error. At the end of the test I find that the number of logger.error is more than the rows that are saved in the table.BRDimitri

Hi all, i have a menu which has 10 items in it. For one site i need to have 10 menu item. For other site i only need 8 item in a menu. Suggest a code to hide or delete the menu items based on my condition. Thanks in advance 

For the random interval of time Kepware gets disconnected from thingworx (cloud server)

Hello, I have rebuilt a project that fetches some information regarding my companies thingworx platforms.It had to be rebuilt as it was timing out from all of the API requests taking too long to complete. So I designed it like this instead: Where one scheduler will trigger one subscription per platform, which in turn will get some data back from the remote platform. We will then push this to our DB. Now, the "issue" is that there is no way of knowing when all of these subscriptions have actually completed.Or am I wrong about that? If anyone has any insight or have some good links relating to this, please let me know. Regards, 

Greetings, To provide a context:I'm building an app to store data from an experience. The process is simple, the app gets data from users and share it to Twx, Twx sends the data to pSQL and gets all data stored in the db to show it in a mashup. Now, I'm triying to send the data to postgresql. I created a js service to get the data from vuforia. I just read that I can't use "me.property" in SQL commands, that I should create variables in the js service and invoke those variables into the SQL command. But I'm not sure how.A different way I thought I could use was to call the Thing property into the SQL. But It didn't work, I think is because I didn't use the right command.Another way was to input the data directly into the SQL but I will have the same problems later in the process because I will need the data to use it in different services. Do you have any advise? Is there any guide about programming SQL in Twx?  Thank you a lot for all your advises. 

Hi, I would like to use the web frame widget to display a separate web application page in thingworx but by using Thingworx authentication for the page. My idea is: the webpage should be available only through the thingworx application.It is easily possible without any authentication by just passing the URL in the widget(if the user finds the URL and he can paste it into the browser he can access it without any auth.), but now I want to authenticate the web page with the TWX user creds(so by only if the TWX user is logged in or his session is active he can access the page).My initial impression: to use, post JSON service, and pass some user data to validate and authenticate by checking the user's roles, user groups, and ORGs then if the user passes the validation the end URL will be generated and get published (attach to the web frame widget).On the node js side(the webpage links should be available only based on TWX users): I need the user data to validate the users, then I can p

Hi all, I'm currently using ThingWorx 9.1.8-b845 and I have a problem when I want to create a mashup parameters in a Master Mashup. The gear symbol is unclickable (see picture below). Does it mean that I can't create mashup parameters in a master mashup? Best regards 

Hi, Need to know how to change the colour of the grid row based on the date. I can change the colour based on string/Numeric.   Thanks in advanceKeerthivarman

Hello, I would like to make the embedded agent work on my machine but no clue why it doesn't.I have AgentEmbedded-6.9-12 and I'm having problem with openssl, Which version should I use for this particular version release? I used some random openssl versions from the internet , and each time the error is different and the release is missing the files. What do you suggest please?

Is it possible to upgrade script engine to the latest Rhino version in ThingWorx? For example, ThingWorx 9.1.0 comes with Rhino 1.7.11. How does one upgrade to Rhino 1.7.14?Thanks. 

I am using the MFG apps to create Alert templates for separate alert states (stopped, faulted, offline, manual). Everything works fine but I would like to get the timestamp for the End Time and total Duration of the alert. Similar to the Alert Summary. Per https://support.ptc.com/help/thingworx/apps/r9.1/en/#page/thingworx_apps/Exploring_the_Apps/alert_monitoring.html  

Hi everyone, i have xml input. I need to retrieve all the attributes of the specific node .thanks in advance 

Hi I have a service where i write a propertyHistory infotable to a csv file. In the UI, I can see the datetime in IST format, but I expected the timestamp on the written csv file to have UTC format. But instead, the timestamp is in EDT/EST format. Is there a method to change this conversion so that I can get the output timestamp in UTC. Since the EST/EDT vary each year the quality of the exported data has an expiration date. Please let me know your comments. @VladimirRosu_116627 

Hi, I have a problem about update a property of base type ThingName. Scenario: => Thing Template  = 'ABC' (contain property 'test' of type string)=> Thing : 'EFG' contain a property of base type THINGNAME (Thing template : 'ABC') , i name it ABC_1On the service of thing 'EFG' i want to update the property test   this code : me.ABC_1.test ='new value' does not work ! Do you have any idea how to achive this ? Thank you in advance.   

My understanding is that Things[fileRepositoryThing].ExtractArchive(params) is an asynchronous function.  Is there an event listener service similar to addEventListener( ) that I can use to run a callback function when the extraction is complete? I am moving the file after it's extracted, but I want to make the process more efficient by using some kind of event listener instead of a do while loop.  let moveFileComplete = false; do { try { Things["SystemRepository"].MoveFile({ targetPath: "/Push/" + me.name + "/" + fileName /* STRING */ , overwrite: true /* BOOLEAN */ , sourcePath: "/temp/Push/" + fileName /* STRING */ }); moveFileComplete = true; } catch (err) { moveFileComplete = false; pause(29999); //pause to ensure file extraction is complete before restarting loop } } while (!moveFileComplete); http://support.ptc.com/help/thingworx_hc/javadoc/com/thingworx/things/repository/FileRepositoryThing.html#ExtractArchive(java.lan

Can Thingworx Applications hosted on IIS or Apache Web Server? If load Balancer has to be eliminated. Kindly share some information.

There are 2 tree grids in container. If i selected 8th row in first grid, automatically 8th row in second grid should get selected and vice versa. How to do this?

 Hello ThingWorx community members,!As part of our continuous efforts to improve our offerings, ThingWorx product management regularly reviews the software deliverables we provide to our customers as well as how we do so. As we had notified ThingWorx users with more than a year's advance notice via this Knowledge Base article, community post, and Product Release Calendar "standard support end dates" that the below three extensions will be discontinued past their End of Standard support date, we’d like to inform you that these are no more available for downloads from PTC Software Download portalThingWorx CSV Parser ExtensionThingWorx Twilio ExtensionThingWorx Google Widgets ExtensionHenceforth, customers desiring fulfillment of the use cases served by the three extensions as well as formal support would need to contact PTC partner- IQNOX.The latest versions of these extensions compatible with the ThingWorx 9.3.4 release are also available for community usage attached to this a

Hello.I have added reference lines to my chart but i cannot see the labels. Also, anyway to customize the colors for each reference line? I am using ThingWorx 9.3.2-b411 

Hello @Pedro_Sanchez ,   Same kind of problem we are also facing now in v9.1.   if you got any resolution for this case, kindly share with us, which will be of great help   thanks