Alias with more than one value
Posted: Tue Sep 27, 2011 10:12 amHi,
Is it possible to have an Alias which match more than 1 value ?
I mean, if a user is an administrator and want to see all records of a table where some forcefilter are on it, he has no possibility to do it.
I have tried to let no value on the alias but it doesn't work.
A solution would be a general word meaning that all is possible. If it were possible to put more than one value separated by semi-column, it would be a solution too.
In a dynamic SQL view it's possible to write "where '@alias1' = 'ALL" or '@alias1' = D.[A1]" but not in the forcefilter field.
Jacques
Is it possible to have an Alias which match more than 1 value ?
I mean, if a user is an administrator and want to see all records of a table where some forcefilter are on it, he has no possibility to do it.
I have tried to let no value on the alias but it doesn't work.
A solution would be a general word meaning that all is possible. If it were possible to put more than one value separated by semi-column, it would be a solution too.
In a dynamic SQL view it's possible to write "where '@alias1' = 'ALL" or '@alias1' = D.[A1]" but not in the forcefilter field.
Jacques