•  
     
    story #10709 display search results duck typing on columns
Summary
Empty
display search results duck typing on columns
Empty

Principle

Allow to search on custom fields (aka fields defined freely in each tracker) without too much overhead in the query definition or column selection.

Apply "duck typing" principle: if it has the same name and has a compatible type, let's assume it's the same thing.

Compatible types definition:

  • All numerics (initial_effort could be fload or int): float
  • All list with same bind (eg a select box with static values and check box with static values)
  • String and text fields
  • Date
  • Date time

Date and date time are separated because it's hard to guess what's the expected result when the query is "start_date >= 2017-04-24 07:15" and the field is a date (without time).

Are excluded:

  • rank
  • computed fields
  • artifact links
  • open list
  • permission on artifact

A field is selectable as a column if and only if

  • The name is present in all trackers of the query
  • The types assocated to this name are compatible
  • The user can read the field in all trackers

Technical side

  • No change on column selector (still button + drop down)
  • Group permission verification for Permissions on artifacts
  • Fetch data to display with same strategy then current tracker table renderer
Empty
Empty
Status
Cross tracker search
Ready (stalled)
Development
  • [ ] Does it involves User Interface? 
  • [ ] Are there any mockups?
  • [ ] Are permissions checked?
  • [ ] Does it need Javascript development?
  • [ ] Does it need a forge upgrade bucket?
  • [ ] Does it need to execute things in system events?
  • [ ] Does it impact project creation (templates)?
  • [ ] Is it exploratory?
Empty
Details
#10709
Manuel Vacelet (vaceletm)
2022-12-05 16:51
2017-09-29 15:12
3519

References
Referencing story #10709

Follow-ups

User avatar
  • Acceptance criteria
    Something went wrong, the follow up content couldn't be loaded
    Only formatting have been changed, you should switch to markup to see the changes
User avatar
  • Acceptance criteria
    Something went wrong, the follow up content couldn't be loaded
    Only formatting have been changed, you should switch to markup to see the changes
  • Category set to Cross tracker search
User avatar
  • I want to
    -search with duck typing on columns 
    +display search results duck typing on columns 
  • Permissions set to