I have been asked to implement a homepage dashboard feature into our database. The purpose off this is to act as a navigation hub for when one opens the database. This feature is implemented with no issues. It is also to display the most relevant data from other tabled, namely the Enquiries, Projects and Support Tickets. This is the feature I am struggling with.
What I need is a portal that displays the active items, from most urgent to least urgent (oldest to newest). I am testing using enquiries, but eventually will need to implement with the other items, however once I get enquiries working, it should not be difficult to implement due to similar infrastructure between the tables.
What I have so far is this:
In doing some digging I found people using Cartesian Joins to get all records displaying in the other table, as seen below:
The issue I have, is that I need the portal to display only the records where 'Hompage_ENQUIRIES::Status = "Alive"', and I am unsure how to create this filter. If anyone has any advice it would be greatly appreciated. Many thanks.