How do I get the selected values from a database collection as search results?

To get the search results with selected values in JSON output for the database collection, you have to create your SQL in the correct format i.e., include the values in the SQL query to be indexed as below:

Make a search and click the result. You will be able to view the results in JSON as in the screenshot below:

To learn more on SQL Query for Database collection read: SQL Query for Database Collection