Constellation - Joined variables and Export CSV

User Experience
1

Good morning everyone!
I am not able to meet this requirement.

I have a class “Ass” that contains the association between tables A and B.
I need a view with a table whose source is a Data Page of class “Ass” which, through a report, performs the join between tables A and B.
I would like to see in the view on a landing page the columns of classes A and B.
In addition, in the local actions I would like an action to export to CSV, as well as to Excel.

Thanks in advice

Stefano

2

@StefanoB3275i think this was answered in your related post?

Associations are they way to join data in Constellation apps, Explore Data/Insights can leverage these and natively gives you export to excel.

3

@MarcCheong

With Association I can reach the Joined Column feature.

But I cannot find a way to insert a “Export to CSV” local action.
Should I tell to the customer that it’s not possible in Constellation?

4

@StefanoB3275 i missed that part of the question, “Export to CSV” is only there when the source of the data is a queryable datapage. It governs a lot of the Constellation features as its centered on ensuring application performance and scalability.

Why? The short answer is: Query data pages are designed to efficiently handle large datasets on the server, which is essential for a non-disruptive export experience.

In your case, yes, it is possible. It is unclear if you are using a List View or Insight.

Insight

this might help:

Of the top of my head, you might need to use a simple association rule to get this working, leveraging an “advanced” join might preclude this from the export button.

List View

  • Queryable data page should enable this
  • Failing that you could create a optional action on the case, promote it (so its more prominent) and that could trigger the file creation you want. This is advanced but not unique to Constellation (nor different)