Labels

"Milestone Summary" portlet is not sorta
1
9.62 GUI installation
2
Ad
9
Adding Developer name field from Object type...
1
Admin
65
Admin Console
11
Agile
7
AlreadyInOctane
0
Analyze Assignment Load
1
AOL
2
API
13
Approval from email notification
2
Approve Time
7
Approved Budget User Data Fields
1
Assignment update using position update ...
2
Attachment with notification
2
Audit Logs
7
Audit Trail
5
Authentication
5
Autofill
2
background service restart
1
Bar chart
4
Certification
6
Change Project Name
1
CHPERPDBA@mountsinai.org
1
Clear cache issue wrt RequestRulesUserLibrary...
1
Closed Project
3
Confirmation
9
Copy_Header's_User_Data_Default_No
2
cost health icon
1
Dashboard Usability
13
Dashboards
20
Databases
7
decimals
4
Demand Management
35
department
1
deployment
8
Display info on logon page
1
Enabling Floating License
1
Export to PDF
7
exporting to PDF and Excel
7
Feature Request
68
Field Type
7
file attachment
4
Filters
10
Financial & Staffing Profile
17
Financial Summary
27
FinancialSummaryAPI
2
Github
1
Global KPI
3
Import from excel to Table component
3
in-line editing
2
Include use
11
Top Voted Ideas: Last 30 Days
API Keys - Allow for regeneration of the API Key
3
Idea ID: 2752965

Allow filtering on table components

cfavre
Status: Delivered

Would like to be able to allow filtering on table component data.

As tables get large, users would like to be able to filter the rows displayed based on specific values entered in one or more table component columns.

This functionality is commonly used in Excel and users would like similar functionality in the table component.

 

  •  

    Delivered in PPM 9.63 through the "Table Component Grid View" feature. 

    On this (read-only) grid view of the table component, you view all the rows (without any paging), you can filter & sort any column, and you can also group rows as well as pivot on any row.

    There's also a clickable link on each row that will automatically send you to the "old" view on the right page with the right column selected so that you can then click "Edit" to edit that row.

  •  

    Since you mentioned that you requested this capability because "this feature is commonly used in Excel", please note that next PPM version may also include the capability to edit the contents of the table component in Excel.

    More info here: /adtd/sws-ppm/i/ppm_ideas/enable-import-from-excel-to-table-component

  •  

    Hi,

    If everything goes according to the current plan, we should start working on it this week, it should be available for testing for the lucky few on beta.ppm-demo.com within one month, and it should be released in next PPM version (9.63) in late-November/early-December.

    As usual this is a tentative plan which is subject to change without notice.

     

  • This would be a good first step. Is there a target timeframe for providing the functionality in read-only?

  •  

    In order to implement some of this idea sooner, we're considering providing this new view of the Table Component in read-only - but filtering, grouping, and pivoting should be enabled, which should provide a convenient way to find what you're looking for in a TC.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.