Skip to main content

Filter on Object Table

Comments

5 comments

  • Claire Inbody

    Mark - Can you provide the screenshots of your filter that you are doing in Reporting 5?

     

    Thanks,
    Claire

    0
  • Mark Norbury

    At the REST endpoint of the map service's object table: GISID_INT = 64333 returns only 1 record.

    0
  • Mark Norbury

    If I use the same query in the filter for the report I get 1833 results in VertiGIS Studio Reporting.

    0
  • Claire Inbody

    Mark,

    Do you have a parameter set in the report itself.

    This is what the preview report sees. 

    Then you have your filter in the database that you show as GISID_INT = your number

    I havent work with specifying a specific number in the query builder part. I also make a parameter in the query builder to then call the report parameter. Ie. ?Golfcourse 

    https://www.youtube.com/playlist?list=PLTjPVjeiNQihGAEzeE7cavkDGjXfKa_YU

    They have a tech tip video that steps through the process.

    Thanks,

    Claire

    0
  • Mark Norbury

    For this example, I don't have any parameter defined, just to keep it simple.  However if I add a parameter and then type one in when it's run I still get the same issue.

    Incidentally the esriFieldTypeOID field has the same value for most of the records.  Is this likely to be the cause of the issue?

    0

Please sign in to leave a comment.