Forums - Thread Details
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 318 subscribers
  • Views 402 views
  • Users 0 members are here
Forum Actions
Related

how to enable search by follower where user could search by any sugar user?

Ron Lesh

Hello everyone.

I am currently on sugar 7.8.0.0. i have a user case where user want to easily find out all cases he/she currently following. since there is a many to many relationship, i was hoping there could by any option in studio where i could just drag the follower , or at least "my following" to the available search options. However, there is not such thing.

i also could not find any table that actually stores the many to many relationship between cases and users. Just wondering if any of you guys had come across the same user case? How could i add this kind of search filter?

I was thinking may be i could just add a custom filter called "My following", however, since i could not see the table which stores the relationships, i am not sure how could i write the "filter_definition" for it.

Could anyone offer some help? thanks a lot.

cheers,

Marc

Parents Reply
  • 0 in reply to André Lopes

    Hey André,

    thanks a lot for your help. It works well if user just need to see him/herself' following.

    However, our manager users want to have the flexible to search other sugar users' following. which works similar as "assigned to", do you know if there is a any way to get there?

    Also, do you know how those "following" many to many relationship are saved in sugar database? So that i could make some report or do some database query when i need.

    Francesca Shiekh  thanks for your help as well

    many thanks.

    Ron

Children
No Data