Latest Contributions by glennhazelton

hi Robert, as far as ideas for future enhancements. i have one that has to do with the attribute table. i realize you are using what ESRI provides but it would be really handy to be able to export a .csv file that reflects the columns that have been turned off. i also notice that the column names are the actual names and not the aliases that i have assigned. maybe this should go into the "ESRI ideas" site instead of here. ... View more

thanks answer to questions iOS iPad latest collector version the feature service is hosted on my arcserver install behind the firewall i am running 10.3.2. it is a 1:many ... View more

hi Russel, I have found some odd behavior using Collector with related tables. what is happening is that if I create a new feature and submit it and then select this new point location and attempt to add a NEW record in the related table I get a message in red at the top of the info panel  saying "no valid location' and a spinning wheel. what should happen is that the attribute table should open so I can add values to the fields. I also note that the related field (in this case the ID of the feature, not the Globalid) is blank. this behavior seems to be happening consistently when more that one person is accessing the webmap via Collector. are you aware of this issue? I suspect it has something to do with the creation of the new location as I have not seen this issue if I simply select an existing location pt and the add a new related table record. Glenn ... View more

i just get the spinning wheel and then nothing in the task manager i see the process has started but nothing opens. ... View more

hi Robert, I may have just discovered something that should go in the documentation i think. i have a pt layer that i have joined to an Oracle Materialized view in my ArcMap mxd. i can see all the attributes just fine but i cannot build a esearch or esri query against the fields in the joined table. i can create the query just fine but when i go to run it no values are returned and i get that 'search failed!' message in the big white box. i have switched to an esri 'database view',  that does the same join in the arcmap mxd and it works fine. not sure why arcmap join doesnt work when i can build the query. i have the materialized view in the arcmap toc. ... View more

all is well i didnt realize i needed to update the code in the app. i thought the duplicate option would do this. so many little things. thanks again for all your fixed and quick help. ... View more

Robert, I am not seeing the promote/demote options for the expressions and the max number of records is still stopping at the esri set limit of 1000. i am guessing your changes have not moved to my app. what i did: i replaced the esearch folder in the client\widgets folder then i duplicated my app opened it for editing and made one change to a esearch query. then i saved. and reopened the app. is there a way to check what version of your esearch is running in my app? ... View more

thanks you are so quick .. i though maybe i could give you a hint you hadn't found yet. ... View more

Robert, i have some clues for you regarding the record count limit. i found this by googling-- http://support.esri.com/fr/knowledgebase/techarticles/detail/44060 i am using Portal not AGOL but the help is still relevant as it is really about the mapservices. what i did was log into the arcserver services as admin and then i found the 'maxrecordcount' item. i changed the number , saved and then tried your esearch again. this time i see all possible ID. what i don't understand is that if i use the esri query tool i do NOT need to alter this value. just a guess, but i wonder if it is doing some sort of 'frequency' against the dataset, thus i see all the possible IDs, then when i pick one the recordset limit goes into effect. Are you using a different method than esri to populate the dropdown? also can you remind me again how to get to the 'advanced edit' option in geonet , i want to get back to being able to add attachments. ... View more

robert the list of records is stopping at the 1000th record. do you have a parameter somewhere in the config that controls this? what is bothering me mostly is that i can't enter the id for any record after the 1000th ... View more

ARCSERVER 10.3.1 no i don't have a definition query set. odd thing is the same  mapservice works in the esri query tool. i'm still experimenting myself trying to see why it is cutting off. ... View more

another bit of odd behavior... i have rather large datalayer (7000 records) in the esri query widget i can set it to 'unique' and type in the beginning of the text string that is the id for a record. the list gets narrowed down as i continue to add characters. when i use your widget the list of available values seems to be truncated. and if i type in the beginning of a unique id that is not on the visible dropdown list the entry box gets a red boarder. and if i type in the entire string and execute the search i get a 'no records found' message. i am not sure if this field is indexed.. i will check but it seems odd it would work with the esri search and not yours... ideas?? thoughts?? ... View more

i hate it when i am blind thanks ... View more

i have lost the 'advanced edit' option in the upper right of the reply so i am inserting the json here. this is just a section of it of course. if you look at about line 27 you will see the date range that works with the addition of 'timestamp' and then about line 76 the one that fails when combined with a search for a specific town. {       "name": "WWQ All Samples",       "url": "https://chldev20.mwra.net/arcgis/rest/services/assets/waternew/MapServer/25",       "definitionexpression": "",       "spatialsearchlayer": true,       "zoomScale": 10000,       "shareResult": true,       "addToAttrib": false,       "expressions": {         "expression": [           {             "alias": "Date Range",             "textsearchlabel": "Date Range",             "values": {               "value": [                 {                   "fieldObj": {                     "name": "DATE_COLLECTED",                     "label": "DATE_COLLECTED",                     "shortType": "date",                     "type": "esriFieldTypeDate"                   },                   "valueObj": {                     "value1": "[value]",                     "value2": "[value]"                   },                   "prompt": "DATE_COLLECTED is between",                   "textsearchhint": "Date Range",                   "sqltext": "DATE_COLLECTED BETWEEN timestamp '[value1]' AND timestamp '[value2]'",                   "operation": "dateOperatorIsBetween"                 }               ]             }           },           {             "alias": "SampleID",             "textsearchlabel": "Sample ID",             "values": {               "value": [                 {                   "fieldObj": {                     "name": "GIS_SAMPLE_ID",                     "label": "GIS_SAMPLE_ID",                     "shortType": "string",                     "type": "esriFieldTypeString"                   },                   "valueObj": {                     "value": "AR-06"                   },                   "prompt": "GIS_SAMPLE_ID is",                   "textsearchhint": "Pick ID",                   "sqltext": "GIS_SAMPLE_ID = '[value]'",                   "operation": "stringOperatorIs",                   "uniquevalsfromfield": "GIS_SAMPLE_ID"                 }               ]             }           },           {             "alias": "Date range and Town",             "textsearchlabel": "Date and Town",             "values": {               "value": [                 {                   "fieldObj": {                     "name": "DATE_COLLECTED",                     "label": "DATE_COLLECTED",                     "shortType": "date",                     "type": "esriFieldTypeDate"                   },                   "valueObj": {                     "value1": "[value]",                     "value2": "[value]"                   },                   "prompt": "DATE_COLLECTED is between",                   "textsearchhint": "Pick Two Dates",                   "sqltext": "DATE_COLLECTED BETWEEN timestamp '[value1]' AND timestamp '[value2]'",                   "operation": "dateOperatorIsBetween"                 },                 {                   "fieldObj": {                     "name": "TOWNNAME",                     "label": "TOWNNAME",                     "shortType": "string",                     "type": "esriFieldTypeString"                   },                   "valueObj": {                     "value": "ARLINGTON"                   },                   "prompt": "TOWNNAME is",                   "textsearchhint": "Pick a Town",                   "sqltext": "TOWNNAME = '[value]'",                   "operation": "stringOperatorIs",                   "uniquevalsfromfield": "TOWNNAME",                   "operator": ""                 }               ]             }           }         ]       }, ... View more

FYI i just tried the timestamp fix in combination with another query (so select a town and a date range) and i get the 'Search Failed!' message. same query works in the esri widget. maybe i need to add the timestamp to something else? ... View more