search

arch-kiosk / arch-kiosk-office

💼 central place for collaboration
GNU Affero General Public License v3.0
1 stars 0 forks source link

CQL: selecting field by identifier instruction although it is applied to more than one field #2321

Open urapadmin opened 11 months ago

urapadmin commented 11 months ago 
          okay, the query was a CQL query selecting an additional field like this:
          locus_identifier:
            field_or_instruction: locus.identifier()
            default: ""

The issue here is that the locus table has more than one field marked as identifier(), although one of them is in fact marked as identifier("additional") but that does not seem to matter:

locus:
  structure:
    1:
      arch_context: [datatype(VARCHAR), identifier(), skip_index_on("hidden"), label("locus")]
      alternate_id: [datatype(VARCHAR), identifier("additional"), skip_index_on("hidden")]

The result is an error message like this: ´´table {table} has more than one field with instruction {field}. That is not supported by KioskContext, right now.")``

If have solved it for now in the query by switching to locus.arch_context but will make this a ticket since it could be solved.

Originally posted by @urapadmin in https://github.com/arch-kiosk/arch-kiosk-office/issues/2313#issuecomment-1784264671

urapadmin commented 11 months ago

In this case I think it should be able to select the field with the primary identifier and ignore the "additional" identifier.