How to search the Application Files table (sys_metadata)

G24
Kilo Sage

Hello.  I rely on this table quite a lot for finding things in the system.  But I'm seeing some strange search results when I use the "for text" search that I can't understand.  What is happening here:

 

1)  When I use the "for text" box to search for: You are attempting to add a record to the system

... I get 835 results.  That's fine.

1.png

2) Then when I add double quotes around that search string

I get only 2 results.  Fantastic!  That let's me quickly find what I am looking for.

2.png

3) And when I search for: Invalid value on Update

I get 2,365 results (as expected)

3.png

4)  But when I search for that same value in double quotes...

I am STILL getting 2,301 results which is WAY MORE than I would expect.

4.png

 

So what am I not understanding about this "for text" search box or what am I not understanding about the Application Files (sys_metadata) table?  Please.  Thank you!

 

 

0 REPLIES 0