StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18775402
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-09-12T22:35:49.097
FavoriteCount
0
LastActivityDate
2013-09-12T22:56:16.497
LastEditDate
2013-09-12T22:56:16.497
LastEditorUserId
1714792
OwnerUserId
1714792
ParentId
15010929
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
A relational database and LINQ are poor starts for Faceting searching but I share your dream...What I see above doesn't look faceted to me in the technical hurdle sense as you can build up OR relationships dynamically to retrieve your results from the products table using PredicateBuilder. If I understand you want a query that checks a bunch of OR relationships per Alias combined with an OR relationship for each value. Any product that matches the alias and any one of the values is a match. If the alias doesn't match then you don't bother with the values. After you have generated the base query you do a group by to remove the duplicates. Here is an example of iterating a list of values and building up AND set of relationships query. In your case you would be building OR relationships between the aliases. In this case my queryBuilders contain a collection of values to match, I pass in the current Queryable because you need to chain the statements together. <pre><code> public static IQueryable<MeetingPayment> GetViewSpecificQuery(IQueryable<MeetingPayment> query, IInvoiceViewDetail viewToUse, IEnumerable<IInvoiceViewQueryBuilder> queryBuilders) { Expression<Func<MeetingPayment, bool>> predicate = PredicateBuilder.True<MeetingPayment>(); foreach (IInvoiceViewQueryBuilder builder in queryBuilders) { Expression<Func<MeetingPayment, bool>> predicateItem = builder.GetQuery(predicate, viewToUse); if (predicateItem != null) { predicate = predicate.And(predicateItem.Expand()).Expand(); } } return query.Where(predicate.Expand()); } </code></pre> This is an individual filter where an OR relationship is created between a collection of values as you are doing with 10g and 20g. <pre><code>public Expression<Func<MeetingPayment, bool>> GetQuery(Expression<Func<MeetingPayment, bool>> query, IInvoiceViewDetail viewToUse) { var ids = viewToUse.InvoiceStatuses.Select(x => x.Id).ToList(); if (!ids.Any()) return null; var predicate = PredicateBuilder.False<MeetingPayment>(); foreach (var id in ids) { int? closure = id; predicate = predicate.Or(x => x.InvoiceStatus == (InvoiceStatusEnum) closure); } return predicate; } </code></pre> Good luck.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POFaceted search in linq
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USHonorable Chow
UserOwnerUserId
1. USHonorable Chow
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUndeletion
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.