Flows - Operation Read Data - Directus collection

[gkielwasser]

Hi,

I'm not sure it an issue or it has been done on purpose.

Why the read data operation cannot deals with Directus collections ? it seems to be filtered/excluded.

One simple use case would be to read additionnal data about an user to retrieve its email. We would need to access directus_users table.

Thanks

[rijkvanzanten]

I'm pretty sure there's another open discussion/issue about this, but I can't seem to find it 🤔

Anyways, it's because the system collections should be accessed through dedicated Services, to make sure that all core logic is executed as well (users for example have password checks, fields alter the schema, etc). The operation is currently relying on the ItemsService exclusively, so it's only safe to use against regular collections 👍🏻

[gkielwasser]

Ok I 'm curently having a flow that is sending an email to the user who has placed an order.
Once an order is created it trigger a transactionnal email to him.
For now I'm relying on the O2M relation there is between my orders collection and the directus_users collection in order to retrieve the email of my user.
So I retrieve again the order and I read deeply the user property to query the email.
I guess that's the way to go :)

[rijkvanzanten]

That should do the trick for now!

[izoukhai]

You still can access system collections, you have to write the collection name directly using raw value

[gkielwasser]

You still can access system collections, you have to write the collection name directly using raw value

@izoukhai Thanks a lot ! 😃

[Mehdi-YC]

Hi thank you, this is helpful, can this be done on a M2M field ? for example field.price, to get the listofprices in many to many field ?