In Ruby on Rails, you may face the issue when you try to use .where with array but your expected result is sorted by your input array. Because in Rails the result of .where is sorted by id in default.
In this blog post, I’m going to share quick tips by using array_position to get your result sorted by input array.
Here is the data we prepared for demonstration of using array_position. A table called fruits with five different of fruit.
#<ActiveRecord::Relation [
#<Fruit id: 1, name: "Apple", quantity: 20, created_at: "2021-09-12 16:33:55", updated_at: "2021-09-12 16:33:55">,
#<Fruit id: 2, name: "Orange", quantity: 10, created_at: "2021-09-12 16:34:07", updated_at: "2021-09-12 16:34:07">,
#<Fruit id: 3, name: "Watermelon", quantity: 30, created_at: "2021-09-12 16:34:32", updated_at: "2021-09-12 16:34:32">,
#<Fruit id: 4, name: "Banana", quantity: 40, created_at: "2021-09-12 16:34:49", updated_at: "2021-09-12 16:34:49">,
#<Fruit id: 5, name: "Kiwi Fruit", quantity: 50, created_at: "2021-09-12 16:35:05", updated_at: "2021-09-12 16:35:05">
]>First, we are using this ruby code to query these three fruits. Banana, Kiwi Fruit and Orange.Fruit.where(name: ["Banana", "Kiwi Fruit", "Orange"])
and here is the result
#<ActiveRecord::Relation [
#<Fruit id: 2, name: "Orange", quantity: 10, created_at: "2021-09-12 16:34:07", updated_at: "2021-09-12 16:34:07">,
#<Fruit id: 4, name: "Banana", quantity: 40, created_at: "2021-09-12 16:34:49", updated_at: "2021-09-12 16:34:49">,
#<Fruit id: 5, name: "Kiwi Fruit", quantity: 50, created_at: "2021-09-12 16:35:05", updated_at: "2021-09-12 16:35:05">
]>You can see that even your input array is ["Banana", "Kiwi Fruit", "Orange"] but the result is sorted by ID. Is there a way to sort the result by the input array? You can use array_position. We can just make a smaller change to achieve.
fruits = ["Banana", "Kiwi Fruit", "Orange"]
# fruits.map { |x| "'#{x}'" }.join(',') used to convert array to string 'Banana', 'Kiwi Fruit', 'Orange'
Fruit.where(name: fruits).order("array_position(ARRAY[#{fruits.map { |x| "'#{x}'" }.join(',')}], name::TEXT)")Here is the ActiveRecord result
#<ActiveRecord::Relation [
#<Fruit id: 4, name: "Banana", quantity: 40, created_at: "2021-09-12 16:34:49", updated_at: "2021-09-12 16:34:49">,
#<Fruit id: 5, name: "Kiwi Fruit", quantity: 50, created_at: "2021-09-12 16:35:05", updated_at: "2021-09-12 16:35:05">,
#<Fruit id: 2, name: "Orange", quantity: 10, created_at: "2021-09-12 16:34:07", updated_at: "2021-09-12 16:34:07">
]>as you can see you can use array_position to sort the record by array.
What if I’m using MySQL?
you can use field to sort the result
fruits = ["Banana", "Kiwi Fruit", "Orange"]
Fruit.where(name: fruits).order("field(name, #{fruits.join(',')})")
50 thoughts on “Using array_position to Sort ActiveRecord Records By Array”
Some paintings are being sold at the London Exhibition for millions of dollars. This is the first digitized NFT version of Dr. Hans Prinzhorn’s collection – https://opensea.io/collection/hans-prinzhorn
WHAT TO KNOW BEFORE BUYING MINA?
Alrighty, in previous articles we figured out the functionality.
Let’s now take a look at the advantages of such a blockchain system, besides its size.
The first advantage of the Mina protocol is the high confidentiality of user data.
Other blockchains, like Ethereum, do blockchain computations.
Source: https://cryptoine.com/how-does-mina-work-exactly/
Superb blog!! I dare give a title like this. Visit https://takemycoursesforme.com/ for online educational courses and classes.
Learn Programming free…visit https://www.codeforhunger.com
Perfct
For cryptocurrency farming and staking use unifarm. https://unifarm.co
I swear I don’t get a thing about array positioning. Few minutes before I was thinking of how difficult my subject of marketing is and I need to buy https://dissertationsky.co.uk/tourism-and-hospitality-dissertation-topics/ . But after reading your post; I guess I was just being a cry baby and need to focus a little bit more on my studies.
Cryptocurrency is the best for the world today, but @unifarm stand out in all. http://www.unifarm.co
Cryptocurrency is the best for the world today, but @unifarm stand out in all.
Use this link http://www.unifarm.co
Have you heard of Unifarm? The best coin with staking innovation in cryptocurrency farming. http://www.unifarm.co
FREE MINING COIN ON PHONE
REMITANO the largest cryptocurrency exchange in Southeast Asia
Free RENEC COINS MINING on your phone
Link Earn RENEC: https://bit.ly/3mDpGn7
With only 3 steps and 30 seconds a day, you can mine RENEC coin completely free. RENEC coin value can be up to $50/coin
Thank you so much for explaining to us array_position and how we can sort ActiveRecord manually. In this wonderful way, not only will we be able to save time, but we will also be able to bring maturity to our work. https://blogswire.com/narrative-writing-tips-and-rules-you-must-follow/
METAMUSK team is launching the first token Airdrop of 500kk METAMUSK (≈2.5 BNB). Get on official website –> muskmetaverse.me
METAMUSK team is launching the first token Airdrop of 500kk METAMUSK (≈2.5 BNB). Get on official website –> https://muskmetaverse.me
https://t.me/best_airdrop_her
#Airdrop #BTC #bounty #cryptocurrency #BNB #ethereum #trading #binance #crypto_Holder #ايردروب #BSC #TRX #Fx #forex
During this period of uncertainty in the crypto market, we need the help of an expert in the form of a financial advisor that specializes in beating the market makers and maximizing profits for clients. Contact Mr Kyle Morgan on whatsapp +12087322211
He is trustworthy. Verified ✅
We Introduce Bomber Jackets In United State With Premium Quality Leather Used In Making Leather Jackets https://bomberjackets.us/product/skeleton-woolen-varsity-jacket
Grab Amazing Leather Jacket and Cosplay Jacket from our Store with free shipping world wide and extra gifts like TShirts https://grabjackets.com/product/half-black-half-white-leather-jacket
We Are The Best EIN Service Provider In US. https://einhelp.us
Howdy an greatly immense much recognized from my side for you. The compelling and obligatory web journal you’ve got composed for us. More regularly than not basic for the journalists and understudies as well. i will be related with you people bunches to start an bewildering web journal like this.
iPhone Home Button Replace
thanks
Presently i have come to on a right goal. I am giving the surety you may be type in a important and graphic data for our perusers yellowstone merchandise . We receive a information & that will be more supportive for us in a future. Trust you may fulfill our perusers by pass on a right data.
The compelling and obligatory web journal you’ve got composed for us.
Thank you for your post. I have read through several similar topics! However, your article gave me a very special impression, unlike other articles. I hope you continue to have valuable articles like this or more to share with everyone! poppy playtime
You are in the right place at the right moment. Football Club The Washington Commanders Varsity Jacket We offer the perfect outwear for you that will not only keep you warm in the Siberian winds, but will also improve your attractiveness and make your personality spicy and peppery. Furthermore, because of its trendy features, it helps you stand out in a crowd.
Array is very useful if you were to use it properly but not everybody knows how to us it.
This is an excellent article! I am very eager to see your rather beneficial information. Other than that, this is a great blog with loads of useful information. Keep up the great work you’re doing here!
scribbl io
This is the first time that I visit here. I found so many exciting matters in this particular blog,
Site : Arkam batman jacket
This is an excellent article!
I looked on the internet for Snoop Dogg Clothing in my price range but couldn’t find anything, so a buddy suggested I go on Hit Jacket. I quickly spotted this Snoop Dogg Clothing on Hit Jacket at a fair price and purchased it. It was arrived today, and it is beautifully made with high-quality materials and a perfect design.
Are you looking for a fun online game? Then, Wordle game online is surely the best choice for you. This game will give you six chances to guess a random word. Let’s try to play it with your friends now!
I searched the internet for a ms marvel kamala khan jacket in my price range but came up empty-handed, then a friend recommended Vjackets. I promptly found this ms marvel kamala khan jacket on Vjackets and ordered it for a reasonable price. It came today, and it is exquisitely constructed with high-quality materials and a flawless design.
I have bookmarked your blog, the articles are way better than other similar blogs.. thanks for a great blog!
Lady Gaga Top Gun Jacket
this is often a requesting presently mens black biker leather jackets a days and it can enhance the reality level of upgrade which is able be more profitable for us.
You could add a cached order column to your database custom dissertation help table if the order of the array is always the same.
RSI is a technical analysis tool that calculates the strength of an asset, in this case, bitcoin. When bitcoin rsi reaches a certain point, the asset is considered to be oversold, and therefore likely to go down in price. However, it is not a holy grail in the markets, and you should always remember that RSI does not always provide good signals. However, if you use it correctly, it can help you predict price moves.
The role of a cryptocurrency market making is crucial for the successful operation of a crypto exchange. Market makers are responsible for facilitating tight markets through reduced friction and tight spreads. They also facilitate the availability of crypto assets in the market, making them more attractive to traders. While exchanges act as venues for trade, they are insufficient without market makers to provide the liquidity necessary for tight order books. As a result, they play a vital role in the efficiency of the trading experience and price discovery.
I’m very curious about how you write such a good article. Are you an expert on this subject? I think so. Thank you again for allowing me to read these posts, and have a nice day today. Thank you. 호치민 가라오케
wordle website is the most interesting word search game today, there are 4 to 11 letters hidden in the squares and your main task is to find it to complete a complete and most accurate word as required. demand of this game. You have a maximum of six guesses and if the answer is wrong, you have to wait until the next day to start this game again.
I want to be able to sort my
Postrecords by the contents of this array.Check Pre-Employment Assessments Help You Make Right Decisions
Not only is your site informative, but it’s also really creative. I looked over and gave what you said some thought. I have it bookmarked and plan to review fresh content. Well done for creating such a helpful website.
Approximately 97% of students in the UK say they detest dissertations, according to a survey. However, nobody actually likes writing dissertations. This is because they call for extensive investigation from the pupils. Don’t worry, though, if that applies to you as well. This is so that Dissertations Land can help you with all of your academic problems. With the aid of our Law dissertation Writers, you can easily get great benefits. Additionally, you may simply get top grades for your dissertation.
Java developers https://onlinefreelancejobs.net/java-job/ are in high demand, so how do you land one of the top jobs? There are a few key things you need to know. The first is what you should know about the job market and where to look. You can also find the latest job openings in your area by checking out websites and job boards. Once you’ve narrowed down your job search to a few top companies, you can start submitting your resume.
Our Assignment Writing Services in UK are our most significant asset, so we give them all of our time, energy, and resources. They need constant oversight from a team of knowledgeable and experienced proofreaders who will check your work several times for each criterion to assure the greatest level of quality.
thank you it worked for me a lot
Thank you so much for your wonderful essay, and best of luck to you in the future. I hope you’ll keep writing in this style. The Star Trek Season 2 Picard Patrick Coat was inspired by the “Star Trek Season 2 Picard Coat” television series and actor Patrick Stewart’s portrayal of the fictional character Jean Luc Picard.
Shop this best quality Doom Patrol Crazy Jane Jacket For women SHOP NOW….
Thetradebuzz is one of the top B2B marketplace to connect with international manufacturers, suppliers, buyers, and importers to trade online via our B2B website for export & import!
Law Writers is a social site that protects your legal rights.