SQLGridSelectedView (both V4 and V5) can accept as value from the URL and us it in the generated SQL. So, you can pass the USERID in the URL for the display, you can then use the associated value in the SQL Select.

For example, assume you want to pass the DotNetNuke UserID , then your URL might look like

www.mysite.com/.../default.aspx?UserID=123

The substitution parameter [Query:<keyname>:<defaultvalue>] is available to pass Query string parameters into the SQL Select. The <keyname> is the key in the key value pair passed on the URL, the defaultvalue is the value to be used if the <keyname> is not found. The default value is optional. Given the above URL, the primary SQL select command may look something like:

select * from mytable where userid = [QUERY:Userid:0]

This would result in the following SQL command being passed to the database for processing

select * from mytable where userid = 123

Hope this helps,
Paul.