Thank you all for jumping on this issue. I truly appreciate.
I had to write a Report module that:
- Aceepts a list of records, and a list of keys in order I want.
- Loops throuch each record and map it with
Map.get(record, ordered_key, "")
records = [
%{
"Annual Leave" => Decimal.new("21"),
"Compassionate" => Decimal.new("14"),
"emp_no" => "EMP001",
"names" => "Jane Doe"
},
%{
"Annual Leave" => Decimal.new("10"),
"Compassionate" => Decimal.new("5"),
"emp_no" => "EMP002",
"names" => "John Smith"
}
]
Report.format(records, ["names", "emp_no", "Annual Leave", "Compassionate"])
Gives
[
%{
"names" => "Jane Doe",
"emp_no" => "EMP001",
"Annual Leave" => 21,
"Compassionate" => 14,
},
%{
"names" => "John Smith",
"emp_no" => "EMP002",
"Annual Leave" => 10,
"Compassionate" => 5,
}
]
