def testTypeOfLookupTableMultipleWildcard(self):

        db = current.db

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

        # Test with field in hierarchy table, with wildcard
        expr = FS("typeof_hierarchy_id$name").typeof(("Type 1-1-*", "Type 2-1*"))
        query = expr.query(resource)

        table = db.typeof_hierarchy
        expected = set(uids[uid] for uid in ("HIERARCHY1-1-1",
                                             "HIERARCHY1-1-2",
                                             "HIERARCHY2-1",
                                             "HIERARCHY2-1-1",
                                             "HIERARCHY2-1-2",
                                             ))
        expected_query = table.id.belongs(expected)

        self.assertEquivalent(query, expected_query)

    # -------------------------------------------------------------------------
generated source for method execDetailsEnd
dataset/ETHPy150Open sahana/eden/modules/unit_tests/s3/s3hierarchy.py/S3TypeOfTests.testTypeOfLookupTableMultipleWildcard--crossover with--dataset/ETHPy150Open CarterBain/Medici/ib/ext/EWrapper.py/EWrapper.execDetailsEnd