query would yield 155331 rows (for later Excel-download). Maybe one of those query-rewrite errors?
|
Hi, As your query returns 155k rows, Formspider tries to send all to client into one little grid. While converting this big data to XML, apparently this issue comes about. However, as you can tell showing this much data on a grid at once is not the best idea. Therefore, we can suggest you using "Infinite Scroll" or "Paging" for your datasource instead of "Fetch All". The other thing regarding seeing the altered query: what you want to see is a fairly low-level Formspider-specific query. Thus, this wouldn't be very comprehensible for many people if it's not confusing. However, seeing these queries could be helpful on some specific issues as you rightly pointed out. To overcome, we may think to write down this information as a debug log into a debug table. Thank you very much for your feedback. Regards, |
This is a demo app which I'm trying to use to push FormSpider at my biggest customer. The LKID is the Tasknumber which stores the background data (start-date, end-date, warehouse-id, item-group-id) for which a batch job has calculated item-stocking key figures (avg. amount in stock, throughtput, etc..) There currently is only one LK_ID value. LK_Zeilen holds ~155.000 rows for that single task ID. I'd like to show the first couple of them LK_ZEILEN. The user (poweruser - decisionmaker) wants to download the rows into excel. The Datasource is default, e.g. "Fetch ALL", "Max. Row Fetch Size = All" I'm afraid that I have hit another case where FormSpider framed my query for pagination purposes. I really would appreciate an info textarea where FormSpider shows at design time what it'll do to my query during runtime. |