Hi @bridget and @alcampopiano i just test this out and it seem to work well 
thank i just change some thing because one of my field (Client) is a link table and i need to look on field name “Nom” did you have a bether way to make it work ?
cols=app_tables.credential.list_columns()
def any_column_contains(text):
dictionnaire = {d[‘name’]:q.ilike(f"%{text}%") for d in cols if d[‘name’] != “Client”}
dictionnaire[“Client”] = q.any_of(*app_tables.client.search(Nom=q.ilike(f"%{text}%")))
query = q.any_of(**dictionnaire)
thank for help, this issue is resolve but i gona wait if some one have some thing to add before closing it (duno if some one can add someting when closed ) .
Thank all !!