How to create mapper with conditions

[Maggus85]

Hi
I have model

class Sensor 
{ 
    Guid ID,
    string Name,
    List< OwningOrganisation > Organizations
}

public OwningOrganisation(Guid OrganisationId, Guid? BuildingId, string Name, string? Description);

I created mapper

public SensorMapper : GridifyMapper<Sensor>
{
    public SensorMapper()
    {
        AddMap(nameof(SensorDto.Name), p => p.Organizations.Select(x => x.Name));
        AddMap(nameof(SensorDto.Description), p => p.Organizations.Select(x => x.Description));
        AddMap(nameof(SensorDto.BuildingId), p => p.Organizations.Select(x => x.BuildingId));
    }
}

I need to create query like where(x=>x.Organizations.Any(y=>y.OrganisationId== org **and gridify filter**)
Gridify filter can be provided, but is not mandatory )). condition y.OrganisationId== org need to be added always,

I there is possibility to create this query with gridify?

[alirezanet]

Hi @Maggus85,
for the static part of your query, you can use linq and combine it with gridify using one of the extension methods like ApplyFiltering

var org = ... (some value)
var query = dataSource
                .Where(q=>q.Organizations.Any(w => w.OrganizationId == org) ) // static query
                .ApplyFiltering(gridifyQuery)  // dynamic query
                .ToList();