I have a post type "building", that gets connected to let's say 20 different users. As the users get connected to a certain "building" ID= 225 (via a front end form), they can choose their role by typing in a text, which is stored in the connection metadata field "role". So I have 20 connections as below for that "building" with ID=225 with the following different entries for the metadata field "role":
architect (1 users), Architekt (1 user), designer (3 users), engineer (2 users), fan (8 users), manager (1 user), owner (1 user), visitor (3users)
I know I can show a connection if I know the meta entries, but what happens if I do not know the meta entries?
How would I go about getting all the connection meta entries for "role" that has been used for that particular connection type from that "building" with ID=225? Then I would like to show all users under the respective connection meta entry in "role", so I can structure it as above.
Not sure if that is clear....