C
C#•2y ago
Pokey

Many to Many Matches and Exlusions

Hi there, I have 3 tables, Items, Tags and ItemTagMappings. Each item can have many tags, and each tag can be associated with many items. ItemTagMappings is a 3 column table with it's own ID as PK, and two FKs, the Item ID and the Tag ID. I have two lists of Tag IDs. Ones to match and ones to exclude. I need to find the list of items which has every single one of the includes, but if it has any of the excludes it shouldn't match. I have this working perfectly and fast with Includes only. Trying to get the excludes to work on top of that is nearing impossible. Please could I get some help?
1 Reply
Pokey
Pokey•2y ago
Resolved! If for any reason you ever come across this and want the answer, ping me like hell
Want results from more Discord servers?
Add your server
More Posts
Edit UsersI've created Web Application (with Authentication) from template. How can I create pages for Create/❔ When to use an Interface? Example?I'm not entirely sure what the difference between interface vs abstract class is. As far as I know iNeed help with creating a parking program (just text)i want to make a program where busses takes 2 parking positions, car takes 1 and biker takes 0,5 andSilly Question -How do I clone these grpc examples?https://github.com/dotnet/AspNetCore.Docs/tree/main/aspnetcore/tutorials/grpc/grpc-start/sample6 Off