cancel
Showing results for 
Search instead for 
Did you mean: 

HAC FLEXIBLE SEARCH RETURN RESULT SHOW MORE THAN 200?

Former Member
0 Kudos

Every time i do search in hac flexible search it only return a maximum of 200 rows of results, how can i make it to return all the results from database by flexible search and without going directly to the database?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can increase the Max. count field and increase the number of results.

Answers (3)

Answers (3)

former_member646092
Discoverer

In case this does not work - apparently error in H6.6++, put following in JS console: {quote} $("#maxCount1").attr("value",5000) {quote}

(Note: Hybris JS should use $("#maxCount1").val() instead of attr("value") 😉 )

Former Member
0 Kudos

Verified for H6.6

0 Kudos

... be aware, that in case of MySQL JDBC driver the maxCount param is ignored and all your product data will be loaded to heap. The maxCount is used only to populate the "Execute" button response. The MySQL JDBC loves to be eager...because of performance. It's normally fine, but in this case not. If you get OutOfMemory error depends on your heap size, column count and content in your table.

Former Member
0 Kudos

Oh, thank you very much!

Former Member
0 Kudos

You're welcome