Unable to create Report Request from Rest API

rrameshbtech · January 20, 2020, 9:38am

Hi All,

In our current requirement, we need to show report result when user clicks on a link.

For example in dashboard, we will be showing list of report names and when user clicks on the report name it should show the results of reports.

Do we have any way to show result of reports in click of a link or button?

We are unable to find any direct way to do it. So we thought we can create a Report Request using Rest API & use the Report Request to show the report result using below url.

https://demo.openmrs.org/openmrs/module/reporting/reports/viewReport.form?uuid=<Report Request Id>

But still we are unable to create ReportRequest using below Rest API as we are unable find structure of data we need to send as body to this request.

POST:https://demo.openmrs.org/openmrs/ws/rest/v1/reportingrest/reportRequest/

CC: @mksd, @angshuonline, @mddubey

mksd · January 20, 2020, 1:39pm

A WIP example here (credits to @binduak.)

@mseaton, wondering if you’d have further examples to point the TW team to?

mseaton · January 21, 2020, 1:43am

@rrameshbtech and @mksd, I don’t have a lot of code personally that utilizes these. But maybe it is helpful to look the actual code behind these resources, and (probably more importantly) any unit tests that exist that show how they might be used:

github.com

openmrs/openmrs-module-reportingrest/blob/master/omod/src/main/java/org/openmrs/module/reportingrest/web/resource/ReportRequestResource.java

/**
 * This Source Code Form is subject to the terms of the Mozilla Public License,
 * v. 2.0. If a copy of the MPL was not distributed with this file, You can
 * obtain one at http://mozilla.org/MPL/2.0/. OpenMRS is also distributed under
 * the terms of the Healthcare Disclaimer located at http://openmrs.org/license.
 * <p>
 * Copyright (C) OpenMRS Inc. OpenMRS is a registered trademark and the OpenMRS
 * graphic logo is a trademark of OpenMRS Inc.
 */
package org.openmrs.module.reportingrest.web.resource;

import java.util.List;
import java.util.Map;

import org.apache.commons.beanutils.PropertyUtils;
import org.apache.commons.lang3.StringUtils;
import org.openmrs.api.context.Context;
import org.openmrs.module.reporting.cohort.definition.CohortDefinition;
import org.openmrs.module.reporting.definition.DefinitionContext;
import org.openmrs.module.reporting.evaluation.parameter.Mapped;

This file has been truncated. show original

github.com

openmrs/openmrs-module-reportingrest/blob/master/omod/src/test/java/org/openmrs/module/reportingrest/web/resource/ReportRequestResourceTest.java

package org.openmrs.module.reportingrest.web.resource;

import static org.hamcrest.core.Is.is;
import static org.junit.Assert.assertThat;

import java.util.Date;
import java.util.List;
import static org.junit.Assert.assertEquals;
import static org.junit.Assert.assertNotNull;
import static org.junit.Assert.assertNull;


import org.junit.Before;
import org.junit.Test;
import org.openmrs.api.context.Context;
import org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition;
import org.openmrs.module.reporting.cohort.definition.service.CohortDefinitionService;
import org.openmrs.module.reporting.dataset.definition.SqlDataSetDefinition;
import org.openmrs.module.reporting.evaluation.parameter.Parameter;
import org.openmrs.module.reporting.evaluation.parameter.ParameterizableUtil;

This file has been truncated. show original

Best, Mike

rrameshbtech · January 23, 2020, 6:34am

Thanks everyone. It is really helpful.