'@case: mem004-07
@description: Search Members - Advanced Search by City / Town / Village'

def test_mem004_07_member_search_advance_by_City_Town_Village(self):

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