BSBI Distribution Database > message board

Group by habitat

Please report any problems with the website. Suggestions for changes are also very welcome.

Group by habitat

by AndyAmphlett » Sat Nov 16, 2019 9:41 am


the option to group records by attribute name > habitat doesn't seem to be working eg. ... b7e479ac97. There are records with habitat as a record attribute, and I am fairly certain this query used to work.


Posts: 408
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Group by habitat

by admin » Sat Nov 16, 2019 11:00 am


Thanks for reporting this problem. Import of data from Indicia had lead to duplication of attribute names, so that there were two versions of labels such as 'habitat' (a DDb one and an Indicia one). That was intentional, but I'd not tracked down all the knock-on effects. The change had confused the grouping query - which assumed that labels were unique. The query is working again.
Tom Humphrey
Database Officer, Botanical Society of Britain and Ireland (BSBI)
c/o Centre for Ecology and Hydrology,Maclean Building, Crowmarsh Gifford, Wallingford, Oxon, OX10 8BB, UK.
User avatar
Posts: 438
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Return to Bugs and suggestions