I am using SQL data export tool and i have the following issue.
How to retrieve single row of data, with most updated data across all columns for a beneficiary. Currently, new update to even one parameter creates new row, but doesn't update the form itself. This becomes difficult when one has to know the most recent update made to the form.
Hass anyone achieved this? Please help
Hi,
It sounds like you are exporting Forms from the export tool, which will include all form records for your project.
An alternative would be to export Case records with the export tool, which will always update with the most recent case record, and only include one row per case.
-Clayton