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?

Finde mehr Beiträge mit dem Tag

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

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.

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

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

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

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

ForrestLin

@MatthewDriscoll

Thank you for your help!

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

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

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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