Fantastic! Thanks for the tips, David, Freeman.. I could get it working for both cases regular pagination as well as export by changing
<set field="viewSize" from-field="parameters.VIEW_SIZE" type="Integer" default-value="1000"/> to <set field="parameters.VIEW_SIZE_1" from-field="parameters.VIEW_SIZE" type="Integer" default-value="1000"/> So, looks like the parameter is VIEW_SIZE_1.. Interestingly I don't see this used anywhere else in ofbiz. Need to dig deeper perhaps but looks like the <set field="viewSize" is being used at several places for pagination. So, is there a better way to fix it for all cases rather than changing the line above (I haven't checked other cases but going to do shortly)? Sorry, I am still trying to get my head around how this works. -Aray ---------------------------------------------------- BJ Freeman wrote: > > a work around I think is to click on the next button so then change the > URL > N&VIEW_SIZE_1=20&VIEW_INDEX_1=1# > to > N&VIEW_SIZE_1=461&VIEW_INDEX_1=1# > > will give you one page > I am not sure the printing will follow but you can give it a try. > > ARays sent the following on 6/5/2009 7:36 AM: >> 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 >> > > -- > BJ Freeman > http://www.businessesnetwork.com/automation > http://bjfreeman.elance.com > http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro > Systems Integrator. > > > -- View this message in context: http://www.nabble.com/Chart-of-Accounts-export---does-not-export-all-records-at-a-time-tp23889451p23898490.html Sent from the OFBiz - User mailing list archive at Nabble.com.