search

fabric8-services / fabric8-wit

wit stands for Work Item Tracker
http://devdoc.almighty.io/
Apache License 2.0
45 stars 86 forks source link

Design SQL for expanding support for searching mulitple types ( users, Workitems ) #430

Open sbose78 opened 7 years ago

sbose78 commented 7 years ago

related to #395

aslakknutsen commented 7 years ago

Keep in mind it's only by luck that Users exists in the same DB as WorkItems right now.

tsmaeder commented 7 years ago

@sbose78 what's the use case here?

aslakknutsen commented 7 years ago

I wonder if this really is covered by #439

User and WorkItems are two different types and do not need to be searched for in the same Query.

sbose78 commented 7 years ago

Hi @tsmaeder , The use case is that a generic search should return results off all objects in the system. Example, in github when we search in the top search bar https://github.com/search?utf8=%E2%9C%93&q=almighty the left navigation bar shows number of results pertaining to each type .

So I was wondering if our sql query should also do the same.

We could definitely do this is separate queries, but that felt slightly inefficient to me.