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; } } }

How to query server-side FeatureTable?

ForrestLin

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

Find more posts tagged with

Accepted answers

ForrestLin

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();

All comments

MatthewDriscoll

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

const bldPermLayer = new FeatureLayer({
    url: "https://.../server/rest/services/...",
    outFields:["*"]
});

const featureTable = new FeatureTable({
    view: theView,
    layer: bldPermLayer,
    
});

function handleQueryResults() {

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

ForrestLin

@MatthewDriscoll

Thank you for your help!

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

MatthewDriscoll

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

ForrestLin

@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

MatthewDriscoll

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(); 
        });
}

ForrestLin

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();

MatthewDriscoll

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.

ForrestLin

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.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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