Hi OF Team,

I included a short species list in my survey, imported data and would like to show the recorded species grouped by another variable in Saiku (OF Collect). However, clicking the filter of the scientific name or code variable shows an empty box. When I try to group species according to another variable, I get the following error:

SQLiteException: [SQLITE_ERROR] SQL error or missing database (no such column: household_view.fw_species_code)

Any hint that could help?

Thanks a lot!!

asked 09 Jul '19, 13:41

wexxo's gravatar image

accept rate: 0%

Dear Alex,
The problem can be related to the use of a multiple "Taxon" attribute, that is not yet fully supported by the Saiku database generator.
Please try to convert the structure of your schema into a multiple entity with a single Taxon attribute inside of it.
Many thanks,
Open Foris Team

permanent link

answered 02 Aug '19, 12:17

OF%20Collect's gravatar image

OF Collect ♦♦
accept rate: 23%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 09 Jul '19, 13:41

question was seen: 879 times

last updated: 02 Aug '19, 12:17