Advanced AREL or just Rails Query for has_many through search by association

#team.rb
has_many :players_teams
has_many :players, :through => :players_teams

#player.rb
has_many :players_teams
has_many :teams, :through => :players_teams

Given I have two star players named “Lisa” and “Bo”, how would would I search the Team Model to find all the teams that have both Lisa and Bo on them, without looping through. All the has_many through query examples assume I’m only looking for the teams by one association attribute. But I want to search by an array. [“Lisa”, “Bo”].

Related Posts:

  1. Devise lockable – How to unlock account using unlock_in
  2. GROUP BY and COUNT using ActiveRecord
  3. api-ms-win-crt-runtime-l1-1-0.dll is missing when opening Microsoft Office file [closed]
  4. Istio Ingress resulting in “no healthy upstream”
  5. What is a LAMP stack?
  6. What is the difference between POST and PUT in HTTP?
  7. What and where are the stack and heap?
  8. What is a reverse shell?
  9. Why am I getting error for apple-touch-icon-precomposed.png
  10. How could I ping @here in Discord.py?
  11. What’s the syntax for mod in java
  12. warning javax.* types are not being woven because the weaver option ‘-Xset:weaveJavaxPackages=true’ has not been specified
  13. How to align iframe always in the center
  14. How to turn IDENTITY_INSERT on and off using SQL Server 2008?sql-server-2008
  15. How can I prevent java.lang.NumberFormatException: For input string: “N/A”?
  16. Xcode build failure “Undefined symbols for architecture x86_64”
  17. git : Pull is not possible because you have unmerged files
  18. C++ Error: ISO C++ Forbids Comparison Between Pointer and Integer [-fpermissive]
  19. Error ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired in oracle11g
  20. Where to get php_mcrypt.dll for PHP 7.2?
  21. AngularJS- Login and Authentication in each route and controller
  22. Rails: Why “sudo” command is not recognized?
  23. Does != have meaning in OCaml?
  24. How to concatenate two MP4 files using FFmpeg?
  25. R – Using str_split and unlist to create two columns
  26. Pythonic way to create a long multi-line string
  27. Download a specific tag with Git
  28. How does createOrReplaceTempView work in Spark?
  29. How to convert from unicode to ASCII
  30. Is there direct API for Google Meet?
  31. How to terminate the script in JavaScript?
  32. Using Pundit for all-access “super_admin” role
  33. jquery variable syntax [duplicate]
  34. How to tell if homebrew is installed on Mac OS X
  35. Git error on git pull (unable to update local ref)
  36. git status shows modifications, git checkout — doesn’t remove them
  37. How to clone all remote branches in Git
  38. If Python is interpreted, what are .pyc files?
  39. Default location of freepbx backup?
  40. ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying
  41. The specified DSN contains an architecture mismatch between the Driver and Application. JAVA
  42. Python FileNotFound
  43. When to use If-else if-else over switch statements and vice versa
  44. How can I reduce the waiting (ttfb) time
  45. PG::ConnectionBad: fe_sendauth: no password supplied
  46. What is the difference between clang (and LLVM) and gcc / g++?
  47. Simplest way to profile a PHP script
  48. bit vectors in c++
  49. ++someVariable vs. someVariable++ in JavaScript
  50. How to increase size of DOSBox window?
  51. How to set String’s font size, style in Java using the Font class?
  52. Too small initial heap error – stanford parser
  53. How can I run a Java program in Atom editor?
  54. Rails syntax error : unexpected keyword_ensure, expecting end-of-input
  55. All com.android.support libraries must use the exact same version specification
  56. How can I run a program from a batch file without leaving the console open after the program starts?
  57. What is the difference between “JPG” / “JPEG” / “PNG” / “BMP” / “GIF” / “TIFF” Image?
  58. How to specify the download location with wget?
  59. Error: “expected primary-expression before int”
  60. How do you detect where two line segments intersect?
  61. Sass::SyntaxError: File to import not found or unreadable: bootstrap-sprockets
  62. Get a list of URLs from a site
  63. How to get parameter value from query string?
  64. Uncaught ReferenceError: React is not defined
  65. Using a regex
  66. Beacon UUID vs BeaconLayout
  67. Binary Tree Height
  68. Curl incosistent behaviour – CLI vs Java process
  69. how to upload a file to my server using html
  70. Difference between Chocolatey and NuGet
  71. Regex multiple match substring
  72. How do I parse JSON with Ruby on Rails? [duplicate]
  73. In the following SAS statement, what do the parameters “noobs” and “label” stand for?
  74. How to make a redirection that fired a script before redirecting?
  75. Access Default Widget's Controls in Customizer Pane
  76. can you make changes to a theme in trac while it is waiting for review?
  77. Create post and update in the same flow [closed]
  78. Go top smooth function [closed]
  79. Block any other domains from using my server
  80. What is a Pem file and how does it differ from other OpenSSL Generated Key File Formats?
  81. How to set environment variable in systemd service?
  82. Symlink not updating as expected when using an absolute with relative path
  83. How to include multiple domains in an spf TXT Record
  84. Physically locating the server
  85. Good tools that fit on a thumb drive [closed]
  86. How do you answer yes for yum install automatically
  87. All servers flooded by salt water, is it possible to recover data from multi-platter drives?
  88. How to check if I’m in screen session?
  89. How to zip/unzip files in Powershell?
  90. Cooling Server Closet – No A/C Is Possible
  91. Is it better practice to buy RAID disks individually vs. in bulk?
  92. What range of MAC addresses can I safely use for my virtual machines?
  93. What sysadmin things should every programmer know?
  94. Why do systems generally disable virtualization by default in BIOS settings?
  95. 10 servers to administer and I’m a history major [closed]
  96. Making `wget` not save the page
  97. How do I list all connected Salt Stack minions?
  98. How to get Apache2 to redirect to a subdirectory
  99. What does that mean: packages excluded due to repository priority protections
  100. How can I set a short timeout with the ping command?

Leave a Comment