topic Re: How to I get OpenQueryTable to work? in ArcGIS Pro SDK Questions

How to I get OpenQueryTable to work?

BradJones3 — Sun, 12 Dec 2021 06:29:55 GMT

Trying this as a Question instead of a Discussion.

I'm having trouble getting a QueryTable to display. The tool selects a single sewer line, gets the feature ID for the line (called COMPKEY), then uses the ID to build the where clause and hopefully open the query table.

What am I missing?

 protected override Task<bool> OnSketchCompleteAsync(Geometry geometry)
        {
            Uri path = new Uri("O:\\P\\A\\T\\H\\CONNECTION.sde");
            return QueuedTask.Run(() =>
            {
                ActiveMapView.SelectFeatures(geometry, SelectionCombinationMethod.New);

                string slComp = Module1.GetCompkey();
                if (!string.IsNullOrEmpty(slComp))
                {
                    // Set up Geodatabase Object)
                    using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(path)))
                    {
                        string queryString = $"COMPKEY = {slComp}";
                        QueryDef queryDef = new QueryDef()
                        {
                            Tables = "SDE.TABLE.NAME",
                            WhereClause = queryString,
                        };

                        QueryTableDescription queryTableDescription = new QueryTableDescription(queryDef)
                        {
                            MakeCopy = true,
                            Name = $"Preventive Maintenance: {slComp}.",
                            PrimaryKeys = geodatabase.GetSQLSyntax().QualifyColumnName("SDE.sewerman.tblV8PMTOOL", "COMPKEY")
                        };

                        var queryTable = geodatabase.OpenQueryTable(queryTableDescription);

                        int count = queryTable.GetCount();
                        if (count == 0)
                        {
                            MessageBox.Show("Sewer line selected has no preventive maintenance scheduled.");
                        }

                        else
                        {
                            // Used since query table doesn't display
                            // MessageBox.Show($"Row count: {count}");
                        }
                    }
                };‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to I get OpenQueryTable to work?

RichRuh — Fri, 25 Jan 2019 16:29:50 GMT

Brad,

Do you know where this code is failing? Have you stepped through with a debugger to see the value of count?

You state: "I'm having trouble getting a QueryTable to display." At the risk to taking your question too literally, you haven't included any code to display a QueryTable, just to create one. Is that the issue? (If so, do you want this to display as a table view or a layer on your map)

--Rich

Re: How to I get OpenQueryTable to work?

BradJones3 — Fri, 25 Jan 2019 17:03:21 GMT

Yes, that is the issue. I couldn't find any snippits/examples on how to do this.

Re: How to I get OpenQueryTable to work?

RichRuh — Sun, 12 Dec 2021 06:29:58 GMT

Brad-

I'm not an expert on using the ArcGIS Pro Content classes, but I think this code should do it:

// Create a standalone table from the queryTable Table
IStandaloneTableFactory tableFactory = StandaloneTableFactory.Instance;
StandaloneTable standaloneTable = tableFactory.CreateStandaloneTable(queryTable, MapView.Active.Map);

// Open the standalone table into a window
FrameworkApplication.Panes.OpenTablePane(standaloneTable, TableViewMode.eAllRecords);‍‍‍‍‍‍

--Rich

Re: How to I get OpenQueryTable to work?

BradJones3 — Mon, 28 Jan 2019 13:33:32 GMT

Thanks, for your help, Rich. But the following method must be called on the UI thread.

FrameworkApplication.Panes.OpenTablePane(standaloneTable, TableViewMode.eAllRecords);‍‍

OpenTablePane reference

Re: How to I get OpenQueryTable to work?

RichRuh — Mon, 28 Jan 2019 15:51:26 GMT

That's correct, Brad. You'll need to restructure your code so that the QueryTable is called on the MCT (main CIM thread) using QueuedTask, and you create the standalone table on the UI thread.

Re: How to I get OpenQueryTable to work?

BradJones3 — Tue, 29 Jan 2019 13:24:01 GMT

Unfortunately, because of my own inadequacies as a .Net developer, I can't figure out how to display—OpenTablePane— the standalone table from the UI thread. I'm missing something.

I think I'll try to do it in a DockPane. It's not ideal for this situation, but there seems to be plenty of code examples for this.

Thanks for your help, Rich.

Re: How to I get OpenQueryTable to work?

CharlesMacleod — Sun, 12 Dec 2021 06:30:01 GMT

Hi Brad, so here are some possibilities:

Option 1: Make the table and return the table from the QueuedTask and show it

internal class OpenTableButton : Button
    {
        protected async override void OnClick()
        {
            //capture the active map
            var theMap = MapView.Active.Map;

            //option 1 - return the table from the QueuedTask
            var table = await QueuedTask.Run(() =>
            {
                return StandaloneTableFactory.Instance.CreateStandaloneTable(
                    new Uri(@"Path_To_File_GDB.gdb\EarthquakeDamage_Table", 
                            UriKind.Absolute),
                    theMap);
            });
            FrameworkApplication.Panes.OpenTablePane(table);
        }
    }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Option 2: Make the table and show it from the QueuedTask (the syntax to do that is a bit gnarly I must confess)...still...it is here if you need it

internal class OpenTableButton : Button
    {
        protected async override void OnClick()
        {
            //capture the active map
            var theMap = MapView.Active.Map;

            //option 2 - invoke the OpenTablePane on the UI thread from
            //~within~ the QueuedTask
            await QueuedTask.Run(() =>
            {
                var table2 = StandaloneTableFactory.Instance.CreateStandaloneTable(
                    new Uri(@"Path_to_File_GDB.gdb\Meteorites_UK_Table",
                             UriKind.Absolute),
                    theMap);
                //now put us on the UI thread to open the table pane
                FrameworkApplication.Current.Dispatcher.BeginInvoke((Action)(() =>
                {
                    FrameworkApplication.Panes.OpenTablePane(table2);
                }));
            });

        }
    }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Option 3: Make the table on the QueuedTask. Return from the QueuedTask. Retrieve the table from the Map (on the UI) and show it. This would be akin to how you would retrieve a table from the TOC that had previously been added.

internal class OpenTableButton : Button
    {
        protected async override void OnClick()
        {
            //capture the active map
            var theMap = MapView.Active.Map;

            //Create the table from the QueuedTask
            await QueuedTask.Run(() =>
            {
                StandaloneTableFactory.Instance.CreateStandaloneTable(
                    new Uri(@"Path_To_File_GDB.gdb\EarthquakeDamage_Table", 
                    UriKind.Absolute),
                    theMap);
            });
            

            //option 3...get the table from the map after it has been added...
            var table3 = theMap.FindStandaloneTables("EarthquakeDamage_Table").First();
            FrameworkApplication.Panes.OpenTablePane(table3);
        }
    }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How to I get OpenQueryTable to work?

BradJones3 — Wed, 30 Jan 2019 12:49:28 GMT

Thanks for the snippets, Charles. But the problem I was having was trying to open the table without the user having to go to the ribbon click another button. I want them to click on a tool to activate, click on a feature, and the table opens with the subset of data.

Thanks for your help.

Re: How to I get OpenQueryTable to work?

BradJones3 — Sun, 12 Dec 2021 06:30:04 GMT

I just want to point out that this was the solution I was looking for.

I did not want the users to have to click a second bottom to open the table. I wanted it to run in OnSketchCompleteAsync method.

        protected override async Task<bool> OnSketchCompleteAsync(Geometry geometry)
        {
            
            var standaloneTable =  await QueuedTask.Run(() =>
            {

                ActiveMapView.SelectFeatures(geometry, SelectionCombinationMethod.New);

                slComp = Module1.GetCompkey();
                if (!string.IsNullOrEmpty(slComp))
                {
                    Uri path = new Uri("\\P\\A\\T\\H.sde");

                    // Set up Geodatabase Object)
                    using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(path)))
                    {
                        string queryString = $"COMPKEY = {slComp}";
                        QueryDef queryDef = new QueryDef()
                        {
                            Tables = "SDE.sewerman.tblV8PMTOOL",
                            WhereClause = queryString,
                        };

                        QueryTableDescription queryTableDescription = new QueryTableDescription(queryDef)
                        {
                            MakeCopy = true,
                            Name = $"Preventive Maintenance: {slComp}",
                            PrimaryKeys = geodatabase.GetSQLSyntax().QualifyColumnName("SDE.CONNECTION", "COMPKEY")
                        };

                        var queryTable = geodatabase.OpenQueryTable(queryTableDescription);

                        int count = queryTable.GetCount();
                        if (count == 0)
                        {
                            MessageBox.Show("Sewer line selected has no preventive maintenance scheduled.");
                            
                        }

                        else
                        {
                            // Create a standalone table from the queryTable Table
                            IStandaloneTableFactory tableFactory = StandaloneTableFactory.Instance;
                            StandaloneTable pmTable = tableFactory.CreateStandaloneTable(queryTable, MapView.Active.Map);

                            return pmTable;
                        }                     
                    }
                };
                //return base.OnSketchCompleteAsync(geometry);
                return null;
            });
            // Open the standalone table pane
            FrameworkApplication.Panes.OpenTablePane(standaloneTable, TableViewMode.eAllRecords);
            return true;
        }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍