Allow subquery joins on non-output columns

mark shared this idea 3 months ago
Idea Logged

At present the join key between the master query and the subquery(ies) needs to be in the output columns, however we are finding many situations whereby the join key should not be in the output.

A simple example is that a date in the master query needs to be joined to a calendar. The output should be grouping by the week or month, however this is not possible because the date needs to be in the rows or columns field of the master query. Hence the output is grouped by the date and week/month as opposed to the week/month.

Essentially the join columns (ON CLAUSE fields) should not be enforced to be included in the output. When constructing the SQL statement in free-hand SQL this is possible but not via the ReportBuilder.

Could this be included in future releases or placed on the roadmap?

Comments (3)

photo
1

Hi Mark,

Thanks for reaching out with your suggestion. I've logged this as an Idea for an Enhancement Request. Before becoming a request, ideas will be reviewed by our Product Team and chosen for Enhancements based on feasibility, level of positive impact to the user experience, and votes from the community. This post will be updated with any future information relevant to this process.


Cheers,

Neal

photo
1

Hi Mark,

Hope you are well. I wanted to let you know that this task is underway and looks on track to be included in our 9.7 release due out later this year. Once I have confirmation of this I will let you know.

Cheers,

Neal

photo
1

Thankyou, Much appreciated

Regards

Mark Czernkowski

Solution Architect | PiES

Mobile: +61 411586010 | https://www.pies.io/

From: Yellowfin Support <support@yellowfin.bi>

Reply to: Yellowfin Support <support@yellowfin.bi>

Date: Friday, 17 September 2021 at 9:39 am

To: Mark Czernkowski <mark@pies.io>

Subject: New Comment in "Allow subquery joins on non-output columns"