9 lines
414 B
SQL
9 lines
414 B
SQL
CREATE OR REPLACE VIEW "public"."joblines_status" AS
|
|
SELECT j.jobid,
|
|
j.status,
|
|
count(1) AS count,
|
|
j.part_type
|
|
FROM joblines j
|
|
WHERE ((j.part_type IS NOT NULL) AND (j.part_type <> 'PAE'::text) AND (j.part_type <> 'PAS'::text) AND (j.part_type <> 'PASL'::text) AND (j.part_qty <> (0)::numeric) AND (j.act_price <> (0)::numeric) AND (j.removed IS FALSE))
|
|
GROUP BY j.jobid, j.status, j.part_type;
|