Forum Discussion

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

Manipulating column on USERPRINCIPALNAME()

Hi all,   I want to make something like this:   TABLE: Field 1 Field 2 Field 3   This table must have a Field 4 which contains Field 1 if the logged in person is in Active Directory Group 'G...
Need Help
vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

out of curiosity why does combining the tables not work for you?

MiKeZZa's avatar
MiKeZZa
Post Patron
9 years ago

I think it will work, but it's not what I was hoping for. This gives me 2 'facttables', only for something easy (in other languages/tools) as this:

 

if (username IN (list of people that are manager)
{
           FieldA
}
else
{
           FieldB
}

So I'm still hoping to solve it another way, that is also easier to understand for other people at a later moment....