Replace the Boolean Characters from SQL as Text in Rails

Question

Dear All,

I am having a data of boolean datatype values such as True/False in sql database column. I created an array of T/F using the find_by_sql (select) options. Now I need to print the array not as True/False. Instead of that I have to print "It Occurs", if data populated as True. nothing should be printed if it is false. How I can prints the alternative values of column of sql without changing the table.

TRUE = "It Occurs" FALSE = ""

Advance Thanks Palani Kannan

Answer 1

You can do it in your select statement...

SELECT if(column=1,"It Occurs","") as display_text FROM somethings ...

Or if you need to do it after the fact, use #map on the array:

array_as_text = array.map{|x| x ? "It Occurs" : ""}

Either way you should end up with something like: ["It Occurs","","","It Occurs"]

If you want to provide more details to get a clearer answer, you should do so.

Answer 2

Dear All,

Its working with this script,

Table Model

def combined_value if col == true "Conditions" else "Conditions" end end

Table View <% @table.each do |table| %> <%= table.col%>

Thanks for giving ideas to everyone in this discussion