Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Calling report with date in auto search parameters

edited June 2008 in Server
I am having an issue calling a report on my server via the following example
url:

http://www.myweb.com/RBWebServer/RBWebServer.dll?content=pdf&volume=Report
Explorer Database&name=Backlog
Summary&framset=1&newsearch=T&asg0f0se=1/1/2008

The value of report.autosearchfields[0].searchexpression is 12/30/1899

What is the proper way to handle passing a date in the above manner?

Thanks All,
Branden Johnson

Comments

  • edited June 2008

    2008-1-1

    YYYY-MM-DD



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2008
    That did not work. Below is the url example i was trying

    http://www.myweb.com/RBWebServer/RBWebServer.dll?content=pdf&volume=Report
    Explorer Database&name=Backlog
    Summary&framset=1&newsearch=T&asg0f0se=2008-04-01

    http://www.myweb.com/RBWebServer/RBWebServer.dll?content=pdf&volume=Report
    Explorer Database&name=Backlog
    Summary&framset=1&newsearch=T&asg0f0se=2008-4-1

  • edited June 2008

    Try

    2008-1-1-0-0-0

    Looks like it wants

    yyyy-mm-dd-hh-nn-ss


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited June 2008
    That worked but a date like 2008-4-1-0-0-0 yields a
    report.autofields[0].SearchExpression of 5/1/2008?

  • edited June 2008

    It appears the webtier code was written to accomodate the Javascript Date
    object, which uses a zero based month (0 to 11).

    For RB 11, we can change it so that...

    1. The web search form is responsible for adjusting the Javascript month by
    one.

    2. The webiter will accpet yyy-mm-dd (i.e. 2008-1-1)


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.