ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins. Read more for important details.
ALERT! The community will be read-only starting on April 19, 8am Pacific as the migration begins.Read more for important details.

Extend Advanced Reports Query Views concept to Application Aux Tables

Idea ID 2739042

Extend Advanced Reports Query Views concept to Application Aux Tables

I'd like to see the Advanced Report Query Views extend to the Application you bound the view to.  Furthermore I'd like to use the views to populate relational fields from the Aux Table (view).

I've been struggling to find a easily administered solution to use one table, not two or three tables (dependencies), to populate a relational field based on table record attributes from another field in the same table.  The create report definition solution is nice, but doens't work for Aux Tables in the Global Application.  The Advanced Report Views was another possibilties, but the views are not extended to the application level.

I'd like to see something offered similar to:

E.g. A Facilities Table

Facility Production Billing Warehouse AppDev PMO
Name1 Yes No Yes Yes Yes
Name2 No Yes No Yes No
Name3 No No Yes No No
           

Multiple Relational fields would be populated from one table based on the View Select established.

Production Facilities Relational Field = Select Facility from Facilities where Production = "Yes"

Billing Facilities Relation Field = Select Facility from Facilities where Billing = "Yes"

You get the idea.

Alternatively, this type of attribute field selection could be put under the Options Values section of the Property Editor.  Allow for a select statement to be applied to the application table.

 

2 Comments
Absent Member.
Absent Member.
 
Micro Focus Expert
Micro Focus Expert
Status changed to: Declined

This idea has not received many votes within 24 months of its submission. It has now been closed (declined) due to insufficient support.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.