Try adding a parameter like "VIEW_SIZE=1000" to the URL in your browser. In the set entries you mentioned where you put the 1000 was just a "default-value" which means that if there is a value in parameters.VIEW_SIZE then the 1000 you set will be ignored.

I haven't traced through the code, and hopefully there isn't anything on that screen/etc that ignores or does a hard override on this parameter, so this should work (it does in pretty much all of OFBiz where pagination is supported).

-David


On Jun 5, 2009, at 8:36 AM, ARays wrote:


Hello to OFBiz community. This is my first post on this forum and as you may
guess, still learning the ropes..

I am looking to get an export of all the entries in chart of accounts using
the export link in the screen URL below
https://demo904.ofbiz.org/accounting/control/globalGLSettings

While this page shows the records on the browser in a paginated fashion, I was hoping that the export and the print (PDF) would include all the records
in one shot avoiding pagination. However, that does not happen and the
export seems to only throw the records visible on the screen, 20 at a time.

Tried to follow the flow to GlobalGlAccountScreen.xml , <screen
name="ListGlAccounts"> and see the following code
               <!-- no longer works requies a fieldMap entity-and
entity-name="GlAccount" list="entityList" use-cache="true" >
                   <limit-range start="0" size="20"/>
               </entity-and -->
<set field="viewIndex" from- field="parameters.VIEW_INDEX"
type="Integer" default-value="0"/>
               <set field="viewSize" from-field="parameters.VIEW_SIZE"
type="Integer" default-value="50"/>

From it looks like the pagination is set to 50, but the screen still
paginates 20 at a time. How does one get to 50 for example?

Back to the export all records which seem to point to <screen
name="ListGlAccountsReport"> find that there is a setting to make the view
size very large (1000)
<set field="viewIndex" from- field="parameters.VIEW_INDEX"
type="Integer" default-value="0"/>
               <set field="viewSize" from-field="parameters.VIEW_SIZE"
type="Integer" default-value="1000"/>

But this too doesn't seem to take effect.

While I continue to dig further to get an understanding, would very much
appreciate if anyone can throw me some pointers.

Many thanks in advance
Aray

--
View this message in context: 
http://www.nabble.com/Chart-of-Accounts-export---does-not-export-all-records-at-a-time-tp23889451p23889451.html
Sent from the OFBiz - User mailing list archive at Nabble.com.


Reply via email to