How does search work

  • Resolved charlesgodwin

    (@charlesgodwin)


    5 years, 2 months ago

    I wonder how search works. I have questions.

    Does it search every field/column in the table?

    what does it do with numeric columns and other non-string columns?

    Can you control/restrict the columns searched?

    By experimenting I think the query is something like
    where column1 like '%<complete input string>%' or column2 like ....

    Is this the correct conclusion?

    How do you search for something like ‘smith’ AND ‘john’?

Viewing 16 replies (of 16 total)
  • Thread Starter charlesgodwin

    (@charlesgodwin)

    The problem with a view is that defining a view requires different skills nd authorization. It’s not too hard to give someone without database skills rights to use and define Data Publcations. I’m trying to get myself unemployed so user can do most of their work without me. ??

Viewing 16 replies (of 16 total)
  • The topic ‘How does search work’ is closed to new replies.