{"action":"created","issue":{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/192","labels_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/192/labels{/name}","comments_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/192/comments","events_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/192/events","html_url":"https://github.com/FreeUKGen/MyopicVicar/issues/192","id":42541377,"number":192,"title":"Wildcard Search Support","user":{"login":"benwbrum","id":199961,"avatar_url":"https://avatars.githubusercontent.com/u/199961?v=3","gravatar_id":"","url":"https://api.github.com/users/benwbrum","html_url":"https://github.com/benwbrum","followers_url":"https://api.github.com/users/benwbrum/followers","following_url":"https://api.github.com/users/benwbrum/following{/other_user}","gists_url":"https://api.github.com/users/benwbrum/gists{/gist_id}","starred_url":"https://api.github.com/users/benwbrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benwbrum/subscriptions","organizations_url":"https://api.github.com/users/benwbrum/orgs","repos_url":"https://api.github.com/users/benwbrum/repos","events_url":"https://api.github.com/users/benwbrum/events{/privacy}","received_events_url":"https://api.github.com/users/benwbrum/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/labels/Actor:%20researcher","name":"Actor: researcher","color":"006b75"},{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/labels/enhancement","name":"enhancement","color":"009800"},{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/labels/in%20progress","name":"in progress","color":"ededed"},{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/labels/search%20form","name":"search form","color":"bfe5bf"}],"state":"open","locked":false,"assignee":{"login":"benwbrum","id":199961,"avatar_url":"https://avatars.githubusercontent.com/u/199961?v=3","gravatar_id":"","url":"https://api.github.com/users/benwbrum","html_url":"https://github.com/benwbrum","followers_url":"https://api.github.com/users/benwbrum/followers","following_url":"https://api.github.com/users/benwbrum/following{/other_user}","gists_url":"https://api.github.com/users/benwbrum/gists{/gist_id}","starred_url":"https://api.github.com/users/benwbrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benwbrum/subscriptions","organizations_url":"https://api.github.com/users/benwbrum/orgs","repos_url":"https://api.github.com/users/benwbrum/repos","events_url":"https://api.github.com/users/benwbrum/events{/privacy}","received_events_url":"https://api.github.com/users/benwbrum/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/milestones/5","html_url":"https://github.com/FreeUKGen/MyopicVicar/milestones/Version%201.4%20Research%20Enhancements%20(Phase%201)","labels_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/milestones/5/labels","id":913383,"number":5,"title":"Version 1.4 Research Enhancements (Phase 1)","description":"Targeted actors:\r\n\r\n- Researchers\r\n","creator":{"login":"Captainkirkdawson","id":2874694,"avatar_url":"https://avatars.githubusercontent.com/u/2874694?v=3","gravatar_id":"","url":"https://api.github.com/users/Captainkirkdawson","html_url":"https://github.com/Captainkirkdawson","followers_url":"https://api.github.com/users/Captainkirkdawson/followers","following_url":"https://api.github.com/users/Captainkirkdawson/following{/other_user}","gists_url":"https://api.github.com/users/Captainkirkdawson/gists{/gist_id}","starred_url":"https://api.github.com/users/Captainkirkdawson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Captainkirkdawson/subscriptions","organizations_url":"https://api.github.com/users/Captainkirkdawson/orgs","repos_url":"https://api.github.com/users/Captainkirkdawson/repos","events_url":"https://api.github.com/users/Captainkirkdawson/events{/privacy}","received_events_url":"https://api.github.com/users/Captainkirkdawson/received_events","type":"User","site_admin":false},"open_issues":38,"closed_issues":24,"state":"open","created_at":"2014-12-23T15:43:01Z","updated_at":"2015-10-24T16:01:10Z","due_on":"2015-12-31T07:00:00Z","closed_at":null},"comments":9,"created_at":"2014-09-11T16:06:02Z","updated_at":"2015-10-30T13:33:08Z","closed_at":null,"body":null},"comment":{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/comments/152527159","html_url":"https://github.com/FreeUKGen/MyopicVicar/issues/192#issuecomment-152527159","issue_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/192","id":152527159,"user":{"login":"benwbrum","id":199961,"avatar_url":"https://avatars.githubusercontent.com/u/199961?v=3","gravatar_id":"","url":"https://api.github.com/users/benwbrum","html_url":"https://github.com/benwbrum","followers_url":"https://api.github.com/users/benwbrum/followers","following_url":"https://api.github.com/users/benwbrum/following{/other_user}","gists_url":"https://api.github.com/users/benwbrum/gists{/gist_id}","starred_url":"https://api.github.com/users/benwbrum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benwbrum/subscriptions","organizations_url":"https://api.github.com/users/benwbrum/orgs","repos_url":"https://api.github.com/users/benwbrum/repos","events_url":"https://api.github.com/users/benwbrum/events{/privacy}","received_events_url":"https://api.github.com/users/benwbrum/received_events","type":"User","site_admin":false},"created_at":"2015-10-30T13:33:08Z","updated_at":"2015-10-30T13:33:08Z","body":"I've completed wildcard search with a single exception:  \"ends-with\" searches on e.g. \"*ohn *mith\".  These work, but will not use an index efficiently.  Here are the options I see:\n\n* _Full support_: In this case, we jump through some hoops in the record transformations to create additional fields and indexes for ends-with searches.  Researchers can use ends-with searches anywhere they can use name searches at present.   Full support might double or quadruple the number of indexes on the `search_records` collection.\n* _Limited support_: In this case, we use existing data structures but restrict users to searches criteria that will use indexes to narrow down the records searched.  I.e. we create an index on `chapman_code, place_id, search_date` and require the researcher to select a place (including nearby) for ends-with wildcard searches.  This would give users full liberty to do whatever kinds of wildcard searches they want, so long as they have a restricted set of records to search against.\n* _No support_: Don't allow ends-with searches at all; just allow begins-with and infix searches.\n\nOpinions, @captainkirkdawson, @edickens, @EmJayFry, @Sherlock21?"}}