JSAPI to get list of reports

akot
edited February 11, 2022 in Analytics #1
Hi All,

I am new to Birt & JS APIs. I am building a mashup application and wanted to know whether it is possible via JS APIs to get a list of reports that a user can access.

So basically, I get a list, JSON or XML, of all the files & folders with their meta information with user details passed. I have a custom security implementation.

Thanks
A

Comments

  • johnw
    edited December 31, 1969 #2
    Yes. I have done this before for several clients. Take a look at the JSAPI documentation at:
    http://www.birt-exchange.com/be/documentation/Manuals11SP3/using-jsapi.pdf

    Particularly the Report Explorer should do what you need.

    You can also write a simple web service that uses the Actuate IDAPI to get a list of files and return through JSON or XML. This is a much more flexible approach, and I use this more often in GWT applications.
    Warning No formatter is installed for the format ipb
  • akot
    edited December 31, 1969 #3
    Thanks John,

    I would prefer to take the second approach since I will have more control that way.

    Could you point me to some documentation and examples for IDAPI? I was looking at "http://www.birt-exchange.com/be/downloads/documentation", but could not find anything for IDAPI.

    Cheers
    A
  • johnw
    edited December 31, 1969 #4
    http://www.birt-exchange.com/be/documentation/R11SP3/mc/help/wwhelp/wwhimpl/js/html/wwhelp.htm#href=volume/about-encycAdmin.html

    Under Using Integration Technology. All of the Actuate Information Delivery API sections. There are a couple of methods you can use:
    GetFolderItems
    SelectFiles

    Hope that helps.
    John
    Warning No formatter is installed for the format ipb
  • akot
    edited December 31, 1969 #5
    Thanks John
  • <p>Hi, </p>
    <p> </p>
    <p>We have a similar requirement to get all the files being updated in production iHub. I am not well versed with IDAPI. Can anyone please share sample <span style="color:rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;">Actuate IDAPI code to get a list of files from the public folders and the last modified date?</span></p>
    <p> </p>
    <p>Appreciate all your help in advance.</p>
    Warning No formatter is installed for the format ipb
  • <p>The REST API is a new feature available with the iHub.  What version of iHub are you running?</p>
    <p> </p>
    <p>For iHub 3.1.1, use getFileItems where you will pass in a Folder ID:</p>
    <p><a data-ipb='nomediaparse' href='http://yourihubservername:5000/ihub/v1/ihubrestdocs/#!/files/getFileItems'>http://yourihubservername:5000/ihub/v1/ihubrestdocs/#!/files/getFileItems</a></p&gt;
    <p> </p>
    <p>For iHub 16 use the REST API v2, where you will pass in the path to your public folders via the "search" parameter:</p>
    <p><a data-ipb='nomediaparse' href='http://ussm-qa-ihub16-win.lab.opentext.com:8000/api/v2/ihubrestdocs/#!/files/getFileListFromRoot'>http://ussm-qa-ihub16-win.lab.opentext.com:8000/api/v2/ihubrestdocs/#!/files/getFileListFromRoot</a></p&gt;
    <p> </p>
    <p> </p>
    <p>You can still use IDAPI, which is SOAP based.  There is an IDAPI wrapper that is available which makes using the IDAPI a little easier.  It's available @ <a data-ipb='nomediaparse' href='https://github.com/puckpuck/idapi-wrapper'>https://github.com/puckpuck/idapi-wrapper</a></p&gt;
    Warning No formatter is installed for the format ipb
  • <p>Hi Clement, </p>
    <p> </p>
    <p>Thanks for responding! We have iHub3.1.1. </p>
    <p> </p>
    <p>Is it possible to have a BIRT report get the list of all the available reports in production?</p>
    Warning No formatter is installed for the format ipb
  • Clement Wong
    Clement Wong E mod
    edited November 15, 2016 #9
    <p>For iHub 3.1.1, there is a REST API for the iHub, but on the report development side, the REST API ODA was added into iHub 16.</p>
    <p> </p>
    <p>So for your version, we'll need to use a report that uses IDAPI's GetFolderItems via the Web Services ODA.</p>
    <p> </p>
    <p>Attached is an example.  You can upload it to your iHub and run it as is.  It will list all files and folders in the root of the your volume ("/").</p>
    <p> </p>
    <p>The report can be parameterized or you can change the hardcoded value of the path in the SOAP Request's <span style="font-family:'courier new', courier, monospace;"><m:FolderName>/</m:FolderName> </span>element.</p>
    Warning No formatter is installed for the format ipb
  • <p>Thanks Clement!</p>
    <p> </p>
    <p>I uploaded the report and tried to run and getting 17070 error.</p>
    <p> </p>
    <div> Job execution failed because it was cancelled: There is an error in processing your request. Error code: 17070.</div>
    <div>  Job Type = Sync Transient</div>
    <div>  WriteLockHandle = 17</div>
    <p> </p>
    <p>Are there no WSDL or settings that needs to be changed in the report?</p>
    <p> </p>
    <p>Our ihub31 is hosted on linux server. Does that change anything?</p>
    Warning No formatter is installed for the format ipb
  • <p>I tested on a BIRT iHub 3.1 (Build 231A150206) on Linux [CentOS 7.2] and the report works out of the box.  And also tried on a BIRT iHub 3.1 and 3.1.1 on Windows.  I tried with administrator and non-administrator account.  Both didn't have any issues as either on-demand, or as a scheduled report.</p>
    <p> </p>
    <p>What's the exact version of iHub that you're running?</p>
    <p> </p>
    <p>To get the version, after logging into Information Console as administrator, select Manage Volume in the lower part of the left pane.  Then, you'll see the iHub version near the top the right pane (in the first tab, General).</p>
    <p> </p>
    <p>You have a firewall or anything that might be blocking ports?</p>
    <p> </p>
    <p>Did you change the SOAP port of iHub?  The report assumes that localhost:8000 will be the endpoint.</p>
    <p> </p>
    <p>Does localhost resolve?  As a test, can you update the XML of the report and change localhost to the name of your server, and reupload and test again?</p>
    <p> </p>
    <p>Does the WSDL page return for your server?  For example:</p>
    <pre class="_prettyXprint">
    http://youriHubhostname:8000/wsdl/v11/axis/all</pre>
    <p>Can you run the report on-demand?</p>
    <p> </p>
    <p>Can you schedule the report?  If it fails, do you see the same error in the job details?</p>
    Warning No formatter is installed for the format ipb
  • actuser9
    edited November 16, 2016 #12
    <p>Hi Clement,</p>
    <p> </p>
    <p>The version that we have is is <span style="color:rgb(70,70,70);font-family:'Source Sans Pro';">BIRT iHub 3.1.1 (Build 231A150710).</span></p>
    <p> </p>
    <p><span style="color:rgb(70,70,70);font-family:'Source Sans Pro';">I did try to change the WSDL in the report and getting this error.</span></p>
    <pre class="_prettyXprint">
    org.eclipse.datatools.connectivity.oda.OdaExceptionat org.eclipse.datatools.enablement.oda.ws.impl.Connection.open(Connection.java:81)
    at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
    at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.open(OdaConnectionWrapper.java:209)
    at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionWrapper.<init>(OdaConnectionWrapper.java:59)
    at org.eclipse.datatools.connectivity.oda.profile.OdaConnectionFactory.createConnection(OdaConnectionFactory.java:26)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
    at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
    at org.eclipse.datatools.enablement.oda.ws.ui.wizards.WebServicePropertyPage$1.run(WebServicePropertyPage.java:89)
    at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)
    at org.eclipse.datatools.connectivity.ui.wizards.ProfileDetailsPropertyPage.testConnection(ProfileDetailsPropertyPage.java:98)
    at org.eclipse.datatools.connectivity.ui.wizards.ProfileDetailsPropertyPage$1.widgetSelected(ProfileDetailsPropertyPage.java:80)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)
    at org.eclipse.jface.window.Window.open(Window.java:801)
    at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:117)
    at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSourceNodeProvider.performEdit(EditableDataSourceNodeProvider.java:73)
    at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472)
    at sun.reflect.GeneratedMethodAccessor238.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.eclipse.birt.report.designer.ui.views.ElementAdapterInvocationHandler.invoke(ElementAdapterInvocationHandler.java:89)
    at com.sun.proxy.$Proxy43.performRequest(Unknown Source)
    at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:85)
    at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)
    at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214)
    at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:845)
    at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
    at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)
    at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)
    at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:843)
    at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1477)
    at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1246)
    at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:249)
    at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:246)
    at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:307)
    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1053)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1053)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:942)
    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)
    at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:588)
    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:543)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
    at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)
    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    </pre>
    <div>WSDL Page is returning the error:</div>
    <pre class="_prettyXprint">
    HTTP Status 500 -

    type Exception report


    message


    description The server encountered an internal error that prevented it from fulfilling this request.


    exception


    java.lang.NullPointerException
    com.actuate.ihub.wsdl.AcWSDLCreator.getAllWSDL(AcWSDLCreator.java:93)
    com.actuate.ihub.wsdl.AcWSDLCreator.getAPIDefinition(AcWSDLCreator.java:56)
    com.actuate.ihub.wsdl.AcWSDLContextPathProcessor.process(AcWSDLContextPathProcessor.java:79)
    com.actuate.ihub.filter.LocalFilter.processRequest(LocalFilter.java:300)
    com.actuate.ihub.filter.RequestFilter.doFilter(RequestFilter.java:252)
    com.actuate.ihub.filter.RequestFilterChain.processFilter(RequestFilterChain.java:50)
    com.actuate.ihub.filter.RequestFilterManager.processFilters(RequestFilterManager.java:47)
    com.actuate.ihub.web.FilterServlet.doRequest(FilterServlet.java:137)
    com.actuate.ihub.web.FilterServlet.doGet(FilterServlet.java:82)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    note The full stack trace of the root cause is available in the Apache Tomcat/7.0.47 logs.

    </pre>
    Warning No formatter is installed for the format ipb
  • <p>Hi Clement,</p>
    <p> </p>
    <p>Is the WSDL "<span>http</span><span style="color:rgb(102,102,0);">:</span><span style="color:rgb(136,0,0);">//youriHubhostname:8000/wsdl/v11/axis/all</span>" generated by the iHub install or is this something that needs to be set up after the installation?</p>
    Warning No formatter is installed for the format ipb
  • <p>I could notice these errors on iHub311 when the wsdl page is browsed.</p>
    <pre class="_prettyXprint">
    SEVERE: Fail to get html file. Exception: /opt/actuate/BIRTiHubVisualization/modules/BIRTiHub/iHub\etc\idapi_index.html (No such file or directory)
    </pre>
    <pre class="_prettyXprint">
    SEVERE: Servlet.service() for servlet [FilterServlet] in context with path [] threw exception
    java.lang.NullPointerException
    at com.actuate.ihub.wsdl.AcWSDLCreator.getAllWSDL(AcWSDLCreator.java:93)
    at com.actuate.ihub.wsdl.AcWSDLCreator.getAPIDefinition(AcWSDLCreator.java:56)
    at com.actuate.ihub.wsdl.AcWSDLContextPathProcessor.process(AcWSDLContextPathProcessor.java:79)
    at com.actuate.ihub.filter.LocalFilter.processRequest(LocalFilter.java:300)
    at com.actuate.ihub.filter.RequestFilter.doFilter(RequestFilter.java:252)
    at com.actuate.ihub.filter.RequestFilterChain.processFilter(RequestFilterChain.java:50)
    at com.actuate.ihub.filter.RequestFilterManager.processFilters(RequestFilterManager.java:47)
    at com.actuate.ihub.web.FilterServlet.doRequest(FilterServlet.java:137)
    at com.actuate.ihub.web.FilterServlet.doGet(FilterServlet.java:82)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
    </pre>
    Warning No formatter is installed for the format ipb
  • <p>The iHub provides this functionality out of the box.  There is nothing to set up.</p>
    <p> </p>
    <p>Please contact OpenText Analytics Support to assist you in troubleshooting why this is not available/working in your environment.</p>
    <p> </p>
    <p>If you can log into iHub via Information Console, then I don't see why your iHub's SOAP port is not responding correctly.</p>
    <p> </p>
    <p>For troubleshooting, please provide Support with the following:</p>
    <p> </p>
    <p>1. acpmdconfig.xml   (found in iHub's /etc directory)</p>
    <p>2. acserverconfig.xml   (found in iHub's /shared/config directory)</p>
    <p>3. Results from the following URL.  The expected result is a blank page.</p>
    <pre class="_prettyXprint">
    http://youriHubservername:8000</pre>
    <p>4. Results from the following URL.  The expected result is a simple WSDL choice page.</p>
    <pre class="_prettyXprint">
    http://youriHubservername:8000/wsdl</pre>
    <p>When this (iHub's SOAP) is working, then the example report (unmodified) will work.  No need to change WSDL.  The WSDL is just for troubleshooting purposes.</p>
    Warning No formatter is installed for the format ipb
  • <p>Hi Clement,</p>
    <p> </p>
    <p>I have contacted Actuate support. </p>
    <pre class="_prettyXprint">
    For No.3, I get a HTTP Error 501 that the page is not working.

    For No.4, I am getting a blank page.</pre>
    <p>The iHub and linux version are as follows:</p>
    <div> </div>
    <div>Product Version:</div>
    <div>BIRT iHub 3.1.1 (Build 231A150710)</div>
    <div> </div>
    <div>Platform : Linux</div>
    <div>OS Version : 2.6.32-642.1.1.el6.centos.plus.x86_64</div>
    <div> </div>
    <div>Can you please verify if the report still works on your end with this configuration?</div>
    Warning No formatter is installed for the format ipb
  • <p>It looks like there was a bug in iHub311 on Linux. Seems to be resolved with few file updates on iHub server.</p>
    <p> </p>
    <p>I am able to run the report and can see the output. If I have the below folder structure, can I pull the files from all levels as well as shown in the sample below?</p>
    <p> </p>
    <p>Public</p>
    <p>      Folder1</p>
    <p>                    Report1 type date</p>
    <p>                    Report2 type date</p>
    <p>      Folder2</p>
    <p> </p>
    <p>                    Report1 type date</p>
    <p>                    Report2 type date</p>
    <p>      Folder3</p>
    <p> </p>
    <p> </p>
    <p>                    Report1 type date</p>
    <p>                    Report2 type date</p>

    <p>                    Report1 type date</p>
    <p>                    Report2 type date</p>
    Warning No formatter is installed for the format ipb
  • Clement Wong
    Clement Wong E mod
    edited November 18, 2016 #18
    <p>That's excellent that you're able to work with Support so quickly and get a solution.</p>
    <p> </p>
    <p>Now that your iHub is running as expected, you can use the IDAPI <strong>selectFiles </strong>(with recursive option) instead of the <strong>getFolderItems </strong>operation, but you're going to have a lot of results returned.</p>
    <p> </p>
    <p>You can limit that search too by using a Search definition.</p>
    <p> </p>
    <p>To list the file's type, we would add it to the ResultsDef as <em>FileType</em>.</p>
    <p> </p>
    <p>Attached is example hard-coded to list all files/folders from the root.  The report can be customized so that the folder path can be a parameter.</p>
    Warning No formatter is installed for the format ipb
  • <p>Thank you very much, Clement! The report works like a charm and would try to input mutiple inputs for the folders.</p>
    <p> </p>
    <p>I am very much surprised at the response time and solution as well with resolving this issue.</p>
    Warning No formatter is installed for the format ipb
  • <p>HI Clement, </p>
    <p> </p>
    <p>Two issues that I am noticing with the report results. </p>
    <p> </p>
    <p>1. Not all the reports are showing up in the report. I have 10-12 folders but only few folders and the folders are showing in the report.</p>
    <p>2. The time stamp used in the report is showing in GMT I guess. I tried to edit to take out 6 hours, but I think few reports are showing like 5 or 7 hours, must be also including the day light savings I guess. Do you have a possible solution for this?</p>
    <p> </p>
    <p>If, I want to show the latest updates to files in this month(Parameter1) based on multiple values for folders(Parameter2), would that be possibility in the report?  </p>
    Warning No formatter is installed for the format ipb
  • <p>1. Could you provide some more details? When I run the sample report, I do see all files/folders listed. There does not appear to be a sort specified so the default result will likely not be in any kind of logical order. Applying a sort to the table should make things easier to find.</p>
    <p> </p>
    <p>2. It does appear the time stamp response is in GMT from the server. You could create a new computed column, parse the response into a new javascript date object and then use the javascript date functions to pull the localized result for timezone.</p>
    <p> </p>
    <p>It should be possible to adjust the report for your additional parameters.</p>
    <p>The documentation showing the available request/response details for SelectFiles can be found here: <a data-ipb='nomediaparse' href='http://developer.actuate.com/be/documentation/ihub31-dev/APIReference/index.html#page/APIReference/idapi-ops-ref.04.2.html#'&gt;http://developer.actuate.com/be/documentation/ihub31-dev/APIReference/index.html#page/APIReference/idapi-ops-ref.04.2.html#&lt;/a&gt;&lt;/p&gt;
    Warning No formatter is installed for the format ipb
  • <p>Hi Jesse,</p>
    <p> </p>
    <p>Thanks for your response.</p>
    <p> </p>
    <p>1. I have verified in test and production, the files populated in the report are showing up a maximum of 500. I tried to verify if there is a fetch size option set, but no luck yet.</p>
    <p> </p>
    <p>2. I tried to parse and use local time format but getting date could not be parsed error.</p>
    Warning No formatter is installed for the format ipb
  • <p>HI, </p>
    <p> </p>
    <p>Regarding 1 above, I have found this as part of the documentation, where can this setting be changed?</p>
    <p> </p>
    <div>FetchSize</div>
    <div>Int. Optional. The maximum number of records to retrieve and return in a result</div>
    <div>set. The default value is 500.</div>
    Warning No formatter is installed for the format ipb
  • actuser9
    edited November 23, 2016 #24
    <p>For anyone looking for this, fetchsize and file type could be changed by adding the below to the report SOAP request.</p>
    <pre class="_prettyXprint">
    <SOAP-ENV:Body>
    <m:SelectFiles xmlns:m="http://schemas.actuate.com/actuate11">
    <m:WorkingFolderName>/</m:WorkingFolderName>
    <m:Recursive>true</m:Recursive>
    <m:LatestVersionOnly>true</m:LatestVersionOnly>
    <m:ResultDef>
    <m:String>Name</m:String>
    <m:String>TimeStamp</m:String>
    <m:String>FileType</m:String>
              </m:ResultDef>
              <m:Search>
                <m:Condition>
                   <m:Field>FileType</m:Field>
                   <m:Match>RPTDESIGN</m:Match>
                </m:Condition>
                <m:FetchSize>10000</m:FetchSize>
                </m:Search>
    </m:SelectFiles></pre>
    Warning No formatter is installed for the format ipb
  • <p>To get the local date from GMT, the below column binding worked. Sadly I had to spend few days to get to this point. Hope this saves time for others.</p>
    <p> </p>
    <p>toLocaleString() does not seem to work for the correct timestamp!</p>
    <pre class="_prettyXprint">
    var currenttime = new Date(row["TimeStamp"]);
    var n= currenttime.getTimezoneOffset();
    BirtDateTime.addMinute(currenttime,-n);</pre>
    Warning No formatter is installed for the format ipb