Quality Iron - Customer
select customers.*,
date_format(convert_tz(created,'UTC','America/Los_Angeles'), "%W, %M %D, %Y %l:%i%p") as created_date,
users.name as owner_name
from customers
join users on customers.owner=users.id
where customers.id=$[@_selected_customer_id]
$[sqlerror]
CUSTOMER ($[.name])
Edit
JOBS
select *,
customers.name as customer,
contractors.name as contractor
from jobs
join customers on jobs.customer_id=customers.id
join contractors on jobs.contractor_id=contractors.id
join status on jobs.status_id=status.id
where customer_id=$[@_selected_customer_id]
order by contractor$[sqlerror]
Jobs
|
Job Number |
Contractor |
Insurance |
Status |
| Open |
$[.job_number] |
$[.contractor]  |
$[.insurance] |
$[.description] |