Related to:

GatewaySQL, How to extract value from new updated rows on a dataview

Problem:

How can I extract the last row from a DataView that keeps appending new rows?

Solution:

You can extract the last row of your Dataview by using the Gateway-SQL plug-in to create a new, separate view.

Using this toolkit as an example:

We'll utilize the id(rowID) to extract the maximum value found and display it as a different dataview. 

To do this, go to your Gateway-SQL and add the XPATH of the dataview you've wanted to extract

Name your new data view and add the needed sql parameters:

Once applied, you should then see this on your dataview:

To test this, we've added a new row:


You should then see your GatewaySQL picking up the last row from the target dataview:

If you need further help:

• Please contact our support team via the chat service box on any of our websites or raise a support request.
  
• Make sure you provide us with:
  • Background of the issue or request.
  • Use cases, requirements, business impact, etc.
  • Encountered error messages.
  • Log files or diagnostic files.
  • Screenshots.
  • And other important information relevant to your inquiry.