lundi 29 juin 2015

Add Efficient searching feature in Android App from Sqlite Database

I have one problem Table

    ProblemTable
    id  problemTitle                        problemDescription
    1   machine got hand                    water Motor got jammed
    2   motor is not working                induction motor is not working
    3   water connection is not proper      water connectivity problem in city
    4   electric power machine problem      Electric power generator is not working
    5   power down in my city               Power down in city 

I need to add searching feature, which may be keyword searching or full text search,both from description and title. Like if i search by "motor"

 reasults will be 
    1   machine got hand                    water Motor got jammed
    2   motor is not working                induction motor is not working

if i search by "power down in city" Search result

4   electric power machine problem      Electric power generator is not working 
5   power down in my city               Power down in city
3   water connection is not proper      water connectivity problem in city 

How do i implement this form sqlite db full text as well as kewords search . Please help me .

Aucun commentaire:

Enregistrer un commentaire