Filtering table by Guid Id and then by near

Working with Data Drivers
1

Hello,

I’m having difficulty filtering a table in C#. My goal is to first locate a row by a specific Guid Id in the primary column, and then, within that row, to search among a list in another column for elements that are within a certain radius of a specified position.

Here’s what I need to accomplish:

  1. Find a row using the Guid Id.
  2. Within that row, search in the ListItems column for items near a certain location using a radius filter.
  3. Return them.

Despite trying several approaches, I haven’t been able to make it work.

The table structure looks like this:

_id (UUID)
ListItems (list)

Inside ListItems, the structure is as follows:

``
[
{
“_id”: “8ef41c02-548f-4147-a164-5cd6509621f4”,
“Name”: “x”,
“SearchResultName”: “x (x)”,
“QuestionOptionId”: 2,
“Location”: {
“type”: “Point”,
“coordinates”: [
-121.157,
88.49834368
]
},
“FilterData”: {
“FacilityType”: “Daily Fee”
},
“CustomData”: {
“FacilityId”: 2625
}
},
…
]


I would appreciate any advice on how to filter the table by `Guid Id` and perform a proximity search within the `ListItems` column.

Thank you!