Compare elements nested in a list of the root object

[Robotxm]

Hello, I have following object definitions:

public record Item(string Name, List<TimeSchedule> Schedules);

public record TimeSchedule(int Start, int End);

Now I want to find all Items who has a schedule that its End time is before Start time.

With native LINQ I can do this:

List<Item> items =
[
    new Item("Item1", [new TimeSchedule(1, 2), new TimeSchedule(2, 3)]),
    new Item("Item2", [new TimeSchedule(1, 4), new TimeSchedule(4, 3)]),
    new Item("Item3", [new TimeSchedule(3, 2), new TimeSchedule(2, 3)]),
];

var results = items.Where(x => x.Schedules.Any(s => s.End < s.Start));

So how can I achieve this using Gridify?

[Robotxm]

I have tried following:

var mapper = new GridifyMapper<TrainDetails>(true)
    .AddMap("schedule.start", p => p.Schedules.Select(x => x.Start))
    .AddMap("schedule.end", p => p.Schedules.Select(x => x.End));

items.AsQueryable().ApplyFiltering("(schedule.end < schedule.start)", mapper);

But the linq expression generated is:

[Item].Where(p => ((p.Schedule!= null) AndAlso p.Schedules.Any(x => (Compare(x.End, "schedule.start", Ordinal) < 0))))

It seems that the field name on the position of value will not be mapped.

[alirezanet]

Hi @Robotxm,
I've created an issue of this discussion to look further and fix if there is any bug, you can follow the progress on issue #155.