Latest Contributions by TanuHoque

please see the last comment from Bud ... View more

thanks @Bud for clarification. ... View more

@Bud  It should work unless I misunderstood what you asked for 😞 If I have a FC and a table in my database and I want to join them, I'd do this: add the FC in a map as a feature layer (optionally) add the table to the map select the feature layer use the Join option from the ribbon tab (i believe inside the Data group tab) to bring up Add Join gp tool select the standalone table (or browse to the db to pick the table) set primary and foreign keys click OK It creates the join between the layer and standalone table --> basically brings all attributes from the table to the feature layer. please let me know if I misunderstood. ... View more

@StefanieWenker  pls let me know how it goes. In general, any sql including database specific functions etc., that can be used inside a subquery can be used to define a query layer. All this layer does is it pushes the entire sql query that you provided, to the underlying database by wrapping that in side a subquery... e.g. if you used a query like this: select job_title, sum(income) as total_income from employees group by job_title it will be pushed to the database like this select * from (select job_title, sum(income) as total_income from employees group by job_title) a ... View more

@RoyJackson_AlertMedia  Sorry for the delay. I just tried with a dataset that has about 65 million records. My query that used to define the query layer is a simple one i.e. "Select * from aTable". And it works fine for me. Map service gets started without any delay or anything. I have a question though: did you create the query layer in ArcGIS Pro? Or you created in ArcMap and imported that in Pro?   Can you pls do this for me? save your query layer as a Layer File (.lyrx) open that in a text editor check if the following properties are written in there and they are not empty TanuHoque_0-1684801945806.png   if they all look good and you are still running into the performance issue, I'd need you to reach out to Esri Support to help us reproduce this in house. While we will investigating that, I think I might be able to give your a hack-y workaround 😄 since you mentioned about adding the following where-clause give you a trick to work around the initial startup... and of course you can use that as you run into this issue every time map service recycles. where customer_id = 123   ... of course whether the workaround will be acceptable in your situation will be a different question by itself. 🙂 ... View more

@LarsSøe  hmm... that looks like a bug. I checked from my side and it worked for me. That said, we need to look into your case. It appears there must be something went unnoticed. Would you mind share some data, export map requests etc. to help use reproduce this in house? Thanks ... View more

thanks @StefanieWenker for the details. I can't say much about pivot/transpose and its performance issue as I don't think I have worked with that. As per the other ones, I think we should be able to do that using Query Layers. Please let me know if you tried before but not worked for you https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm ... View more

@StefanieWenker  I might have misunderstood your workflow. Are you saying that this? you actually have your data stored in enterprise databases. they are simply linked from your excel worksheets via some complex sql queries? and you want to have similar capabilities in ArcGIS Pro so that you wouldn't need to make duplicate copy of your data in your enterprise database. please let me know if I got it completely wrong. Thank   ... View more

@AdamMinke  What did you choose in the "Select a Configuration" drop down box? If you choose one of the options from "Reference registered data" category, then it should create a map service and your web map should use a map image layer (instead of feature layer). Then it should work as the drawing happens on the server side, and you should see feature labeled exactly as they do in Pro. If you choose some other options and the webmap contains a 'feature layer' not a 'map image layer', then features get labelled on the client side and it might not match with what we see in Pro. ... View more

thanks @Joshua-Young for reaching out and providing clarification ... View more

@KevinMcCartney1    Try the Sort() function to see if that helps. https://developers.arcgis.com/arcade/function-reference/array_functions/#sort   That said, since you have an enterprise server, and your python script works in ArcGIS Pro labeling; you should be able to publish that as a map service (aka map image layer) and consume that as a map image layer in the Map Viewer. Since the drawing will happen on the server side, your python code will just work and give you map showing features labelled with the earliest date/time values. ... View more

Hi @Joshua-Young  Looks like you are hitting a similar bug that others have reported (pls see the link below). Only difference is that you are saying it is crashing for you. Would you mind reach out to Esri Support as soon as possible, and provide your exact steps to help us reproduce this? We'd appreciate that very much. https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-enterprise-11-1-is-not-printing-features/m-p/1287267#M35877   ... View more