Filter on Object Table
I'm trying to create a report based only on an object table in a map service. The table has a field of type esriFieldTypeOID. I'm trying to filter the records on a field in that table, but the filter is not working: instead of returning one record it returns 1833. The field I am filtering is of type esriFieldTypeInteger. I've also tried filtering on a different field, of type esriFieldTypeString, but that gives the same result. Even a really basic report doesn't work. I start with a blank report, add the object table as the data source then set up the filter and it doesn't work. I'm not using any layers in the report, nor am I using any joins or relationships and there are none defined in the object table.
I'm using Geocortex (VertiGIS Studio) Reporting on-premises 5.15.2.
-
Mark - Can you provide the screenshots of your filter that you are doing in Reporting 5?
Thanks,
Claire0 -
At the REST endpoint of the map service's object table: GISID_INT = 64333 returns only 1 record.
0 -
If I use the same query in the filter for the report I get 1833 results in VertiGIS Studio Reporting.
0 -
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. ?Golfcoursehttps://www.youtube.com/playlist?list=PLTjPVjeiNQihGAEzeE7cavkDGjXfKa_YU
They have a tech tip video that steps through the process.
Thanks,
Claire
0 -
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.
Comments
5 comments