@cwvega76 Hi there.
OK as I mentioned above. If you have your dataset attached to the repeater and its elements then your code will not change anything.
To do what you want to do you need to you need to disconnect the bindings that you have between the dataset and the repeater and load the repeater in code.
The bindings I referred to are the Connect Repeater dialogue and also the ones that attach each element to the dataset:
If these are connected AND we want to used code to change the repeater values then you will get an unexpected result in the repeater. 
OK so let’s follow my directions above.
First let’s just load all of the CV Registry History.
NOTE: This code assumes that you have a manageable amount of data. If you have more than a thousand records in your VIN data collection then you will need to adapt the code to display content in pages.
We don’t need to filter the data (we can’t really filter the way you need to) so we will load it and then filter it once loaded.
wixData.query("CV-History-Registry")
.descending("date") // Sort: assuming that the Date column is populated by a date field from the data collection
.limit(1000) // You have
.find()
.then((result) => {
let filteredRegistry = []; // Initialize the results list we need
let uniqueColumnValue = ""; // Used to filter out the secondary dash_no records
// Loop through the result list and remove unwanted records
for (let i = 0 ; i < result.items.length ; i++) {
let itemUnderTest = result.items[i];
// Check to see if we have see the dash_no before
if (uniqueColumnValue === itemUnderTest.dash_no) {
// We have seen a record with this dash_no before so skip this one
continue;
}
// If we get here we have a unique (possibly the first of a list) item record
filteredRegistry.push(itemUnderTest);
// Remember the dash_no
uniqueColumnValue = itemUnderTest.dash_no;
}
// The registry is now filtered
});
OK now we should have removed the unwanted items so lets display the items in the repeater. The code below goes below the last comment in the find() request above.
// The registry is now filtered
// Give the filtered list to the repeater to work with
$w('#repeater1').data = filteredRegistry;
// Now Update the repeater view
$w('#repeater1').forEachItem(($item, itemData, index) => {
// Load the repeater element values
$item('#<dash number element ID>').text = itemData.dash_id;
$item('#<vin number element ID>').text = itemData.vin_no;
...
});
NOTE: You need to use the correct element name in the repeater for and the same for .
This can all be put in your onReady function like this:
$w.onReady(() => {
// We return this which will delay page rendering until the data is ready
return wixData.query("CV-History-Registry")
.descending("date") // Sort: assuming that the Date column is populated by a date field from the data collection
.find()
.then((result) => {
let filteredRegistry = []; // Initialize the results list we need
let uniqueColumnValue = ""; // Used to filter out the secondary dash_no records
// Loop through the result list and remove unwanted records
for (let i = 0 ; i < result.items.length ; i++) {
let itemUnderTest = result.items[i]; // Check to see if we have see the dash_no before
if (uniqueColumnValue === itemUnderTest.dash_no) {
// We have seen a record with this dash_no before so skip this one
continue;
}
// If we get here we have a unique (possibly the first of a list) item record
filteredRegistry.push(itemUnderTest); // Remember the dash_no
uniqueColumnValue = itemUnderTest.dash_no;
}
// The registry is now filtered
// Give the filtered list to the repeater to work with
$w('#repeater1').data = filteredRegistry;
// Now Update the repeater view
$w('#repeater1').forEachItem(($item, itemData, index) => {
// Load the repeater element values
$item('#<dash number element ID>').text = itemData.dash_id;
$item('#<vin number element ID>').text = itemData.vin_no;
// Assign other elements ...
});
});
});
Hope this helps
Steve
