Search on 'Keywords' field in a database view?

[georgechen]

Hi folks,

Hoping you could help with a keywords field search question in database view.       I've got database view based on Finance table with text index enabled,

In the listview search of the database view (u_finance_external) the Keywords search does not return any records (see below)

Based on a search on http://wiki.servicenow.com/index.php?title=Enabling_Text_Search_in_Record_Lists#gsc.tab=0 , it introduces the 'Text Index' option on the table level.

The Keywords search works as expected in the Finance table, but not the database view, so I was wondering if it's the database view needs the text index option set up or not?

Hoping you could advise.

Thank you in advance.

George

[prashantatsastr · Accepted solution]

Hi George,

AFAIK the indexing option is not available for the database view(join) tables. If you want to search from list view for database view tables you could create UI Macro and use glide record on all the fields. It will return you the results similar to keyword functionality.

Please let me know if you need more details.

Regards,

Prashant

[georgechen]

Thanks Parashant. I will look at the UI Macro to see if I can make it.

Much appreciated for your response.

[georgechen]

Hello Prashant

I am still working on this to my client, wondering if I could ask your advice on how I could start working on the UI Macro.   I am relatively new with UI Macro, hoping you could give me a hand.

Thank you in advance.