Select to view content in your preferred language

Filtering for GlobalID?

1494
4
01-18-2020 11:48 AM
WinleyDurham
Occasional Contributor

Is it possible on Survey123 to "filter" for Global ID? I see you can filter for Object ID, but the same option for Global ID isn't possible. However, this code does export to excel sheets, so I'm wondering why it's not possible to filter by it if the data is store in the table?

Thanks!

4 Replies
JamesTedrick
Esri Esteemed Contributor

Hi Winley,

Can you provide an example of where you would filter by GlobalID?  GlobalIDs in general are database-maintained values for internal use- it is not expected that a user would regularly type one in.

0 Kudos
MarcelBeckmann
Regular Contributor

Hey James,

I would argue in any Database System you can do the following:
SELECT * FROM TABLE WHERE GLOBALID = 'my_globalid';
Or in Survey you could set up a filter where the globalid starts with 'ABC'. (You also can do this in a database 😉) I dont think anyone would type the whole globalid.

And in many Cases this is super convenient. So why not provide the user with this functionality? And I really mean it! WHY?!

And in my spcial case. We have a FME Workbench which is very complex and joins many tables from different system. This Workbench fails because of one entry. And being able to filter for this one entry in survey (table and repeats) with thousands of entries would help me a lot. 

0 Kudos
JohnRagosta
Emerging Contributor

It is helpful to validate joins of data tables from repeats.  The Parent Global ID is the only thing connecting the the child table to the parent table.  Why not allow filtering on these critical fields? 

SusanPollard
Regular Contributor

I would like to filter  so the selected record's and it repeats are only displayed. IE show only record with selected global ID equals repeat's Parent GlobalID. The parent point and its repeats are only features displayed on the map. The map setting syntax should allow zoom to the extent of the repeats in a single map in the feature report. Is this possible?