Project

General

Profile

« Previous | Next » 

Revision 11161

bugfix: schemas/vegbien.sql: locationevent__communities(): need to use commdescription instead of commname as the communityName because that's where communityName has been mapped to in mappings/VegCore-VegBIEN.csv. (commname instead stores the communityID.)

View differences:

schemas/vegbien.sql
827 827
CREATE FUNCTION locationevent__communities(locationevent_id integer) RETURNS SETOF text
828 828
    LANGUAGE sql STABLE
829 829
    AS $_$
830
SELECT commname.commname
830
SELECT commdescription
831 831
FROM      commclass
832 832
LEFT JOIN commdetermination USING (commclass_id)
833 833
LEFT JOIN commconcept       USING (commconcept_id)
834
LEFT JOIN commname          USING (commname_id)
835 834
WHERE locationevent_id = $1
836
ORDER BY commname
835
ORDER BY commdescription
837 836
$_$;
838 837

  
839 838

  

Also available in: Unified diff