Latest Contributions by JeremyWolff

‎02-06-2023

@igemetristechnologies @RobertScheitlin__GISP Hi, Thank you for the tip. Could you guide me briefly on this? I think I am not the only one who has asked if this was possible and I believe that would help many of us. As far as using publishing a second geoprocessing service is concerned, there is some documentation that exist (even if it's quite old and only documentation for using ArcMap) But for the widget adaptation part of it it would be great if you could provide some guidance as to where to even start. Kind regards, Jeremy

‎01-16-2023

Hi Robert, Thank you for your support and contributions! This widget is great and works really well on my hand! I wanted to know if it was possible to sample from two different elevation layers instead of one and have that represented in the graph? Is it just a matter of changing the geoprocessing service or would that also require to edit the app as well?

‎01-16-2023

Hi Robert, Thank you for your support and contributions! This widget is great and works really well on my hand! I wanted to know if it was possible to sample from two different elevation layers instead of one and have that represented in the graph? Is it just a matter of changing the geoprocessing service or would that also require to edit the app as well?

‎02-19-2020

Hi Robert, The issue is not with the esearch widget but with the basic query widget. There is probably a file somewhere which controls which feature actions (statistics, zoom to..) are available in the result window? Do you have any idea where I might look? Regards, Jeremy

‎02-18-2020

Hi Robert, With a new clean app there is no issue. However, with my app which has you esearch custom widget I do encounter this issue with the query tool (not with your widget). I am not sure where to look. There is probably a file somewhere which controls which feature actions (statistics, zoom to..) are available in the result window? Do you have any idea where I might look? Cheers, Jeremy

‎02-13-2020

Hi, Have you found a way to disable a feature action like Statistics? Cheers, Jeremy

‎02-13-2020

Hi Robert, Is there a way to have fewer feature actions in the query result window? eg. removing statistics or zoom to? The reason for that is that they appear twice in my app.. Regards, Jeremy #webappbuilder #esri

‎02-12-2020

Hi Offie, Have you found a solution for that so far? I am also trying to remove a few feature actions in the query result, come of which appear twice (see in the photo attached). I look in the same files as you (FeatureActionManager.js and BaseFeatureAction.js file) but no luck. Let me know what you have found. Cheers, Jeremy PS: The enhaced search widget from Robert Scheitlin, GISP‌ does not have this issue: #querywidget‌ #customwidget‌

‎02-04-2020

So did this bug get fixed since it appeared back in 2018?

‎01-15-2020

Hi Robert, This fix did not work for me. I added this rule to the Screening\css\style.css but it is still displaying hectares: There is two other things that perhaps you could help me with. Would it be possible to either disable the printing report option in the screening tool, or to limit the size of the features that could be selected and analysed in the report? The other thing that would be very useful is to make a layer as default in the selectable layers list of the Screening tool. I am also curious but would be really surprised if there were anyway to link the selectable layers in the screening tool to the layers in the layers list of the map. Right now when a layer is selected in the screening tool it does not display on the map until it is also selected in the layers list. Thanks for your help! Jeremy

‎01-07-2020

Hi. The database is Oracle (PL/SQL). Do you know if this works [^0-9] ?

‎01-07-2020

Hi. The database is Oracle (PL/SQL). Do you know if this works [^0-9] ?

‎01-07-2020

Hi Doug, I was wondering if you could help me with my query because it seems similar to what you were trying so hopefully you will be able to see what I am missing: Data looks like this: 1.1.1 11.1.2 8.12.37 1.1.1ax1 (ax1 is an extension) 11.1.2b7 (b7 is an extension as well) There are more than a hundred thousand of these so it s a large data set. It always follow the same structure number . number . number and sometime and extension 1.1.1 1.1.1a 1.1.1b The goal is for the user to be able to query that number without knowing the extension. So that the user will only need to query 1.1.1 to get results like 1.1.1 and 1.1.1a and 1.1.1b. The problem with a simple CONTAINS %% is that it will also return 11.1.1 and 1.1.11 I have tried these SQL lines but I always get a "Fail to execute query" or "no results": Upper(RE1) LIKE Upper('[11.12.1]'+'[^0-9]%') Failed to execute query. Upper(RE1) LIKE Upper('[11.12.1]''[^0-9]%') No records found. Upper(RE1) LIKE Upper('11.12.1' + '[^0-9]%') Failed to execute query. Upper(RE1) LIKE Upper('11.12.2''^0-9%') No records found. Upper(RE1) LIKE Upper('11.12.2')+('^0-9%') Failed to execute query. Upper(RE1) LIKE Upper(CONCAT('11.12.2', '[^0-9]%')) No records found. Upper(RE1) LIKE Upper(CONCAT('11.12.2', '')) returns all 11.12.2 but does not return 11.12.2b Upper(RE1) LIKE Upper('11.12.1' + '[0-9]') Failed to execute query. REGEXP_LIKE (UPPER(RE1), UPPER(CONCAT('11.12.2','^[0-9]%'))) Unable to complete operation. Syntax error? Upper(RE1) LIKE Upper(CONCAT('11.12.2', '%') Unable to complete operation. Syntax error? I have spent such a long time trying to get this, if you could help me that would be great! Perhaps Substring would work for me but I am not sure! Thank you! Jeremy Joshua Bixby‌

‎01-07-2020

Hi Doug, I was wondering if you could help me with my query because it seems similar to what you were trying so hopefully you will be able to see what I am missing: Data looks like this: 1.1.1 11.1.2 8.12.37 1.1.1ax1 (ax1 is an extension) 11.1.2b7 (b7 is an extension as well) There are more than a hundred thousand of these so it s a large data set. It always follow the same structure number . number . number and sometime and extension 1.1.1 1.1.1a 1.1.1b The goal is for the user to be able to query that number without knowing the extension. So that the user will only need to query 1.1.1 to get results like 1.1.1 and 1.1.1a and 1.1.1b. The problem with a simple CONTAINS %% is that it will also return 11.1.1 and 1.1.11 I have tried these SQL lines but I always get a "Fail to execute query" or "no results": Upper(RE1) LIKE Upper('[11.12.1]'+'[^0-9]%') Failed to execute query. Upper(RE1) LIKE Upper('[11.12.1]''[^0-9]%') No records found. Upper(RE1) LIKE Upper('11.12.1' + '[^0-9]%') Failed to execute query. Upper(RE1) LIKE Upper('11.12.2''^0-9%') No records found. Upper(RE1) LIKE Upper('11.12.2')+('^0-9%') Failed to execute query. Upper(RE1) LIKE Upper(CONCAT('11.12.2', '[^0-9]%')) No records found. Upper(RE1) LIKE Upper(CONCAT('11.12.2', '')) returns all 11.12.2 but does not return 11.12.2b Upper(RE1) LIKE Upper('11.12.1' + '[0-9]') Failed to execute query. REGEXP_LIKE (UPPER(RE1), UPPER(CONCAT('11.12.2','^[0-9]%'))) Unable to complete operation. Syntax error? Upper(RE1) LIKE Upper(CONCAT('11.12.2', '%') Unable to complete operation. Syntax error? I have spent such a long time trying to get this, if you could help me that would be great! Perhaps Substring would work for me but I am not sure! Thank you! Jeremy Joshua Bixby‌

‎01-06-2020

Hi, I am having difficulties with my query and I am not sure if it is due to a syntax error. Upper(RE1) LIKE Upper('11.12.1' + '[^0-9]%') The requested URL was rejected. Please consult with your administrator. Your support ID is: 5772500289949997508 Upper(RE1) LIKE Upper('11.12.2' + [^0-9]%) Unable to complete operation. Upper(RE1) LIKE Upper('11.12.2')+('^0-9'%) Failed to execute query. The data that I am querying looks like this: 10.3.14hx4 10.3.14 10.3.1 10.3.11 10.3.15ax1 10.3.1a 10.3.15c 10.3.15d 10.3.15dx1 10.3.15e 10.3.15ex1 The goal is that when the user queries 10.3.1 it returns 10.3.1 and the extentions 10.3.1a, 10.3.1b, 10.3.1b2 BUT DO NOT return 10.3.15. Please Help. All I get for now is: The requested URL was rejected. Please consult with your administrator. Your support ID is: 5772500289950014772 and this URL https://uat-gisservices.information.qld.gov.au/arcgis/rest/services/EncompassApps/WildNet/MapServer/22/query?where=Upper%28RE1%29+LIKE+Upper%28%2711.12.2%27+%2B+%27%5B%5E0-9%5D%25%27%29&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=RE%2CRE1%2CRE2%2CRE3%2CRE4%2CRE5%2CPERCENT%2CLANDZONE%2CBD_STATUS%2CBVG1M%2CBVG1M_PC%2COBJECTID&returnGeometry=true&returnTrueCurves=false&maxAllowableOffset=&geometryPrecision=&outSR=102100&having=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&historicMoment=&returnDistinctValues=false&resultOffset=&resultRecordCount=&queryByDistance=&returnExtentOnly=false&datumTransformation=&parameterValues=&rangeValues=&quantizationParameters=&featureEncoding=esriDefault&f=html or no errors but no records found with queries like this: Upper(RE1) LIKE Upper(CONCAT('11.12.2', '[^0-9]%')) Thank you for your help. Jeremy #sql #arcgisrest‌

Online Status	Offline
Date Last Visited	‎02-09-2023 03:39 AM

My Ideas

Latest Contributions by JeremyWolff

Re: Elevation Profile Widget Version 2.24 - 8/3/2022

Re: Elevation Profile Widget Version 2.24 - 8/3/2022

Re: Enhanced Search Widget Version 2.23.1 - 11/22/22

Re: Export SHP or KML Feature Action from Web AppBuilder Query

Re: Export SHP or KML Feature Action from Web AppBuilder Query

Re: Feature Actions released at 2.1 issue

Re: Export SHP or KML Feature Action from Web AppBuilder Query

Re: WebApp Builder 2.3 - Restrict feature action options

Re: Can't export Query result to CSV in the AttributeTable widget

Re: Screening Widget

Re: Expanded Pattern Matching in File Geodatabases (and documentation would be nice)

Re: Expanded Pattern Matching in File Geodatabases (and documentation would be nice)

Re: Expanded Pattern Matching in File Geodatabases (and documentation would be nice)

Re: Expanded Pattern Matching in File Geodatabases (and documentation would be nice)

ArcGIS REST Services Directory

Re: Can't export Query result to CSV in the Attrib...