'@case: mem004-05
@description: Search Members - Advanced Search by State / Province'

def test_mem004_05_member_search_advance_by_State_Province(self):

    self.start()
    self.advancedSearchTest(['Baucau', 'Ermera'])
    member = current.s3db['member_membership']
    loc = current.s3db['gis_location']
    dbRowCount = current.db((((member.deleted != 'T') & (member.location_id == loc.id)) & ((loc.L1 == 'Baucau') | (loc.L1 == 'Ermera')))).count()
    self.compareRowCount(dbRowCount)
