Searching names through odk-x-survey or through odk-x tables

[Duncan_Otieno]

Hello team,
Am looking for a way to search names using names in odk-x survey or odk-x tables
Anyone who can help?
I know I have asked this before

How can one search a table in odk-x survey using more than one parameter e.g the 3 names

I wanted to know if it is possible to do a search on a table created from odk-x survey form using multiple parameters e.g the 3 names. Problem I want to solve.Registration at the clinic poses many challenges.Clients may pose as new clients and so a search on the 3 names and a mothers first name may help Any help on this is greatly appreciated

and

I need help with search on names

Hello Team, I am new to odk-x and also a greenhorn in Javascript. I need help with search on firstname, middlename and lastname. Please I need some assistance on this. I really liked how @linl33 helped @Duncan_Otieno with double metaphone and soundex He made it simple even people who do not understand Javascript followed and executed I will really appreciate

Does someone has a code or away to do this
I really need help on this.
Please share If you have way out

[elmps2018]

See this post:

Search in table and list results. (ODK tables)

Hi all I’m playing around with the HOPE-project included as an example application, to configure the code to my own surveys. In the HOPE-project, one is able to search on client ID’s. I’m trying to alter the javascript femaleClients_list.js.txt (4.7 KB), to display more than more than one search result. Eg. if two clients have ID = 12345 the search function should list both clients. Now only the first entry is listed. Does anyone know how to implement this functionality? I imagine this coul…

the HOPE example app has search, but definitely it requires a lot of coding to modify.

[W_Brunette]

One technique I use is to combine the first and last name and then do a database query by adding the queries tab to the XLSX definition:

SELECTION COLUMN: _savepoint_type = ? and (REPLACE(first_last_name, " ", “”) LIKE REPLACE(?, " ", “”)) and ( substr(birth_date,0,10) = substr(?,0,10)) and is_adult = ? and _id != ?

SELECTIONARGS COLUMN: [‘COMPLETE’,data(‘first_last_name’), odkCommon.toOdkTimeStampFromDate(data(‘birth_date’)),‘yes’,metadata(‘_id’)]

If query finds someone with a similar name and same birth date the system reports the problem.

I use the REPLACE to strip out spaces to improve match quality.