Search for projects and organisations

[pvgenuchten]

See also https://github.com/soilwise-he/soilwise-technical-requirements/issues/35

for the next iteration we hope to be able to query for projects, authors and organisations, should we include them as records on the general index, or should we create dedicated indexes for these types.

can we set up an experiment in SOLR where we introduce organisations in a dedicated index? As a source we can use this query:

SELECT distinct on (k.organization) k.organization, k.*
FROM records r, 
  json_to_recordset(cast(r.contacts as json)) as k(organization text, 
  name text, phone text, fax text, address text, city text, region text, email text, country text )
where k.organization is not null