Searching title and description of CB Gallery albums and items

We'ld like to offer community-wide search for titles and decriptions of a field which has type "Gallery" (in addition to let users search inside Gallery).
As there's apparently no Gallery Searchbot avail. we'ld like let cbsearchbot search a CB field type text.

CB field would have to get data from DB as follows:

SELECT CONCAT( title, ' ', description ) FROM `jos_comprofiler_plugin_gallery_items`
WHERE user_id = '[userid]'
AND CONCAT( title, description ) IS NOT NULL;

What is appropiate way to convert DB rows into a simple CB text field via Auto Action triggered by OnAfterUserUpdate/OnAfterUpdateUser?

1) Code Action and PHP program reading DB?
2) Query Action and facilitating variables? If yes ... how to do it?

Would heartly appreciate any help on this toipic.

Thank you.

There's no functionality for that. You'd have to create a gallery that displays all profile gallery entries which they could then search (e.g. Joomla menu item to CB Gallery with asset set to profile.%). There's already a feature ticket to eventually provide a Joomla search bot to search galleries as follows.

forge.joomlapolis.com/issues/6165