Sunday, March 11, 2012

dynamic filters

Does anybody know what will happen when I use different functions to filter
rows on articles (dynamic filters). In some articles I want to filter using
the HOST_NAME() function, in other rows I want to use the function
USER_NAME()
Is this possible or should this be avoided ?
Noel,
There shouldn't be any problem per se. What I could immediately think of and
suggest is that you look at any relationships that exist among these tables.
These 'might' cause some trouble, where rows in one article that match one
filter may not match with rows in another related table with another filter
(tricky!!, does this make sense?).
Raj
|||Thanks
My statement was not complete. What we need is the in one article we can
filter on host_name, in another article however, we need to filter on
User_name. So, it is not that we want to place to filters on one article.
"Raj Moloye" <rkmoloye@.hotmail.com> schreef in bericht
news:OrezH3HHEHA.3832@.TK2MSFTNGP10.phx.gbl...
> Noel,
> There shouldn't be any problem per se. What I could immediately think of
and
> suggest is that you look at any relationships that exist among these
tables.
> These 'might' cause some trouble, where rows in one article that match one
> filter may not match with rows in another related table with another
filter
> (tricky!!, does this make sense?).
> Raj
>
|||be careful with user_name(), this resolves to the user kicking off the
agent, which most frequently is your merge agent or distribution agent, and
not the account that the user is logged on with.
"Nol Thoelen" <noel.thoelen@.itomni.be> wrote in message
news:4073c410$0$2070$ba620e4c@.news.skynet.be...
> Thanks
> My statement was not complete. What we need is the in one article we can
> filter on host_name, in another article however, we need to filter on
> User_name. So, it is not that we want to place to filters on one article.
>
> "Raj Moloye" <rkmoloye@.hotmail.com> schreef in bericht
> news:OrezH3HHEHA.3832@.TK2MSFTNGP10.phx.gbl...
> and
> tables.
one
> filter
>

No comments:

Post a Comment