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!
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().
You could check if related follower contains userโs email addressโฆ something like LINKTOFILTEREDVIEW(โMemberโ,IN(CONCATENATE([Email],USERMAIL()),[RelatedFollowers]))
This is correct! Thank you!
Youโre welcome
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |