Can we get data from multiple entities using Collection?

[Prathyush Shetty]

I want to find records on the front-end, which can be achieved using Collections.
Can we get data from the Case table linked with Subscription table where userId on subscription table is "XYZ".
Is it possible via Collections?

[yuri]

It's possible with multi-collection. But it's not something that we use often in Espo, there's no guidelines.

[Prathyush Shetty]

Are there any other alternatives to get the data from the table linked with others on the front end? Except via collections?

[yuri]

To create a custom API action. It's very easy to do and a proper way for such cases.