Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
urapadmin opened this issue Oct 29, 2023 · 1 comment
Assignees
Labels
kiosk a kiosk issue (not a filemaker issue) new-issue issue needs to be reviewed and labels and projects need to be added. Remove afterwards.

Comments

@urapadmin
Copy link
Collaborator

          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 #2313 (comment)

@urapadmin urapadmin changed the title CQL: selecting field by a dsd instruction that is applied to more than one field CQL: selecting field by identifier instruction although it is applied to more than one field Oct 29, 2023
@urapadmin
Copy link
Collaborator Author

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

@urapadmin urapadmin added kiosk a kiosk issue (not a filemaker issue) new-issue issue needs to be reviewed and labels and projects need to be added. Remove afterwards. labels Oct 29, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kiosk a kiosk issue (not a filemaker issue) new-issue issue needs to be reviewed and labels and projects need to be added. Remove afterwards.
Projects
None yet
Development

No branches or pull requests

1 participant