Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

"Top 10" records using Advanced Find

0 views
Skip to first unread message

Bharat Chawla

unread,
Aug 26, 2010, 11:34:03 PM8/26/10
to
Hello,

Using Advanced Find, can I fetch “Top 10” records?
Help and Support Appreciated.

BB

Srihari R

unread,
Aug 27, 2010, 1:42:03 AM8/27/10
to
Hi Bharat,

You cannot get the Top 10 records using an Advanced Find but you can
definitely get this result using the Report Wizard.

Try creating a new report and then use the report wizard to get the top x
rows. You would however need to add a numeric column in your report to
achieve this.

--
Srihari R

Bharat Chawla

unread,
Aug 29, 2010, 10:19:03 PM8/29/10
to
Hello Srihari,

Thanks for your response.

For some requirement, I wanted it to be from Advanced Find or Fetch XML.
I have checked Fetch XML operators but there is no such operator to get “Top
10” records.
But I already have SQL query for the same.

Appreciate your help.

BB

Mahain

unread,
Sep 1, 2010, 9:02:48 AM9/1/10
to
On Aug 30, 7:19 am, Bharat Chawla

Hi Bharat,

you can try to write plugin on Execut method to limit advance find
result to 10 records.
you can check this http://a33ik.blogspot.com/2009/09/overriding-records-per-page-count-for.html
you can modify this plugin accordingly

Hope it will help you

0 new messages