update trans custom query