Array Conditions and selecting specific fields to find or retrieve from database through Active records

Array Conditions

To retrieve some specific data from the database we use the where method which gets the records in the form of arrays.

• Now if a situation arises that we have to directly find from the form parameters then we would write a query like this

User.where("orders_count = ?", params[:orders])

This will go to the users table and find will retrieve the all the users who have orders till the count specified in the params[:orders] value coming from the form

• In case of multiple conditions where we want to find with more conditions then we can write like this

User.where("orders_count = ? AND active = ?", params[:orders], true)

This will go to the users table and find will retrieve the all the users who have orders till the count specified and all those who have active marked as true.

Selecting Specific Fields

Always by default .find method selects all the fields of the model and gives it back to us in the variable.

But if a condition arises when we need only some specific fields from the model then we can use the select method to do so. Below is the code to achieve it

User.select("name, age")