Creating a Customized List View

[Peter26]

Greetings,

We have a need to create a list view that:

• Has a default filter that can't be configured via the standard filter tool (it requires a sub-query)
• Has a single field at the top of the view that allows choosing a date

Still investigating the first bullet-item. However, the second bullet-item is what I'm most interested in getting information about:  Is there a way to customize a standard list view without doing DOM manipulation? If not, is there a way to create a standard list view within a custom UI Page, e.g., is there a widget or other structure that can be used within a UI page to create a standard list view?

Context:  We have some tables that are effective dated, and by default, for each object type defined in the table, we want the list views to show the record with the maximum effective date for that object type that's also less than or equal to a given date. The extra field above the list view, mentioned above, would allow the user to choose the "given date". 

Interested in any ideas about how to achieve this, is possible. Thanks!

[Brad Bowman]

It sounds like a Database View might do what you are looking for.  You would create the DB view with just the one table in this case, so not the customary use case for this.  You can then create a Query Business Rule to do the filtering, and allow the users to further filter using the standard filter condition builder.  Create a new module that displays the list of records using the DB view as the table for quick access.