topic Re: Potential Bug When Filtering Non-Spatial Table With Non-Spatial Table Parent in ArcGIS Runtime SDK for Android Questions

Potential Bug When Filtering Non-Spatial Table With Non-Spatial Table Parent

NathanMeade — Wed, 18 Sep 2024 19:50:01 GMT

The "setWhereClause()" for GenerateLayerOption doesn't work for non-spatial tables if they have a non-spatial table parent, unless the non-spatial parent table also has a where clause set.

See the code and comments below:

if (layerIdInfosMap.containsKey(generateLayerOption.getLayerId())) {
    if (wasGenerated) {
        if (wasFiltered) {
            generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.USE_FILTER);
            generateLayerOption.setWhereClause(featureLayerInfo.getWhereClause());
        } else {
            generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.ALL);
        }
    } else {
        generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.NONE);
    }
} else {
    if (wasGenerated) {
        if (wasFiltered) {
            generateLayerOption.setUseGeometry(false);
            generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.USE_FILTER);
            generateLayerOption.setWhereClause(featureLayerInfo.getWhereClause());
        } else {
            // The following code is a workaround for what we believe is a bug with the ArcGIS Android SDK:
            generateLayerOption.setUseGeometry(false);
            generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.USE_FILTER);
            generateLayerOption.setWhereClause("OBJECTID > -1");
            // This workaround should still get all of the features for this table.
            // The assumption being made right now is that each
            // ArcGIS Feature Service table has to have the OBJECTID Field.
            // This workaround addresses an issue where non-spatial tables with a
            // non-spatial parent relationship cannot be filtered unless a real where clause
            // is provided to the parent table as well.
            //
            // The actual call should be:
            // generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.ALL);
        }
    } else {
        generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.NONE);
    }
}

Re: Potential Bug When Filtering Non-Spatial Table With Non-Spatial Table Parent

GuntherHeppner — Wed, 25 Sep 2024 13:50:27 GMT

@NathanMeade - have you tried to use GenerateLayerOption.QueryOption.NONE in combination with
GenerateLayerOption.setIncludeRelated(true)? See the doc of setIncludeRelated which indicates that features/rows in this layer are included that are related to other layers/tables in the generated geodatabase.

generateLayerOption.setUseGeometry(false); generateLayerOption.setQueryOption(GenerateLayerOption.QueryOption.NONE); generateLayerOption.setIncludeRelated(true);

Re: Potential Bug When Filtering Non-Spatial Table With Non-Spatial Table Parent

NathanMeade — Wed, 25 Sep 2024 14:14:01 GMT

@GuntherHeppner What I am trying to do has nothing to do with relationships. I am just reporting that I am seeing this issue when there are specific kinds of relationships. Unrelated, I have done some testing with GenerateLayerOption.QueryOption.NONE in combination with
GenerateLayerOption.setIncludeRelated(true) but that was when I was seeing how relationships worked with the SDK. I'm not trying to do any of that here.

I'm assuming what I am observing is a bug then? Is this something that could be fixed in an SDK update? Also, is there a way to receive ESRI SDK support other than through this community website? This community site is helpful but it can be easier to have a miscommunication and also hoping for something that would be faster than an average turnaround time of about a week.

Re: Potential Bug When Filtering Non-Spatial Table With Non-Spatial Table Parent

NathanMeade — Wed, 16 Oct 2024 13:31:57 GMT

@GuntherHeppner @DiveshGoyal @RamaChintapalli Just making sure that this hasn't fallen through the cracks. Is this a current bug in the SDK? Should I go another route for escalating this issue (like not using this ESRI Community website)?

Re: Potential Bug When Filtering Non-Spatial Table With Non-Spatial Table Parent

GuntherHeppner — Tue, 22 Oct 2024 08:18:39 GMT

@NathanMeade to determine if this is a bug we will need more information. Please could you submit this issue with Esri Support, ideally providing an app that reproduces the issue. Thanks.