Fetching Column Data

I need to fetch more than 10 columns from different tables at once for a report on a daily basis. How can I customize my search and make it efficient?

1 Like

Hi @keerthana.kalimuthu, to achieve that, you may utilize SME’s Summary Fields/Smart Column feature. You can access it by clicking the settings icon located at the top right corner of the screen, then select Create Custom Fields. From there, you will see three tabs, and the middle one is the Summary Field tab. In this tab, you can choose the columns you want to include, and you can also add filters if necessary. Once you have saved and published your changes, you can refer to the set of columns you added by calling the smart column’s name. If needed, you can also add additional filters while asking questions. For your reference, I have attached some screenshots.