diff options
| author | zsloan | 2022-02-24 21:53:56 +0000 | 
|---|---|---|
| committer | zsloan | 2022-02-24 16:02:06 -0600 | 
| commit | 6496f75af521d6801c25de682d2852e14d597fed (patch) | |
| tree | 84e169a18d30eaa88aa54d21358576c9a4c58b73 /scripts | |
| parent | bbeba72a82e0a5698b4fb413430203e8aaee1830 (diff) | |
| download | genenetwork2-6496f75af521d6801c25de682d2852e14d597fed.tar.gz | |
Fix ProbeSet query for aliases
ProbeSet queries previously weren't dealing with aliases correctly, because it was doing a MATCH/AGAINST against the ProbeSet.alias field, but that field usually contains a list of gene symbols separated by semi-colons (so it wouldn't detect the alias unless there was only a single alias. To fix this, I added some LIKE conditions, searching for the possible variations. This is a little awkward, because I needed to make sure to avoid a situation where, for example, an alias like 'LPD-1' matches a search for 'PD-1'. I don't think the way it currently works is efficient, but I don't know of any good alternative without changing the way we store aliases in the database.
Diffstat (limited to 'scripts')
0 files changed, 0 insertions, 0 deletions
