Transform results of a resource query

💬 App Building
1

I have a resource query getAllJobs.

SELECT id, job_number, job_weburi, client_company_name, client_weburi, property_address, property_city, coordinates, map, attachment_file_name, equipment_required, service_type, jobber_id, equipment_id, job_status
FROM public.jobber_jobs
WHERE job_status != 'deactivated'
ORDER BY jobber_jobs.job_number DESC;

I would like to transform the results. I have tried several ways to transform them but cannot get this to work. Here is my latest version.

return data.map(job => {
  return {
    id: job.id.value,
    jobNumber: `<a href="${job.job_weburi.value}" target="_blank">${job.job_number.value}</a>`,
    clientCompanyName: `<a href="${job.client_weburi.value}" target="_blank">${job.client_company_name.value}</a>`,
    propertyAddress: job.property_address.value,
    propertyCity: job.property_city.value,
    coordinates: job.coordinates.value,
    map: job.map.value,
    attachmentFileName: job.attachment_file_name.value,
    equipmentRequired: job.equipment_required.value,
    serviceType: job.service_type.value
  };
});

How can I get this to work?

2

Just as I ask the question it comes to me const formattedData = formatDataAsArray(data);.

const formattedData = formatDataAsArray(data);

return formattedData.map(job => {
  return {
    id: job.id,
    jobNumber: `<a href="${job.job_weburi}" target="_blank">${job.job_number}</a>`,
    clientCompanyName: `<a href="${job.client_weburi}" target="_blank">${job.client_company_name}</a>`,
    propertyAddress: job.property_address,
    propertyCity: job.property_city,
    coordinates: job.coordinates,
    map: job.map,
    attachmentFileName: job.attachment_file_name,
    equipmentRequired: job.equipment_required,
    serviceType: job.service_type
  };
});