Alias with more than one value

General discussions

Moderators: Bob Cergol, Data Access, Cintac

Alias with more than one value

Postby Jacques » Tue Sep 27, 2011 10:12 am

Hi,
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
Jacques
 
Posts: 39
Joined: Tue Aug 30, 2011 5:30 pm

Re: Alias with more than one value

Postby Carsten Sørensen » Tue Sep 27, 2011 11:45 am

Should be in the documentation - but
@ALL
as alias value should do the job.

Best regards,
Carsten
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: Alias with more than one value

Postby admin » Tue Sep 27, 2011 11:56 am

Hey Jacques,

For even more options check this post on alias bundles.

viewtopic.php?f=3&t=170

Best regards
Bo
User avatar
admin
Certified Dynamic AI Professional
 
Posts: 177
Joined: Thu Jan 01, 1970 1:00 am
Location: Copenhagen, Denmark


Return to General discussions