Filtering results by user

[craig.a.p...@gmail.com]

Is it possible to define a condition rule that would restrict results based on some property of the user such as an agent or broker id?

I can see how to do this by setting up a group for each user or broker, but that's overwhelming for a large set of users.

[Mark Klein]

On Tuesday, April 8, 2014 5:08:48 PM UTC-7, Craig Pennington wrote:

Is it possible to define a condition rule that would restrict results based on some property of the user such as an agent or broker id?

I can see how to do this by setting up a group for each user or broker, but that's overwhelming for a large set of users.

if you can express your request with SQL, then yes, as the condition rules really become part of the the actual SQL query.

[Craig Pennington]

Thanks, Mark.

 

The issue is whether I can include in the SQL something that identifies the user accessing the RETS service.  I was thinking, for example, this could be handled if the SQL allowed for something like this:

 

    where agent_id = @USER

 

and when the SQL is processed, @USER would be replaced by the RETS user's id or name.