Hi. I try to design database for 'followers' ...

expressions
(서동빈) #1

Hi. I try to design database for ‘followers’ and ‘followings’.

I have Member, Follow Table. Member has columns like Email, Nickname, Sex, Age, etc… ( key is Email ) Follow has columns Email, FollowerEmail. ( key is concatnate with Email, FollowerEmail ) Two columns reference the Email of Member. In other words, Parent is Member and Child is Follow.

I want to use LinkToFilteredView expression in action like LinkToFilteredView(“Member”, [Email].Follow[Email] = useremail()) to see only my follower ( This expression is virtual to explain my intend ) and

LinkToFilteredView(“Member”, [Email].Follow[FollowerEmail] = useremail()) to see only lists I following. ( Just intended expression ) Of course, The above expression is impossible. Because I think this app support not Accessing a Column in a Child Record ,but Accessing a Column in a Parent Record.

So, Is there access a column in a child record by expression? Have a good day!

(서동빈) #2

I try other methods not use reference relation. LINKTOFILTEREDVIEW(“People”, [Email]= any(select(FollowRelation[FollowerEmail], [LeaderEmail] = useremail()))). but this expression is only one row mapping because of any().

(Aleksi Alkio) #3

You could check if related follower contains user’s email address… something like LINKTOFILTEREDVIEW(“Member”,IN(CONCATENATE([Email],USERMAIL()),[RelatedFollowers]))

(서동빈) #4

This is correct! Thank you!

(Aleksi Alkio) #5

You’re welcome