topic Re: How to query server-side FeatureTable? in ArcGIS JavaScript Maps SDK Questions

How to query server-side FeatureTable?

ForrestLin — Fri, 16 Aug 2024 18:06:22 GMT

Is it possible to query server-side FeatureTable without re-creating FeatureLayer?

Re: How to query server-side FeatureTable?

MatthewDriscoll — Thu, 15 Aug 2024 13:27:19 GMT

You can bring it in as a FeatureLayer and query it the same as you would as a feature layer.

Re: How to query server-side FeatureTable?

ForrestLin — Thu, 15 Aug 2024 13:53:52 GMT

@MatthewDriscoll

Thank you for your help!

Is it possible that FeatureTable get updated automatically when querying FeatureLayer?

Re: How to query server-side FeatureTable?

MatthewDriscoll — Thu, 15 Aug 2024 14:00:27 GMT

What do you mean? Are trying to edit a FeatureTable through a query?

Re: How to query server-side FeatureTable?

ForrestLin — Thu, 15 Aug 2024 16:28:49 GMT

@MatthewDriscoll

function handleQueryResults() {

    let queryBP = bldPermLayer.createQuery();
    queryBP.where = "query"
    queryBP.outFields = ["*"];
    // do the query 
    bldPermLayer
        .queryFeatures(queryBP)
        .then((response) => {
           // code 
        });
}

The response is FeatureSet, right? How to update FeatureTable using the response? Or FeatureTable got updated already?

Thanks.

Forrest

Re: How to query server-side FeatureTable?

MatthewDriscoll — Thu, 15 Aug 2024 16:31:44 GMT

Do what you want with it in the code. It's the same data so it could go something like below.

function handleQueryResults() { let queryBP = bldPermLayer.createQuery(); queryBP.where = "query" queryBP.outFields = ["*"]; // do the query bldPermLayer .queryFeatures(queryBP) .then((response) => { featureTable.selectRows(response.features); featureTable.filterBySelection(); }); }

Re: How to query server-side FeatureTable?

ForrestLin — Thu, 15 Aug 2024 19:16:06 GMT

@MatthewDriscoll

Thank you so much for your help!

The total number of features in my FeatureLayer is about 500,000. I just need to get/query/search about 20 features each time, and then show them in the FeatureTable.

I don't want to create a new FeatureLayer and add to map each time I query. What should I do?

Forrest

Re: How to query server-side FeatureTable?

MatthewDriscoll — Thu, 15 Aug 2024 19:25:05 GMT

You don't need to create a new FeatureLayer each time, just query off the one every time. In fact you don't need to add the FeatureLayer to the map at all. You might need to loop through the response.features, but not sure that is necessary.

Re: How to query server-side FeatureTable?

ForrestLin — Thu, 15 Aug 2024 20:36:58 GMT

I'm not sure how to update FeatureTable using the response.features.

These are just for selection of FeatureTable , not updating FeatureTable :

featureTable.selectRows(response.features);
featureTable.filterBySelection();

Re: How to query server-side FeatureTable?

ForrestLin — Fri, 16 Aug 2024 19:53:46 GMT

I got a solution:

1. Create FeatureLayer:

let featureLayer= new FeatureLayer({

url,

objectIdField: "OBJECTID",

definitionExpression: "OBJECTID<0", // Make featureLayer no feature initially

popupTemplate,

renderer

});

2. Add featureLayer to map:

view.map.add(featureLayer );

3. Create FeatureTable with featureLayer:

const featureTable = new FeatureTable({

layer: featureLayer,

view,

container,

returnGeometryEnabled: true

}); // FeatureTable has no record initially

4. Query FeatureLayer using definitionExpression:

featureLayer.definitionExpression = query;

5. Update FeatureLayer using refresh, and FeatureTable got updated:

featureLayer.refresh();

Re: How to query server-side FeatureTable?

MatthewDriscoll — Fri, 16 Aug 2024 16:30:47 GMT

The question was how to do it without definitionExpression. So marking your solution as the correct one, by using definitionExpression, is a bit miss leading for those searching for the same thing in the future.

Re: How to query server-side FeatureTable?

ForrestLin — Fri, 16 Aug 2024 19:32:19 GMT

After FeatureTable with FeatureLayer is created,

call

queryFeatureLayer(query: string) {

featureLayer.definitionExpression = query;

featureLayer.refresh();

}

for each query/search.

Don't need to re-create FeatureLayer for each query/search.