Unable to search in relationship table.

[amsantoki]

Hello Team,

I am creating a project using this architecture and feeling happy by using this.

I am unable to search in relationship table. Let me share a scenario so you can get better idea. There is a "Store" table and "Country" table where CountryId column is added in "Store" table. Now If I am trying to search by country name I can't. So do I have to add anything extra to search in relationship table. I checked in "SpecificationBuilderExtensions.cs" file where I can only find "Store" table column. I didn't see related table column. Please note that I have also added .Include(p => p.Country).Where(p => p.CountryId.Equals(request.CountryId!.Value), request.CountryId.HasValue) in my .....Spec.cs file.

Is it require to add foreign key constraint?

There is no issue while searching with individual table.

Please guide us

Regards,
Animesh

[fretje]

How exactly are you specifying your search criteria?

Try specifying AdvancedSearch (on the client) like this:

AdvancedSearch = new() { Fields = new[] { "country.name" }, Keyword = searchString }

[amsantoki]

Very useful answer. Thank you so much man, My issue has been resolved and it works.

[EreboCLN]

I have the same issue, can you share your solution?