• Registered: 2016-07-28
  • Posts: 1,030

Topic: MVD Search

Is search for only exact matches or I'm missing things?


For instance on example Phone Book app there are 3 sample records.
Richard Little
Leon Akers
Tricia Thibault


I search for leo or Leo in first name field only, search doesn't produce any result. If I search for Leon then it finds the record.

Adam
God... please help me become the person my dog thinks I am.
  • Registered: 2014-06-25
  • Posts: 863

Re: MVD Search

You can change the way search is made in the property: filter. You can change it so it would not search for exact match ("="). For search ahead, I use always "%s%".

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,677

Re: MVD Search

Hello Adam, Thierry,
You can also add to Thierry's suggestion by using the 'incremental search' object property which will start filtering records in the tablegrid as soon as you start typing rather than enter part of the field (%s%) and then clicking 'search'.
Look at the attachment and notice how the 'first name' and 'last name' fields now behave when searching.  Some people prefer it one way, some the other - MVD gives you the choice.
Derek.

Post's attachments

Attachment icon Phone Book.zip 362.5 kb, 361 downloads since 2016-09-19 

  • Registered: 2016-07-28
  • Posts: 1,030

Re: MVD Search

Hi Guys,


Thanks a lot for the info....

As usual nice info Derek.  How do you define "bSearch" or "bSQL" atributes in  'incremental search' object properties?

Adam
God... please help me become the person my dog thinks I am.
  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,677

Re: MVD Search

Hi Adam,
See attached screen shot.
Derek.

Post's attachments

Attachment icon 1.jpg 319.02 kb, 215 downloads since 2016-09-19 

  • Registered: 2016-07-28
  • Posts: 1,030

Re: MVD Search

Thanks a lot for your patience Derek... I was missing search button name... All clear now.

Adam
God... please help me become the person my dog thinks I am.