← Back to team overview

dhis2-devs team mailing list archive

Re: Issue with date varibales for Sql View of type allows for variables

 

The dates should be like this: 20150101 and 20151231. Actually, the manual
is confusing on this point, as it starts with dashes:

https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s04.html

On Tue, Sep 15, 2015 at 8:26 AM, Bharath <chbharathk@xxxxxxxxx> wrote:

> Hi,
>
> I have created a sample sql view which has 2 variable parameters namely
> startDate and endDate. My sql view looks like:
>
>
> *SELECT dv.* from datavalue dv inner join period p on dv.periodid =
> p.periodid where p.periodtypeid = 8 and p.startdate >= '${startDate}' and
> p.enddate <='${endDate}' limit 500;*
>
> I am trying to pass these 2 date values from api url, but getting below
> error message:
>
> URI:
>
> https://apps.dhis2.org/demo/api/sqlViews/Eod3B6ET3dw/data.json?var=startDate:2015-01-01&var=endDate:2015-03-31
>
> Response:
> {
>
>    - httpStatus: "Conflict",
>    - httpStatusCode: 409,
>    - status: "ERROR",
>    - message: "SQL query contains variables which were not supplied in
>    request: [endDate, startDate]"
>
> }
>
> If I place these date values inside sqlview then I am able to get the
> result.
>
> Can you please help me to find where I am doing mistake. Thanks.
>
>
>
>
> --
>
> Regards,
> Bharath Kumar. Ch
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org

Follow ups

References