example.sql

select * from list
where
  resource#>'{code,coding}'
  @> jsonb_build_array(
    jsonb_build_object(
      'system', 'http://physicianslab.com/fhir/List/testing-method',
      'code', {{params.teting-method}}),
    jsonb_build_object(
      'system', 'http://physicianslab.com/fhir/List/testing-category',
      'code', {{params.teting-category}}),
    jsonb_strip_nulls(
      jsonb_build_object(
        'system', 'http://physicianslab.com/fhir/List/batch-status',
        'code', {{params.batch-status}})),
    jsonb_strip_nulls(
      jsonb_build_object(
        'system', 'http://physicianslab.com/fhir/List/batch-id',
        'code', {{params.batch-id}})),
    jsonb_strip_nulls(
      jsonb_build_object(
        'system', 'http://physicianslab.com/fhir/List/batch-type',
        'code', {{params.batch-type}})))

  order by resource->>'date'
  limit  {{params.count}}
  offset {{params.skip}}

CREATE INDEX list_code on "list" using GIN ( ( resource#>'{code,coding}' ));