nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Generate Geodatabase

jaykapalczynski

I am using the template example in appstudio to test downloading a geodatabase. Its working as it seems it should but I have a question that maybe someone can help answer

In the example it is setting up some Geodatabase Parameters. One of these is the Bounding box that the user specifies and as such all features within this box are downloaded to the Geodatabase.

My question. Can I add w where clause anywhere in there?

<SPAN class="comment token">// create the generate geodatabase parameters</SPAN>
GenerateGeodatabaseParameters <SPAN class="punctuation token">{</SPAN>
    id<SPAN class="punctuation token">:</SPAN> generateParameters
    extent<SPAN class="punctuation token">:</SPAN> generateExtent
    outSpatialReference<SPAN class="punctuation token">:</SPAN> SpatialReference<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createWebMercator</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    returnAttachments<SPAN class="punctuation token">:</SPAN> <SPAN class="keyword token">false</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I tried this but getting errors...

QueryParameters {
    id: params
    whereClause: "created_user = 'Law'"
}

// create the generate geodatabase parameters
GenerateGeodatabaseParameters {
    id: generateParameters
    extent: generateExtent
    outSpatialReference: SpatialReference.createWebMercator()
    returnAttachments: false
     
    QueryParameters: params
}<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Najděte více příspěvků označených jako

Accepted answers

All comments

jaykapalczynski

OK I see in the example here that they are referencing the layerOptions....was was leaning towards this potentially being a solution....

Although not sure how to proceed....would this be the area that I implement that....and what would be the syntax

if I work it in below is this done before the download occurs?

how would I add a date range and created_user = 'user1'

would it be something like this? layerOption2 ????

Again I am using the base template in appstudio for GenerateGeodatabase

                onLoadStatusChanged<SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">{</SPAN>
                    <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>loadStatus <SPAN class="operator token">===</SPAN> Enums<SPAN class="punctuation token">.</SPAN>LoadStatusLoaded<SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                        <SPAN class="keyword token">var</SPAN> idInfos <SPAN class="operator token">=</SPAN> featureServiceInfo<SPAN class="punctuation token">.</SPAN>layerInfos<SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">for</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">var</SPAN> i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">;</SPAN> i <SPAN class="operator token"><</SPAN> idInfos<SPAN class="punctuation token">.</SPAN>length<SPAN class="punctuation token">;</SPAN> i<SPAN class="operator token">++</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">{</SPAN>
                            <SPAN class="comment token">// add the layer to the map</SPAN>
                            <SPAN class="keyword token">var</SPAN> featureLayerUrl <SPAN class="operator token">=</SPAN> featureServiceInfo<SPAN class="punctuation token">.</SPAN>url <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/"</SPAN> <SPAN class="operator token">+</SPAN> idInfos<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>infoId<SPAN class="punctuation token">;</SPAN>
                            <SPAN class="keyword token">var</SPAN> serviceFeatureTable <SPAN class="operator token">=</SPAN> ArcGISRuntimeEnvironment<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createObject</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"ServiceFeatureTable"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN>url<SPAN class="punctuation token">:</SPAN> featureLayerUrl<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            <SPAN class="keyword token">var</SPAN> featureLayer <SPAN class="operator token">=</SPAN> ArcGISRuntimeEnvironment<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createObject</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FeatureLayer"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN>featureTable<SPAN class="punctuation token">:</SPAN> serviceFeatureTable<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            map<SPAN class="punctuation token">.</SPAN>operationalLayers<SPAN class="punctuation token">.</SPAN><SPAN class="token function">append</SPAN><SPAN class="punctuation token">(</SPAN>featureLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                            <SPAN class="comment token">// add a new GenerateLayerOption to array for use in the GenerateGeodatabaseParameters</SPAN>
                            <SPAN class="keyword token">var</SPAN> layerOption <SPAN class="operator token">=</SPAN> ArcGISRuntimeEnvironment<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createObject</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"GenerateLayerOption"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN>layerId<SPAN class="punctuation token">:</SPAN> idInfos<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>infoId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            
                            <SPAN class="keyword token">var</SPAN> layerOption2 <SPAN class="operator token">=</SPAN> ArcGISRuntimeEnvironment<SPAN class="punctuation token">.</SPAN><SPAN class="token function">createObject</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"GenerateLayerOption"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">{</SPAN>whereClause<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"created_user = 'law' "</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            
                            generateLayerOptions<SPAN class="punctuation token">.</SPAN><SPAN class="token function">push</SPAN><SPAN class="punctuation token">(</SPAN>layerOption<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            
                            generateLayerOptions<SPAN class="punctuation token">.</SPAN><SPAN class="token function">push</SPAN><SPAN class="punctuation token">(</SPAN>layerOption2<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                            
                            generateParameters<SPAN class="punctuation token">.</SPAN>layerOptions <SPAN class="operator token">=</SPAN> generateLayerOptions<SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>
                    <SPAN class="punctuation token">}</SPAN>
                <SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

LucasDanzinger

You can specify GenerateLayerOptions in the GenerateGeodatabaseParameters. This allows you to specify a where clause for each layer - GenerateGeodatabaseParameters QML Type | ArcGIS for Developers

jaykapalczynski

Thanks for your thoughts...

I can set up a definition expression after the fact but would like to include the limitation of records before the download occurs. That make sense? As the dataset gets larger I want to be able to limit the records downloaded by date range and user. Then do the download.....

ErwinSoekianto

Based on this documentation, GenerateGeodatabaseParameters QML Type | ArcGIS for Developers , GenerateGeodatabaseParameters does not have QueryParameters as listed property.

I am including ArcGIS Runtime SDK for Qt‌, to see if there is another way to achieve what you are asking.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.