I would still like to filter results based on some of the current users values for fields such as City or State. I also have other checkbox fields in my users accounts which I would like to match with the current user in order to display appropriate results for the list.
While I can write my own SQL to do this, is there a way I can grab the *current* users details/object/fields *within* the advanced filter box in order to build my query? And if not, is there a way/place I can hack in some code to make that happen? I will have over 6000 users in a professional directory where I would like to give regional results - based on the location of the currently logged-in user. Once I get that to work I can filter the results further based on other criteria in the logged-in users account.
Thank you for your time.