Please help. Maybe I am going about this the wrong way. This is an oven log, pretty simple, mark order in and out and retrieve the temperatures for both operations. I would like an additional column added which is a progress bar showing the time remaining on the bake. I went through all the steps in…

Your data array (or dataset) looks like this: { "Work Order": "XXXXXXX", "Oven ID": "YYYY YYY YYY", "Quantity": N, "Time In": SomeDateValue, "Due Out": SomeOtherDateValue } You need it to look like this: { "Work Order": "XXXXXXX", "Oven ID": "YYYY YYY YYY", "Quanti…

Thank you for the detailed response. I am following, and I can recreate this when I hard code my data, but what I don't understand how to do is to manipulate that data once it has been grabbed by SQL. Any data properties I create are removed when I bind this to my SQL query. Is there a way to manip…

[image] ntheuer: Is there a way to manipulate the SQL to grab from a table but store a column as a dataset? You can add a script transform to the binding to manipulate the returned data into whatever format that you need.

You will need to bind your table’s data property with a Named Query binding, and then you’ll need to include a transform with that binding. You’ll need to iterate over each row of the dataset (or you can change the return type to JSON to make it easier) and construct your own array.

OK I couldn’t figure this out but I gave it a good solid try. I put it down for a little while and came back to it, and still can’t figure it out so I am revisiting the help section. I have tried recreating this every which way I possibly can. I tried the Ignition examples, but nothing I tried woul…

Wow. There's a lot to digest here... [image] ntheuer: why is the scripting languages such a hodgepodge of different languages? I can't even begin to list the reasons, but you have to understand that when you're dealing with many different pieces of software, you have to use languages that ea…

Awesome explanation. I can follow this programming much easier, and I can recreate, but now I have an interesting set of circumstances. When updating the code, I found that my progress bar would work as expected for only a brief period of time then stop working. Let me explain through my thought pr…

Don’t put your progress into a “value” object - just pass the progress object. The view you will be using MUST expect a value object as the param, but behind-the-scenes we are taking the data for the column and placing it into a value object ourselves. Your code would result in something like this a…

I agree about the dates. I have already checked my incoming dates format and the data as it is stored in the database, and both seem to match. It seems to be when the data is fetched by the query, for some reason, but I am not sure why it is grabbing them in different formats. I tried importing a c…

This was just the hint I needed to accomplish a similar task. Thanks for the detailed write-up.

Inductive Automation Forum

Pass parameter into embedded view table

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled