on 04-30-2008 6:59 AM
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?
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.