Originally posted by tanya
View Post
Announcement
Collapse
No announcement yet.
Reports: Filter on multiple entities
Collapse
X
-
Fill the contact Form https://www.espocrm.com/support/ and write your specification. We will forward it to our partners.
Leave a comment:
-
Originally posted by tanya View PostHello,
it's impossible. In the list you can show only parent's fields, but not the children's. You could try to develop needed report, if you have a developer.
Could you write a report columns you want?
thank you for your reply!
We need the reports to be dynamic, so we can add enitties or change names on them if we need to, and also be able to show fields from parents as well as children. Can we have contact information to the developing team or any individual contact to discuss any possible development of this?
Best regards, Kristoffer
Leave a comment:
-
Hello,
it's impossible. In the list you can show only parent's fields, but not the children's. You could try to develop needed report, if you have a developer.
Could you write a report columns you want?
Leave a comment:
-
We would like to try to post one of our problems here once more, in hope for help.
We are having trouble displaying columns from multiple entities in the extension Reports. See below image with an example of entities and their relationships. We would like to be able to create reports on the entity Participant and show columns from children entities to this entity.
We have considered a relationship entity that connects all relationships as a separate solution. However, there will be many rows in such an entity.
Can we get around this somehow or do we need to place an order to you guys to develop this functionality for us?
We would really appreciate an answer, as we have demanding clients who wants this done as soon as possible.
Thank you!1 Photo
Leave a comment:
-
Originally posted by ChrisL View Postmaybe the discussion in this thread helps:
List Report - Advanced Pack - cannot take infos from "Contact" - EspoCRM Open Source Community ForumHi all, I'd like to create some list-reports with the Advanced Pack. We have "Contacts" (standard entity) and also "Vehicles" (self
as I had a "similar" issue... I was able to set the right filters etc., but I couldn't grab the information from the child objects into the report...
the thing what is not yet really clear to me is, why I had to rename "Task" to "primaryTask" in the relationship setup.
also the task.php file would obviously need some modifcation...
Leave a comment:
-
maybe the discussion in this thread helps:
List Report - Advanced Pack - cannot take infos from "Contact" - EspoCRM Open Source Community ForumHi all, I'd like to create some list-reports with the Advanced Pack. We have "Contacts" (standard entity) and also "Vehicles" (self
as I had a "similar" issue... I was able to set the right filters etc., but I couldn't grab the information from the child objects into the report...
the thing what is not yet really clear to me is, why I had to rename "Task" to "primaryTask" in the relationship setup.
also the task.php file would obviously need some modifcation...
- Likes 1
Leave a comment:
-
Originally posted by patsonson View PostHi Tanya,
Thank you for quick response!
Acording to the last examples and entities.
for what entity do you create a report?
If we create the report with entity Particiant, then we can't show columns from children (Consent and Task). With children I mean, one(particiant)->many(Consent,Task) relation. If we create the report with entity Consent, then we can show columns from particiant (parent) but not columns from Consent. We'd like to show columns from all 3 entities.
For the second problem with filtering.
With below filter, we expect Send saliva kit (Task) to have the status Completed and Recieve saliva sample (another Task) to have the status not Completed. But we get all participant records.
Best, K
Is what I described in previous post possible to do with Reports?
Thanks again!
//Kristoffer
Leave a comment:
-
Hi Tanya,
Thank you for quick response!
Acording to the last examples and entities.
for what entity do you create a report?
If we create the report with entity Particiant, then we can't show columns from children (Consent and Task). With children I mean, one(particiant)->many(Consent,Task) relation. If we create the report with entity Consent, then we can show columns from particiant (parent) but not columns from Consent. We'd like to show columns from all 3 entities.
For the second problem with filtering.
With below filter, we expect Send saliva kit (Task) to have the status Completed and Recieve saliva sample (another Task) to have the status not Completed. But we get all participant records.
Best, K
Leave a comment:
-
Hello Kristoffer,
for what entity do you create a report?
If you need to filter by 2 Tasks, select search type 'Any of' instead of 'Is', or click Add AND -> Add Field (or Add OR, if only one of condition has met)
Leave a comment:
-
Reports: Filter on multiple entities
Hi,
We're having some problems with the module Reports. We need to filter on multiple enitites and to present columns from multiple entities.
Problem 1
For example, we have 3 entities, Participant - Consent - Task that we want to be able to filter and present columns from all the entities. We can't make it work.
Problem 2
For example, we would like to present columns from the entities Participant and Task with filters on 2 Tasks with different names. We can only make it work with 1 Task.
Just to clarify, Participant has one->many (Consent and Task) relationships.
How do we do this the best way? We'd really appreciate answer as soon as possible, as clients are hanging over us and we have to make this work.
Best, KristofferTags: None
Leave a comment: