Jump to content

igreenfi

Members
  • Posts

    2
  • Joined

  • Last visited

 Content Type 

Forum

Downloads

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Events

Profiles

Posts posted by igreenfi

  1. Hi,

    i have this query:

    {
        "collectionName" : "dayid_instanceid",
        'findQuery' : {
            '_id.day_id' : { '$gte' : $P{start_date_param} ,'$lt' : $P{end_date_param} },
            '_id.instance_id' : { '$in' : $P{instance_id_param} }
        },
        "sort" :
        {
            "_id" : 1
        }

    }

    the parameters are:

    <parameter name="end_date_param" class="java.util.Date"/>
    <parameter name="start_date_param" class="java.util.Date"/>
    <parameter name="instance_id_param" class="java.util.Collection"/>

    when i run the report

    I insert to the "instance_id_param" these values: -903099689, -913099689

    and i get this:

    {
        "collectionName" : "dayid_instanceid",
        'findQuery' : {
            '_id.day_id' : { '$gte' : {'start_date_param':null} ,'$lt' : {'end_date_param':null} },
            '_id.instance_id' : { '$in' : ['-903099689', '-913099689'] }
        },
        "sort" :
        {
            "_id" : 1
        }
    }

     

    so it take the "instance_id_param" as String not as long.

     

    help please.

    Izek

×
×
  • Create New...