Folder hit limit in case of multiple AG

[dmalvi]

Hi Everyone,

I have a folder where 2 AGs are mapped. Max Hit Limit for a User is 200.

In this case, for a single search there are 209 documents present, 201 in a 1st AG and 8 is in 2nd AG.

ideally query should go to both the AGs and top 200 result should be shown.

Problem Statements :

The query which is having more then 200 result are not going into 2nd AG and only Old Documents are visible.
I don't want to increase the limit on this folder.

Could someone please help me with this issue.

[Nolan]

Is this not just having the user adjust the date value to the current date?  When you say only Old Documents are visible that implies the date range can be adjusted.
You could adjust the default date range to only current day if you don't want the users to get older documents unless requested.

[Justin Derrick]

This is just a limitation of using MaxHits.  I think you can force a sort on the returned results, and then take to top X hits from that list -- but that presumes that you know how the users want to see the results displayed to them.

-JD.

[ewirtz]

Hi Justin,
this does only work if you activate a server based sort. But this implies that it might have a performance impact if the result set is big.

regards

Egon

[Justin Derrick]

Hi Egon,

Yup, you're absolutely right -- which is why I think the option isn't used very much.  It only takes one or two bad queries to drag a machine down and make it impossible for other users to get anything done.

-JD.

[dmalvi]

Hi Justin/Egon,

That for your views on this.  :)

Is there something we can achieve this with Query restriction? Just a thought ....

The problem is,  there is no date range available for the client to search on front end.

-Deep

[Justin Derrick]

Not having a date range to search is NOT a good idea.  That means that every search must query EVERY Application Group table in CMOD.

The 'best practice' for CMOD is to have a narrow date search by default which should meet the majority of user's needs, and then allow users to expand the dates they search if they need more information.

-JD.