Harvard ABCD Forge > Projects > Screensaver HTS LIMS > Tracker > Screensaver Tasks

[#1341] multi-property table column type

Submitted By: Andrew Tolopko
Start Date* Jan 23 2008	End Date* Feb 23 2008
Priority: Low	Assignee: Nobody
Status: Open	Component: Data Table Impl
Branch: iccbl	Impact: improvement
Stakeholders: nathanmoerke@gmail.com	RTID: 113992
Revision Found:	Resolution: N/A
Active: N/A	Estimated Effort: N/A
Planned Release : N/A	Goals Addressed:
Components:	Priority Approved: Jan 27 2009
Audience:
Summary multi-property table column type
Details There may be a need for a "multi-property" table column type. Such a column type would create a single column that is comprised of data from multiple entity properties. The motivating case is the "name" column type, which consists of last and first name. A multi-property column type would allow the user to more intuitively search across its constituent fields, and the filter UI that presents such column types could present an appropriate, multi-field component. Most importantly, a multi-property column type would be supported by VirtualPagingDataModel, since DataEntityFetcher could now incorporate the multiple fields into the generated "fetch keys" query. (Currently, the UserNameColumn restricts its search result to using only the InMemoryDataModel, since its not possible to create a query for a column that is derived from multiple database field).
Details There may be a need for a "multi-property" table column type. Such a column type would create a single column that is comprised of data from multiple entity properties. The motivating case is the "name" column type, which consists of last and first name. A multi-property column type would allow the user to more intuitively search across its constituent fields, and the filter UI that presents such column types could present an appropriate, multi-field component. Most importantly, a multi-property column type would be supported by VirtualPagingDataModel, since DataEntityFetcher could now incorporate the multiple fields into the generated "fetch keys" query. (Currently, the UserNameColumn restricts its search result to using only the InMemoryDataModel, since its not possible to create a query for a column that is derived from multiple database field).

Follow-ups

Submitted By: Andrew Tolopko
Adddate: 2008-10-02 13:05:21
A multi-property column type may also provide a work around @Transient
model properties that that have dependencies on a related entity's
property.  Using a multi-column property, it would be possible to
specify the full set of properties that need to be included in key and
data fetch queries.

I'm thinking a multi-column property will need to be parameterized with
a function that combines its multiple fields, the result of which is
used as the value for sorting and filtering.  This function will need to
be mappable to an SQL function, if multi-property columns are going to
support filtering/sorting at the database level (i.e.,
VirtualPagingDataModel support).

Submitted By: Andrew Tolopko
Adddate: 2008-10-02 13:05:22
Nate pointed out the non-intuitive behavior of the user name search
field in the Screeners Browser.  Searching on first name alone does not
return any results, since the default search operator is "starts
with",
and the name fields is formatted as "last, first".  The
multi-property
table column type would address this by properly handling searches
across both last and first name columns.

File Name	File Type	File Size	Posted By
No Files Were Found

Change Date	User Id	Field Name	Old Value	New Value
2009-01-27 14:38:44	Andrew Tolopko	assignee	None	Nobody
2009-01-27 14:38:44	Andrew Tolopko	priority	3	4
2008-10-16 13:22:19	Andrew Tolopko	release	1.7.2	1.7.x
2008-10-03 11:51:12	Andrew Tolopko	release	1.7.x	1.7.2
2008-10-02 13:05:16	Andrew Tolopko	_created_		multi-property table column type

File	Date	Previous Version	New Version	Message Log	By
No Commits Found

Dependent On Other Items

ID	Summary	Delete
No Dependencies Were Found

Items Dependent On This Item

ID	Summary
No Dependencies Were Found

Duplicate of items

ID	Summary	Delete
No Duplicates Were Found

Items that are duplicates of this item

ID	Summary
No Duplicates Were Found

Associated Item	Comment
No Associated Items Found
~~Add Association~~

Save changes Back

The Harvard ABCD Forge is an installation of the GForge project and is supported and maintained by the ABCD Software Developers Group. Funding is provided by the office of the Harvard CIO. Contact the forge-admin team with any questions. Our privacy policy is posted here.

MyGforge Home

Screensaver HTS LIMS