topic Re: Using GenerateGeodatabaseParameters's layerQueries property in qml in Qt Maps SDK Questions

Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Fri, 25 Mar 2016 16:00:47 GMT

Hi,

I want to filter data from specific service layer when generating a local geodatabase, when I use long query generating a local geodatabase gives an error.I also query the same query in rest api in web, when I make query with Query (GET) buton also show nothing in rest but when I make query with Query (POST) give correct result.How can I filer correct with layerQueries and generating a local geodatabase without error.

Thanks.

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Fri, 25 Mar 2016 16:22:11 GMT

What is the error? You should be able to specify a WHERE clause when generating your local geodatabase in the parameters.

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Mon, 28 Mar 2016 07:52:34 GMT

The error is when I generate geodatabase in GeodatabaseSyncTask in onGeodatabaseSyncStatusInfoChanged signal in geodatabaseSyncStatusInfo.statusString gives "Failed" status string info message.

I'm also specify WHERE clause when generating my local geodatabase in the parameters.When I use long query in paramater local geodatabase gives tahat error when I generate .

Thanks

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Mon, 28 Mar 2016 16:16:47 GMT

Can you use Fiddler and set up a proxy so that you can see if the http requests are returning any more detailed errors? ArcGIS Runtime SDK for Qt QML API: ArcGISRuntime Class Reference

What is an example of the long query you are using?

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Tue, 29 Mar 2016 08:45:29 GMT

Here is the long query below:

property var layerQueryList:[]

LayerQuery

{

id:layerQuery

}

Button {

id: generateButton

text: "Generate Geodatabase"

enabled: false

style: ButtonStyle {

label: Text {

text: control.text

color: control.enabled ? "black" : "grey"

horizontalAlignment: Text.AlignHCenter

}

onClicked:

{

generateGeodatabaseParameters.initialize(serviceInfoTask.featureServiceInfo);

generateGeodatabaseParameters.extent = mainMap.extent;

generateGeodatabaseParameters.layerIds=[1,2,5,6,17,18,19];

layerQuery.layerId=17;

layerQuery.includeRelatedFeatures=true;

layerQuery.queryOption=Enums.QueryOptionUseFilter;

layerQuery.useGeometry=false;

layerQuery.where="ID IN ('{BC768705-54F7-4040-8042-F42B66B72E9E}','{0D5A8097-7DB3-4049-A1D1-873460839496}','{E340CEB5-5A5F-4FCA-9F4F-836DA15EE25F}','{BC768705-54F7-4040-8042-F42B66B72E9E}','{E8A6ABB6-F478-4E96-B0DA-0694C0620BB4}','{A48FED7E-E2F7-4F9C-B0B1-D7F88334A596}','{E5521C3B-EA5C-4F74-B991-6786BE41A242}','{E340CEB5-5A5F-4FCA-9F4F-836DA15EE25F}','{583CFEF1-BD0D-4098-8422-E56AFE98FADF}','{2A70019D-D5CC-4C51-9458-0897AFD894A7}','{1330C3FB-3398-4E54-9229-BD2F4225F0D5}','{B4C69CF0-C545-4239-9CFA-2FEE291A0E4F}','{408BE8A9-120E-4B94-8798-28E5E6E8F2FC}','{5A4369FE-AD50-4814-8B99-CC89ACEC4649}','{BC1F1F27-A732-4782-A281-380055689D64}','{BC1F1F27-A732-4782-A281-380055689D64}','{9938A5AD-AB0C-4FF4-BEF7-2DFB55781223}','{D66DB646-2668-492D-9937-3CBA90DA5253}','{C3BC2D70-32EB-49F0-95D1-7EF98AA98165}','{9938A5AD-AB0C-4FF4-BEF7-2DFB55781223}','{A1110593-B5F4-4639-A95E-EB3AE8A628A5}','{D3487675-79B7-4BF4-BBB1-D90D11552A93}','{F06F2DF6-B9C5-4A73-80D7-5822261BA6E8}','{D3487675-79B7-4BF4-BBB1-D90D11552A93}','{3C64831B-6829-4FA9-99F7-4674C9BA3A78}','{1D336969-D342-44A9-B2A6-47FDD937372A}','{3C54BA79-A559-460F-914F-E6CC680ED264}','{D3487675-79B7-4BF4-BBB1-D90D11552A93}','{B4C69CF0-C545-4239-9CFA-2FEE291A0E4F}','{BC1F1F27-A732-4782-A281-380055689D64}','{C93E0F15-0DA2-42D7-9D6B-02AB7DFA4257}','{D85870A6-7004-44EE-8393-DB56D62CEF95}','{9938A5AD-AB0C-4FF4-BEF7-2DFB55781223}','{90ACE8D9-F673-4141-B784-E05061921998}')"

layerQueryList.push(layerQuery);

generateGeodatabaseParameters.layerQueries=layerQueryList;

generateGeodatabaseParameters.returnAttachments = false;

statusText.text = "Starting generate geodatabase task";

geodatabaseSyncTask.generateGeodatabase(generateGeodatabaseParameters, gdbPath);

}

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Tue, 29 Mar 2016 18:42:28 GMT

You should be able to go to the REST page of the service and click "Create Replica", and specify all of this info there. Does it work from the REST page? This is what you need to determine first, because if not, it will not work in a client API. If it does not work, then it either is a limitation with or a bug in ArcGIS Server.

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Wed, 06 Apr 2016 12:52:08 GMT

Hi Lucas ,

I'm specify all same info like above in REST page of the service and I'm creating replica .The Rest page of service replica result is correct and returns correctly records .Here is the REST Replica example belowin picture.How can I filter correct with layerQueries and generating a local geodatabase witout error in QML API ?

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Wed, 06 Apr 2016 15:57:54 GMT

My recommendation is to either contact Esri support to have them help you troubleshoot this, or to use Fiddler (or some other web debugging utility) to monitor the http traffic. I would compare the requests and responses when using the Runtime API and when just using the REST page to see if you can narrow down where the issue is, based on any differences that I see in the http requests.

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Thu, 07 Apr 2016 08:31:53 GMT

Lucas,

I'm using one of web debugging utility during generate my local geodatabase and I'm monitor the http traffic,the result query is with GET metod .In my opinion if I editing my query with POST method I can solve this long query problem .How can editing my codes with POST method from QML API? Can you help about this ?

Thanks

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Thu, 07 Apr 2016 16:47:00 GMT

Hmm, I wonder if you can try the following - ArcGISRuntime.doPost = true;

RuntimeQtSamples/main.qml at master · ldanzinger/RuntimeQtSamples · GitHub

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Thu, 07 Apr 2016 19:40:30 GMT

I added ArcGISRuntime.doPost = true; code in Component.onCompleted but again same exception gives .How can I solve with differenet way ?

Thanks

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Thu, 07 Apr 2016 20:33:14 GMT

What does the json response look like in fiddler? Do you get more details other than "failed"?

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Fri, 08 Apr 2016 13:18:56 GMT

Here is my response below in picture:

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Fri, 08 Apr 2016 15:42:10 GMT

This looks like just the request, not the response. In Fiddler, if you are in the Default view, you should see a box on the bottom right of the screen, with a bunch of tabs. Click on the JSON one.

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

tanerkoka1 — Mon, 11 Apr 2016 06:27:49 GMT

I can't see nothing request or something else in Fiddler ,so I can't see nothing in box or bottom right of the screen.Are there any idea how to se the request in Fiddler or to solve this problem with different way.

Thanks

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

FredNewcomer2 — Mon, 18 Apr 2016 19:26:09 GMT

I followed this discussion while trying to resolve my own dilemma. Using the "Create Replica" feature of a service's REST page was very helpful -- but misleading. For others attempting to troubleshoot similar problems, beware that the input json is never validated. I initially failed to close my LayerQueries expression with a final curly brace but ArcServer produced a replica without complaint. The faulty expression was ignored entirely which I only discovered after downloading and examining the replica with a SQLite utility.

From what I can tell, taner koka's expression fails because "IN" a list or subquery does not seem to be supported. A compound OR condition might work although I haven't needed to try. Unfortunately, many valid and useful WHERE clause expressions produce inexplicable errors. This is a serious problem which really needs to be resolved.

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

LucasDanzinger — Mon, 18 Apr 2016 20:39:10 GMT

Fred,

Thanks for your investigation. Can you please file a support request so that they can continue troubleshooting and log a bug?

Thanks,

Luke

Re: Using GenerateGeodatabaseParameters's layerQueries property in qml

AnthonyKobah — Mon, 09 May 2016 14:59:54 GMT

taner koka

You might have to set Standardized Queries to False if its failing to generate the database as a result of the WHERE clause.

By default, standardized Queries are set to true. Be mindful doing so will make your database more vulnerable to SQL injections. Please see the link below.

ArcGIS Help (10.2, 10.2.1, and 10.2.2)