topic Re: WebAppBuilder - Query Oracle Database in ArcGIS Server with JavaScript API Questions

WebAppBuilder - Query Oracle Database

KafilBaig — Sun, 24 Mar 2019 11:47:06 GMT

Hey, I am very new to WebApp Builder. I have a requirement where i need to query from Oracle Database and show the result in widget. Is this posibble to do .

In the tabular data i need to have a button on that click it should zoom that point .

Thanks in Advance.

Re: WebAppBuilder - Query Oracle Database

RobertScheitlin__GISP — Mon, 25 Mar 2019 03:01:05 GMT

Kafil,

The JS API does not have the ability to query a database on a server without the use of a web service so the short answer is no it is not possible without a web service that allows for this.

Re: WebAppBuilder - Query Oracle Database

KafilBaig — Mon, 25 Mar 2019 05:12:00 GMT

Thanks for the feedback

If i create a Webservice project to fetch data from Oracle Database. How how i need to access a webservice in the widget where i have search parameters and table to show the data

Re: WebAppBuilder - Query Oracle Database

RobertScheitlin__GISP — Mon, 25 Mar 2019 12:45:03 GMT

Kafil,

Once you have a web service you access the web service using esriRequest to make a REST service call.

Re: WebAppBuilder - Query Oracle Database

KafilBaig — Mon, 25 Mar 2019 13:24:06 GMT

Thanks Robert ,

Do u have a sample code for this. If yes please share the sample code.

Thanks in advance for ur help

Sent from my iPhone

Re: WebAppBuilder - Query Oracle Database

KafilBaig — Mon, 14 Oct 2019 06:46:12 GMT

Hi Robert,

I have created a webservice and trying to access in zoomgrid widget with no success. Can you please check the code and help me out where there is a mistake .

Please find attached zoomgrid widget altered by me.

Re: WebAppBuilder - Query Oracle Database

RobertScheitlin__GISP — Tue, 15 Oct 2019 13:00:13 GMT

Kafil,

I am not sure how you are expecting this to work at all. Where in your code are you calling the "fnGetxy"?

Re: WebAppBuilder - Query Oracle Database

KafilBaig — Wed, 16 Oct 2019 07:19:53 GMT

On the button click am calling the function"fnGetxy" . I am getting the error in console as typeError "a.haschildnode".

Please find attached complete widget for your reference.

Also i tried the same code in html page with EsriRequest and WebApi there i get results but not in widget. In this am using 4.12 javascript api but in widget it is 3.27

The below code works fine for me .

<!DOCTYPE html>

<html>

<head>

<style>

td {

padding: 4px;

}

#loading {

visibility: hidden;

}

</style>

require([

"esri/request",

"esri/config",

"dojo/json",

"dojo/dom",

"dojo/on",

"dojo/domReady!"

], function(esriRequest, esriConfig, JSON, dom, on) {

esriConfig.request.proxyUrl = "https://gislap183/js/proxy/proxy.ashx";

function doRequest(){

var url = "https://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Demographics/ESRI_Census_USA/MapServer/layers?f=json";

esriRequest(url, {

responseType: "json",

callbackParamName: "callback"

}).then(function(response){

showResults(response);

});

}

var resultsTable = dom.byId("tbl");

// Executes when the promise from find.execute() resolves

function showResults(response) {

var results = response.data;

// Clear the cells and rows of the table to make room for new results

resultsTable.innerHTML = JSON.stringify(results);

}

// Executes each time the promise from find.execute() is rejected.

function rejectedPromise(err) {

console.error("Promise didn't resolve: ", err.message);

}

// Run doRequest() when button is clicked

on(dom.byId("execBtn"), "click", doRequest);

});

</script>

</head>

<body>

<br>

</body>

</html>

Thanks in advance for your help

Re: WebAppBuilder - Query Oracle Database

RobertScheitlin__GISP — Wed, 16 Oct 2019 13:39:23 GMT

Kafil,

You say

I am getting the error in console as typeError "a.haschildnode".

Where are you getting this error? Are you getting into the succeed function or the error function?

Re: WebAppBuilder - Query Oracle Database

KafilBaig — Thu, 17 Oct 2019 09:46:52 GMT

Hi Robert,

Sorry to bother you again and again.

Now that error is not coming as a.hasChildNode. But getting other error as esriRequest.Then is not a function.

I tried many options with no luck but couldn't resolve the error of esriRequest.then is not a function.

Please help me to get this issue resolved.

I am using webappbuilder developer edition 2.11 for which arcgis javascript api is 3.27.

Please find attached error snapshot and widget.js file.

Thanks in advance for your help.

Regards,

Kafil

Re: WebAppBuilder - Query Oracle Database

RobertScheitlin__GISP — Sun, 12 Dec 2021 08:54:22 GMT

Kafil,

Your require array is out of order.

define([
        'dojo/_base/declare',
        'jimu/BaseWidget',
        'dijit/_WidgetsInTemplateMixin',
        'dgrid/OnDemandGrid',
        'dgrid/Selection',
        'dojo/store/Memory',
        'esri/layers/FeatureLayer',
        'esri/symbols/SimpleFillSymbol',
        'esri/tasks/query',
        'esri/Color',
        'dojo/_base/array',
		'dojo/_base/lang',
        'dijit/form/Button',
		'dojo/json',
		'dojo/Deferred',
		"esri/request",
		"esri/lang"
		
    ],
    function(declare, BaseWidget, _WidgetsInTemplateMixin,
        Grid, Selection, Memory, FeatureLayer, SimpleFillSymbol,
        Query, Color, array, lang, esriRequest, JSON, Deferred, esriLang) {‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

esriRequest is a 'dijit/form/Button' based on your require order...

Re: WebAppBuilder - Query Oracle Database

KafilBaig — Sun, 20 Oct 2019 10:03:03 GMT

Thanks for the help Robert. You Rock.

I have created a new widget and am successful in getting the data. I am trying to add this data to dgrid but no luck in displaying the grid in widget.

Please help me where am going wrong in binding the grid.

Please find attached widget for your reference.

Thanks in advance.

Re: WebAppBuilder - Query Oracle Database

RobertScheitlin__GISP — Mon, 21 Oct 2019 12:41:57 GMT

Kafil,

So what is the error you are getting now?