Latest Contributions by TanuHoque

what kind of database? Oracle? SQL Server? you have any sample data you think you can share with me? if so, I will see if I can give you a workaround at least for GDB case... I might not be able to give any for agol feature services. ... View more

@LindsayRaabe_FPCWA  what is the underlying database? File GDB? SQL server? Oracle? Also, does the pivot table show aggregated results for the entire layer/dataset or only for selected features or features from the current extent? ... View more

... while this functionality is in production plan, some of ArcGIS Pro users might find this workaround useful. Contents pane's Filter command (from upper left corner of the pane) has two options: Selectable Unselectable  Selectable_Filter_TOC.gif   ... View more

Updates: The issue regarding 'showing selection count always' is fixed in ArcGIS Pro 3.1 release as part of our work mentioned here: https://community.esri.com/t5/arcgis-pro-ideas/table-of-contents-make-cursor-visible-even-if-text/idi-p/1143449 TanuHoque_0-1678908551853.png Clearing selection from the Selection tab is in production plan. Please see this idea: https://community.esri.com/t5/arcgis-pro-ideas/deselect-features-from-table-of-contents-selection/idi-p/921515 With that, I will update this idea only for the work to show selectable and unselectable layers in separate groups. ... View more

@Bud  Maybe this will work for you. Obviously I didn't find anything from UI, but you can do it programmatically from arcpy or .net SDK.   We have something called customProperties that you can use to add anything to a layer CIM definition. Here is a sample arcpy code to write these values. p = arcpy.mp.ArcGISProject("CURRENT") m = p.listMaps()[0] l = m.listLayers("Tornadoes")[0] # layer's CIM definition cimLyr = l.getDefinition('V3') # creating a CIMStringMap to store a key/value pair vp1 = arcpy.cim.CreateCIMObjectFromClassName("CIMStringMap", "v3") vp1.key = "DESCRIPTION" vp1.value = "Check for out-of-date construction projects (STATUS=FORECAST, but DATE is in the past)." vp2 = arcpy.cim.CreateCIMObjectFromClassName("CIMStringMap", "v3") vp2.key = "MESSAGE" vp2.value = "There are rows in the "Check for out-of-date construction projects" query. Please investigate." cimLyr.customProperties = [vp1, vp2] # updating layer's CIM definition l.setDefinition(cimLyr)   Here is the same thing but using .NET API var cimBLyr = lyr.GetDefinition(); cimBLyr.CustomProperties = new CIMStringMap[] { new CIMStringMap() {Key = "DESCRIPTION", Value = "Check for out-of-date construction projects (STATUS=FORECAST, but DATE is in the past)."}, new CIMStringMap() {Key = "MESSAGE", Value = "There are rows in the "Check for out-of-date construction projects" query. Please investigate."} }; lyr.SetDefinition(cimBLyr);   ... View more

Thanks a lot @Bud  Appreciate all your help very much. I'm glad that SQLite has some support for this. I hope they will grow that support and other databases will follow the suite.   ... View more

hi @Bud    I assume you must have checked Metadata and you found that is not going to help you. I'm just throwing it out there; I'm no expert in metadata. Another thing that I want to mention is a dataset type called Catalog Dataset that is new in ArcGIS Pro 3.1. Just in case you are not aware of this, as the name suggested it is about cataloging your datasets by ref. You can add additional field/attribute for each reference in that dataset. See help on Catalog Layer here: - https://pro.arcgis.com/en/pro-app/latest/get-started/whats-new-in-arcgis-pro.htm - https://pro.arcgis.com/en/pro-app/3.1/help/mapping/layer-properties/catalog-layers.htm I'm again throwing it out there just in case you find it helpful.     ... View more

Thanks for sharing this @Bud. This so cool. 🥇 Do you happen to know if this only specific to Oracle? Do other databases support this or something similar? ... View more

@MohammedElsayed  Just curious, why do you want to enable 'feature layer' while publishing data, I assumed, off a file gdb? Is your goal to allow editing from web applications? Or just drawing on the client app using some web clients' advanced symbology option? or something else? thanks ... View more

@David_Brooks  are you publishing the feature service on your on-premises enterprise server/portal (by ref)? or as a host feature service in agol? if it is enterprise server, did you try publishing as a map service w/o enabling feature service? did that work? ... View more

here is the link to ArcGIS Pro help about def queries and having multiple queries with one or none being the active one. https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/definition-query.htm ... View more

thanks @sgambrel_Bouldercounty  Based on that I'm closing this idea as "already offered" ... View more

ArcGIS Pro supports that already. All you need to do is click on the check box to de-activate your def query. TanuHoque_0-1677100604346.png or, you can do it from the ribbon UI too TanuHoque_1-1677100653767.png     ... View more