Get all users with metadata field = value

Squiz Matrix Support
1

Hi all,


I applied a metadata schema to a group of users - they have a metadata field called "group". Is there any way of getting the list of users with a group value = X? (These users are created using asset builder) Once the list is obtained, can we get all the emails associated with those users?



Thanks so much.

2

[quote]Hi all,


I applied a metadata schema to a group of users - they have a metadata field called "group". Is there any way of getting the list of users with a group value = X? (These users are created using asset builder) Once the list is obtained, can we get all the emails associated with those users?



Thanks so much.[/quote]

No, but it'll be great if this feature can be added.

Asset listing scope is set by root (asset location, link value) instead of metadata field value.

In the asset listing, the metadata field can be used for 'grouping' and 'sorting'



Robin

3

Thanks for your reply, Robin.


I reorganized our users into user groups, so the question now is, is there a function to get all email addresses of the users under that user group? We want to send email from our remote content page to a specific user group. I don't think a trigger can be set on a remote content page.



:huh:

4

[quote]Thanks for your reply, Robin.


I reorganized our users into user groups, so the question now is, is there a function to get all email addresses of the users under that user group? We want to send email from our remote content page to a specific user group. I don't think a trigger can be set on a remote content page.



:huh:[/quote]

It looks like bulkmail function, have you tried it?

5

The send email trigger can send to a usergroup. You could set up a condition based on your page, and then it would send your specific email to that usergroup.

6

The thing is we can't use triggers on our remote content page…? Hence need to find a way to pass the emails to that page… will check out bulkmail, thanks for your replies.

7

Just want your opinion of whether this is do-able:


When the user is created from the asset builder, set a trigger to append its email to the user group's metadata value (can we do this? I know we can set an attribute value) .



At the remote content page we just pass the metadata values of email (one big long string?) using the POST variables page. Then my remote content page (written in PHP) will be able to send an email to all those users + the just uploaded content from that remote content page.



I'm trying to work this out but its proving really difficult :wacko:

8

[quote]Just want your opinion of whether this is do-able:


When the user is created from the asset builder, set a trigger to append its email to the user group's metadata value (can we do this? I know we can set an attribute value) .



At the remote content page we just pass the metadata values of email (one big long string?) using the POST variables page. Then my remote content page (written in PHP) will be able to send an email to all those users + the just uploaded content from that remote content page.



I'm trying to work this out but its proving really difficult :wacko:[/quote]

It's better to know the original prospect, what function are you after? :rolleyes:’ /> <img src=‘http://forums.matrix.squiz.net/public/style_emoticons/<#EMO_DIR#>/rolleyes.gif’ class=‘bbc_emoticon’ alt=':rolleyes:

9

[quote]Hi all,


I applied a metadata schema to a group of users - they have a metadata field called "group". Is there any way of getting the list of users with a group value = X? (These users are created using asset builder) Once the list is obtained, can we get all the emails associated with those users?



Thanks so much.[/quote]



If all you need is the list of emails you could do this with DB Datasource. Using the DB Datasource asset to connect to the DB you can run a query to get all assets that are associated with that particular selected group set by metadata using the dynamic parameters functionality.



If you need help with the query let me know.



Chris

10

You could create a Search page that searches on that metadata field.
Then create a search folder that works with that search page and in the Searched Terms field add what for, the type of Asset (user in this case) and root node.

Then all of the users that have that metadata value will be new linked into the search folder…



This functionality was added to 3.18.7



Hope this helps



Dave

11

You could also use an asset listing to list out all the users email addresses into a long string, then post that using ajax to your remote content page. Just an idea…