Comments (4)
PR #32 added a stored procedure for advanced term search, just needs implementation in the app.
from swate.
As written before i found the search by "startsWith", "contains" and "endsWith" not optimal. I now implemented my version with 4 variables:
- search term name for keywords
- substring that must exist in term name
- search term definition for keywords
- substring that must exist in defintion
I am always happy for new ideas on what this advanced search needs and i think we will come back to this issue after some user feedback. For now everything works fine and is implemented. Will do a PR to developer soon, then we can think about a minimal POC release.
from swate.
When creating fullText indexes on Name,Accession, and definition, it is possible to query CONTAINS and FREETEXT on all three columns at once.
from swate.
We propably should discuss on how to implement this correctly. In my opinion the "ends with query" will not be used. i cannot think of any situation i would search by how a term/definitions ends. But as we recently implemented a is_a directed search option, we should think about adding this option also to the advanced term search. Let me know what you think @kMutagene.
from swate.
Related Issues (20)
- [swate-alpha] Different colors for column types
- [swate-alpha] Add assay metadata sheet HOT 5
- [BUG] SWATE online does not fill in Unit columns HOT 3
- [BUG] AddIn blank in Excel HOT 1
- [BUG] Swate cannot read template
- [BUG] add `protocol type` links to wrong TSR, TAN HOT 1
- [BUG] "Protocol template must contain exactly one template" HOT 4
- [swate-alpha] Replace TSR with OntologySourceReference HOT 1
- [Feature Request] Featured Columns
- [Feature Request] cell value "number"
- [BUG] installation link is down HOT 3
- [Feature Request] allow custom units
- [Feature Request] undo button
- [Feature Request] Prevent (excel)auto formatting / suggest format
- [Feature Request] File picker (design)
- installation guide link in README.md is broken. HOT 3
- [BUG] Term search takes excessive amount of time HOT 3
- [Feature Request] More ISA-tab-like Inputs and Outputs HOT 6
- [Feature Request] Order of columns is potentially important HOT 3
- [BUG] Organism search HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from swate.