Trying to query a datasource is a custom widget, never returns any results

PaulNRWA

I'm attempting to create a custom widget and struggling to query data from a feature layer.  When I step thru the debugger, everything works, but no data rows are ever returned.   The debugger shows the DataSource does indeed exist and everything looks fine, I simply cannot get any data to return.   Here is a stripped down version of the code:

let qryParamsNow = [] as SqlQueryParams;

qryParamsNow.where = '1=1'

qryParamsNow.outFields = ['*']

let dataPortalUser = DataSourceManager.getInstance().getDataSourcesAsArray()[0] as QueriableDataSource

         

dataPortalUser.query(qryParamsNow)

.then((response) =>

{

   const record = response.records[0];

   console.log(record.getFieldValue('email'));

})

.finally()

{

  // Any records?

  const dtrResults = dataPortalUser.getRecords()

  console.log(dtrResults[0].getFieldValue('email'));

}

 

As I step thru the debugger, I keep an eye on the network and that layer is never accessed.   When it reaches the '.finally' the message shows unloaded.   Prior to that the response message is 'pending'.

 

Thanks in advance.

Grant-S-Carroll

Hi There,

Not sure about casting to QueriableDataSource (I've not used it in my workflows), I cast to a FeatureLayerDataSource and then query from there. The other recommendation I would make is to always include a catch in your promises, as it will allow you to see any errors generated from the server, otherwise they can fail silently. See code snippet below

let dsm = DataSourceManager.getInstance();
        // use the settings to get the datasource by id.
        let ds = dsm.getDataSource(this.props.useDataSources[1].dataSourceId) as FeatureLayerDataSource;  
        //I'm not creating a seperate object for query parameters, just passing them in like so
        ds.query({ where: '1 = 1', returnGeometry: false, pageSize: 2 })
            .then((response) =>
            {
                //Log the respone
                console.log(response)
            })
            .catch((error) => {
                //Catch any issues and log to the console
                console.error(error)
            })
            .finally(() => {
                console.log('Operation completed')
            })

 

Hopefully this helps.

Cheers