How to Convert SearchResult to List

[Former Member]

How to convert searchResult to ArrayList

 String query = "SELECT * FROM {PRODUCT}"

 final FlexibleSearchQuery fQuery = new FlexibleSearchQuery(query);
 
 SearchResult<ProductModel> products = flexibleSearchService.search(fQuery);

I want to convert to List. Any Idea?

[Former Member · Accepted solution]

Thanks

I got the Answer

String query = "SELECT {pk} FROM {PRODUCT}"

final FlexibleSearchQuery fQuery = new FlexibleSearchQuery(query);

SearchResult result= flexibleSearchService.search(fQuery);

List products = result.getResult();

[bhavirisetty · Accepted solution]

You should use select {pk} not select *, refer my answer below

[Former Member]

products.getResult() will get all product.

Hope it will help you.

[bhavirisetty]

Hi Ansari,

Please use below piece of code,

 String query = "SELECT {pk} FROM {PRODUCT}"
  
  final FlexibleSearchQuery fQuery = new FlexibleSearchQuery(query);
  
  List<ProductModel> products = flexibleSearchService.search(fQuery).getResult();

Thanks