how to Limit no. of rows in in flexible search

[former_member674349]

Hi Experts,

how can we Limit the no. of rows in in flexible search

e.g. If i want to get only 3 rows from given result. the operation should perform at database side Thanks, Jayant

[Former Member · Accepted solution]

Hello Jayant,

You can use most of the common SQL clauses like TOP or LIMIT

e.g.

 SELECT {c.name}
 FROM {Customer as c} 
 ORDER BY {c.name} DESC 
 LIMIT 3

or

 SELECT TOP 3 {c.name}
 FROM {Customer as c}
 ORDER BY {c.name} DESC

Regards, Pawel

[former_member674349 · Accepted solution]

But top and limit are database specific. it might not work well with oracle. any suggestion for same.

Thanks, Jayant

[Former Member · Accepted solution]

take a look at my answer

[Former Member]

An other not database specific solution would be:

 private List<Object> searchObject(final String typeCode, final int limit) {
     final FlexibleSearchQuery query = new FlexibleSearchQuery("SELECT {PK} FROM {" + typeCode + "}");
     query.setDisableCaching(DISABLE_CACHING);
     query.setDisableSearchRestrictions(DISABLE_SEARCH_RESTRICTIONS);
     query.setCount(limit); // <== limit
     return emptyIfNull(getFlexibleSearchService().search(query).getResult());
 }