if j.job_type_name
j.type = j.job_type_name
elsif j.type.length > 1
# jty = Jobtype.find_by_id(j.type)
# We don't want to relentlessly hit the db for JobTypes, Colors, Priorities, etc. so we use the stored 'all' variable
jty = allJobTypes.find { |h| h['_id'] == BSON::ObjectId(j.type) }
j.type = jty && jty.job_type ? jty.job_type : 'N/A'
end
if j.priority_name
j.priority = j.priority_name
elsif j.priority
pri = Jobpriority.find_by_id(j.priority)
j.priority = !pri.blank? && !pri.job_priority.blank? ? pri.job_priority : 'N/A'
end
if j.job_type_name
j.type = j.job_type_name
e