update queries to return data retention