JSON Schema $or querySyntax should allow additional properties #3550

Activity

1. EmileSpecs commented on Nov 14, 2024

   

   EmileSpecs

   on Nov 14, 2024

   Last edited by EmileSpecs

   More actions

   Hi @ha6755ad

   Do I understand correctly though that you have gotten this to work?

   I can't get it to work, I get the error: "message: 'must NOT have additional properties'"

   I'm trying to query:

   query: {
   $or = [
         { reference: { $ilike: `%${search.value}%` } },
         { 'account.name': { $ilike: `%${search.value}%` } }
       ]
   }
   

   And my querySchema is defined:

   export const invoiceQuerySchema = Type.Intersect(
     [
       querySyntax(invoiceQueryProperties, {
         reference: {
           $ilike: Type.String()
         }
       }),
       // Add additional query properties here
       Type.Object({
         // Allow querying invoices by relations and specific context
         'account.name': queryProperty(Type.String(), {
           $ilike: Type.String()
         })
       }, { additionalProperties: false })
     ],
     { additionalProperties: false }
   )
   

   When I query 'account.name' outside of the $or it works fine, no error.
   Also using it inside the $or but commenting out the query validation hook also works.

   For me setting additionalProperties: true makes no difference, I still get the same error.

   So it's just a validation issue, it all works as expected.
   Can you provide an example of how you specified the relational query syntax?

   Thanks!