Current Behaviour
In the current state of the application the search feature is limited to two parts:
- drop down for table name
- text input filed for a search parameter
These inputs results in a query in the form of SELECT * FROM [selected table name] WHERE [search parameter];.
And the search parameter is also very restricted.
Goal
The goal with this ticket is it to improve the search, make it smarter, include more freedom fore the user.
For example would it be also good to not restrict the search on a specific table and run a search query across all tables, when the user just puts in “projekt = xy” or “loc < 100” and no table name drop down required.
It should be possible to put in a word and implement in the background a search query for every table, resulting in a comprehensive search.
Current Behaviour
In the current state of the application the search feature is limited to two parts:
These inputs results in a query in the form of
SELECT * FROM [selected table name] WHERE [search parameter];.And the search parameter is also very restricted.
Goal
The goal with this ticket is it to improve the search, make it smarter, include more freedom fore the user.
For example would it be also good to not restrict the search on a specific table and run a search query across all tables, when the user just puts in “projekt = xy” or “loc < 100” and no table name drop down required.
It should be possible to put in a word and implement in the background a search query for every table, resulting in a comprehensive search.