Retrieve data from database and use it in a table view (CWC) - WinCC Unified

Hi,

i have an async function that interacts with a database (mssql) through stored procedures, and as return value, it creates a JSON object from the retrieved records.

When I trigger the function to use a stored procedure with a SELECT instruction, I get the records I need inside the async function.

I want to use these records in a table view (CWC) by setting a property of that table view, by the click of a button.

The problem is that when i click de button, the records I get from this async function are undefined. I know it has something to do with the way i need to call an async function. But so far i had no succes on trying different methods.

Can anyone help me with getting the right code for this button.click event?

Thanks in advance,

Bert

 Hi,

I'm doing the same thing and it works for sure but to make it work at first might be a bit tricky.

The easiest way to find the source of problem with unified runtime is to use the debugging tool of your browser.

First you're gonna need to enable the debugger from runtime manager.

Then if you're using chrome:

- Go to chrome://inspect/#devices - do so while the runtime is open or you won't have a target to connect to.

- Wait a little and select the link that says "Events"

- Finally put a break point in your button event script and push the button on the screen. The debugger will stop the script execution at your break point and show you what's going on inside the script environment.

You can inspect whether your result set is returned correctly or returned at all.

edit: here's a demonstration. I can inspect my local variables when the break point stops the script.

BertVanpee

Hi,

i have an async function that interacts with a database (mssql) through stored procedures, and as return value, it creates a JSON object from the retrieved records.

When I trigger the function to use a stored procedure with a SELECT instruction, I get the records I need inside the async function.

I want to use these records in a table view (CWC) by setting a property of that table view, by the click of a button.

The problem is that when i click de button, the records I get from this async function are undefined. I know it has something to do with the way i need to call an async function. But so far i had no succes on trying different methods.

Can anyone help me with getting the right code for this button.click event?

Thanks in advance,

Bert

Hi ender1adam,

Thanks for the help. I know how to use the chrome devtools now, with your post.

Now I can see the result of my stored procedure doesn't reach the calling function (button_clicked)... stil don't know why. But i keep trying.