This Use Case is an extension of the Get change data values for a source table use case and it gets all the changes that exist in the Change Tracking table for a given source table, for a specific time range.

Step 1 is the same as the example in Get change data values for a source table.

Step 2 uses the SQL query to get a Result Set of change values, as needed by the application.

select c.*                                           -- specify Change table fields here.
from   pub."_Cdc-Change-Tracking" ct
inner join
       pub.CDC_Customer c                -- well-known Change table name.
          on ct."_Change-Sequence" = c."_Change-Sequence"
where  ct.”_Source-Table-Number" = ?            -- from 1st query.
and    ct.”_Time-Stamp” between ? and ?   -- time range parameters from app
order by ct."_Source-Table-Number", ct.”_Time-Stamp”, 
         ct."_Change-Sequence";