43 replies

Autotable Filtering on JSON field

Hi everyone,

I have an autotable that is querying the shopifyOrder model. I have added a productTags field to that model, which grabs the product.tag(s) from shopifyOrderLineItems and writes the array to a JSON field on the shopifyOrder model. I am trying to filter the autotable to exclude specific product tags which a user selects, but I am having issues with the filter because there is no functionality

notMatches

notMatches

. Because the productTags can be an array ['tag1', 'tag2', 'tag3'], and the selected might only be one: ['tag3'], there is not a good way to handle the exclusion. I have created logic to take the full tag list, remove the selected tags, and then use

matches

matches

to filter to only the selected tags, but now I also need to handle all other cases such as empty string, null, empty array, etc.

Currently this filter filters out all records with ANY tags when there are selected tags. I am not sure what is wrong here or if there is a better way:

  ...(selectedTags?.length > 0 && {
      OR: [
          {
              productTags: {
                  matches: includedTags,
              },
          },
          {
              productTags: {
                  equals: null,
              },
          },
      ],
  }),

  ...(selectedTags?.length > 0 && {
      OR: [
          {
              productTags: {
                  matches: includedTags,
              },
          },
          {
              productTags: {
                  equals: null,
              },
          },
      ],
  }),

Autotable Filtering on JSON field

notMatches

notMatches

matches

matches

  ...(selectedTags?.length > 0 && {
      OR: [
          {
              productTags: {
                  matches: includedTags,
              },
          },
          {
              productTags: {
                  equals: null,
              },
          },
      ],
  }),

  ...(selectedTags?.length > 0 && {
      OR: [
          {
              productTags: {
                  matches: includedTags,
              },
          },
          {
              productTags: {
                  equals: null,
              },
          },
      ],
  }),

Autotable Filtering on JSON field

Similar Threads

Autotable Filtering on JSON field

Similar Threads

Similar Threads

Similar Threads