How to online get list of items based on nested owner property

[JeanDanielGasser]

Hello,
In my application, I have two types of objects:

• Project object with an IsArchived property, each project contains one or more inspections
• Inspection object that is linked to the project via ProjectID and Project properties

I created the DataSync server, which implements the two controllers ProjectsController and InspectionsController that inherit from the TableController class
Everything works on the server side.

On the client side, I can retrieve the list of projects that are not archived using the following code:

var l_cClient = new DatasyncServiceClient<Project>(l_uUri, CreateHttpClient());
l_arpResult = await l_cClient.Where(X => X.IsArchived == false).ToListAsync();

I would now like to retrieve the list of all inspections contained in a project that is not archived.
The following code fails:

var l_cClient = new DatasyncServiceClient<Inspection>(l_uUri, CreateHttpClient());
var l_ariInspections = await l_cClient.Where(X => X.Project.IsArchived == false).ToArrayAsync();

Here is the exception:
System.NotSupportedException: 'The member 'IsArchived is not supported in the 'Where' clause'

Can anyone help me find a solution to this problem?

Thank you in advance for your help

[adrianhall]

There are multiple ways to do this, and it depends on your data model. I’d likely create a table of inspections with a project ID and is archived, then use .Where(inspection => inspection.IsArchived == false && inspection.ProjectId == “InterestingID”) - you can then link the ProjectId to the project information in the client.