cancel
Showing results for 
Search instead for 
Did you mean: 

Java API: Manage count of records when Search

Former Member
0 Kudos

Hi to all.

After using Java API i noticed that with Java API i can get less or equal of 1000 records only.

1st Question is - Can i set quantity of records when Search?

for example i want to get only 1 record which satisfied search criteria.

2nd Question is - Can i get quantity of records which satisfied search criteria?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi, Mike.

The answer on your first question is


RetrieveLimitedRecordsCommand cmd;
...
cmd.setPageSize(1);   // records count
cmd.setPageIndex(0);

But I haven't any good ideas about the second question...

How can I get count of records satisfied search criteria?

Did you found appropriate solution?

Former Member
0 Kudos

Hi, Pavel!!

Thx great for answer!!

I'm tiny confused because solution not so difficult, but i can get it by myself

Could u also explain what does it mean PageIndex?

RetrieveLimitedRecordsCommand cmd;
...
cmd.setPageSize(10);   // records count
cmd.setPageIndex(1);

As i understood the first record will be 11 record which is satisfied search criteria. am i right?

as about 2nd question i've found method

.getSearchTableMatchCount()

(at the same class

RetrieveLimitedRecordsCommand

) two minutes ago but still not try it.

З.Ы. Респект, чувак, оч.выручил как твои дела с полями Real?

Former Member
0 Kudos

Hi, Mike.

About PageIndex - you are right. In the example


RetrieveLimitedRecordsCommand cmd;
...
cmd.setPageSize(s);
cmd.setPageIndex(p);

you will get records from sp to s(p+1) exclusively. Recors numbers start from zero, e.g. p=0, s=10 - first ten records (0-9); p=1, s=10 - second ten records (10-19).

And about the getSearchTableMatchCount method. This is difinitely what I need, but I have to use API version SP05 which doesn't contain this method...

З.Ы. Поля конвертировали в Currency.

Answers (0)