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?

タグ付けされた投稿をもっと見る

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

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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