Hello,

I have the following case. I have a document type (articles) that on one field holds a primary key of a custom table. The custom table has categories for the articles. So, the custom table has two fields: itemid and category. The itemid is a number and the category is text.
The document type field holds the number (the id of the custom table). On the form there is a drop down from which the editors select the category.

The problem is that when someone searches using smart search the actual field of the category is not searchable. Is there a way to have this custom field searchable? So for example if someone searches "books" which is the category of some articles those articles are displayed.

Also, normally what is the way to display this field on transformations? What I do is join the custom table with the document type on the selectdocument query and get the category field. Is there a better way to do it?

Any help is appreciated.

Dimitris