Access field of column
Posted: Thu Oct 19, 2023 2:08 pm
Good morning!
I am having some trouble with a particular data structure. We have a mongodb database we'd like to connect to, which I managed to do. However, in this database, we have a collection, let's call it A, which has a field, which we'll call B. B is an object, and has two fields, C and D. I want to display only one of them on the report, so basically, this is my situation:
I have several documents, all of them with the field B, which itself has fields C and D. I'd like to display in table form all D fields + E, which is another field of the main A documents.
Is this possible? What is the syntax for this?
I am using the report designer to assemble the report.
I thought this syntax would work:
But it just shows empty space on the first columns when I try to do it this way.
UPDATE: I have also tried using array syntax, to no avail:
I am having some trouble with a particular data structure. We have a mongodb database we'd like to connect to, which I managed to do. However, in this database, we have a collection, let's call it A, which has a field, which we'll call B. B is an object, and has two fields, C and D. I want to display only one of them on the report, so basically, this is my situation:
- Untitled design (3).png (69.92 KiB) Viewed 7886 times
Is this possible? What is the syntax for this?
I am using the report designer to assemble the report.
I thought this syntax would work:
- Captura de tela 2023-10-19 110841.png (5.72 KiB) Viewed 7886 times
UPDATE: I have also tried using array syntax, to no avail:
- Captura de tela 2023-10-19 111818.png (3.97 KiB) Viewed 7881 times