How to query server-side FeatureTable?

[ForrestLin]

Is it possible to query server-side FeatureTable without re-creating 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 
        });
}

[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]

@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

[MatthewDriscoll]

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.   

[ForrestLin]

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

[ForrestLin · Accepted solution]

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