KB234935: How to Use URL API to Set Incremental Fetch of a Grid on a Document in MicroStrategy Web 9.4.1

• Strategy

The following article shows how to set the incremental fetch of a grid on a document with URL API

Users can set the rows per page property for incremental fetch on the grid in a document.

The following URL shows how to set the incremental fetch of a grid on a document with URL API:

JSP:


http://[Server name]:[Port]/MicroStrategy/servlet/mstrWeb?server=[Server Name]&project=[Project Name]&port=[Port]&uid=administrator&pwd=&evt=2048001&src=mstrWeb.2048001&visMode=0¤tViewMedia=2&documentID=[Document ID]&evt=2048009&src=mstrWeb.rwd.rwframe.rwb.2048009&data=[Grid Key]%1fFormattingIncrementalFetch%1fEnableIFOnGrid%1f1%1e%1f%1fMaxRows%1f4&applyToAllViews=0&formatType=1&evtorder=2048001%2c2048009&2048001=1&2048009=1

MaxRows is the property to set the rows per page for incremental fetch.

The previous URL sets the incremental fetch in the format editor in addition to getting the data.
The following URL will get the data incrementally in the URL without applying the setting under formats:

JSP:


http://[Server Name]:[Port]/MicroStrategy/servlet/mstrWeb?server=[Server Name] &Project=[Projec tName]&port=[Port]&evt=2048119&src=mstrWeb.rwd.rwframe.rwb.2048119&maxRows=[Incremental rows]&colPosition=-1&nodeKey=[Grid Key]&rowPosition=[Row position to start]&colMode=1&maxColumns=-1&evtorder=2048001&2c;2048119&2048001=1&2048119=1

Comment

0 comments

Details

Knowledge Article

Published:

June 15, 2017

Last Updated:

June 15, 2017