def testTypeOfLookupTableNone(self):

        db = current.db

        uids = self.uids
        resource = current.s3db.resource("typeof_hierarchy_reference")

        # Test with None
        expr = FS("typeof_hierarchy_id$name").typeof(None)
        query = expr.query(resource)
        table = db.typeof_hierarchy
        expected_query = table.id.belongs(set())
        self.assertEquivalent(query, expected_query)

        # Test with list
        expr = FS("typeof_hierarchy_id$name").typeof([None])
        query = expr.query(resource)
        #table = db.typeof_hierarchy
        expected_query = table.id.belongs(set())
        self.assertEquivalent(query, expected_query)

        # Test with multiple values
        expr = FS("typeof_hierarchy_id$name").typeof([None, "Type 1-1-2"])
        query = expr.query(resource)
        #table = db.typeof_hierarchy
        expected_query = (table.id == uids["HIERARCHY1-1-2"])
        self.assertEquivalent(query, expected_query)

    # -------------------------------------------------------------------------
Search with Filter Block
dataset/ETHPy150Open sahana/eden/modules/unit_tests/s3/s3hierarchy.py/S3TypeOfTests.testTypeOfLookupTableNone--crossover with--dataset/ETHPy150Open Yipit/pyeqs/tests/functional/test_filters.py/test_search_with_filter_block