How to I get OpenQueryTable to work?

BradJones3

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?

 <SPAN class="keyword token">protected</SPAN> <SPAN class="keyword token">override</SPAN> Task<SPAN class="operator token"><</SPAN><SPAN class="keyword token">bool</SPAN><SPAN class="operator token">></SPAN> <SPAN class="token function">OnSketchCompleteAsync</SPAN><SPAN class="punctuation token">(</SPAN>Geometry geometry<SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            Uri path <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Uri</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"O:\\P\\A\\T\\H\\CONNECTION.sde"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
            <SPAN class="keyword token">return</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
            <SPAN class="punctuation token">{</SPAN>
                ActiveMapView<SPAN class="punctuation token">.</SPAN><SPAN class="token function">SelectFeatures</SPAN><SPAN class="punctuation token">(</SPAN>geometry<SPAN class="punctuation token">,</SPAN> SelectionCombinationMethod<SPAN class="punctuation token">.</SPAN>New<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                <SPAN class="keyword token">string</SPAN> slComp <SPAN class="operator token">=</SPAN> Module1<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetCompkey</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="operator token">!</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">IsNullOrEmpty</SPAN><SPAN class="punctuation token">(</SPAN>slComp<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                <SPAN class="punctuation token">{</SPAN>
                    <SPAN class="comment token">// Set up Geodatabase Object)</SPAN>
                    <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Geodatabase geodatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Geodatabase</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">DatabaseConnectionFile</SPAN><SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        <SPAN class="keyword token">string</SPAN> queryString <SPAN class="operator token">=</SPAN> $<SPAN class="string token">"COMPKEY = {slComp}"</SPAN><SPAN class="punctuation token">;</SPAN>
                        QueryDef queryDef <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">QueryDef</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            Tables <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SDE.TABLE.NAME"</SPAN><SPAN class="punctuation token">,</SPAN>
                            WhereClause <SPAN class="operator token">=</SPAN> queryString<SPAN class="punctuation token">,</SPAN>
                        <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

                        QueryTableDescription queryTableDescription <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">QueryTableDescription</SPAN><SPAN class="punctuation token">(</SPAN>queryDef<SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            MakeCopy <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">true</SPAN><SPAN class="punctuation token">,</SPAN>
                            Name <SPAN class="operator token">=</SPAN> $<SPAN class="string token">"Preventive Maintenance: {slComp}."</SPAN><SPAN class="punctuation token">,</SPAN>
                            PrimaryKeys <SPAN class="operator token">=</SPAN> geodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetSQLSyntax</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">QualifyColumnName</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SDE.sewerman.tblV8PMTOOL"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"COMPKEY"</SPAN><SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">var</SPAN> queryTable <SPAN class="operator token">=</SPAN> geodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">OpenQueryTable</SPAN><SPAN class="punctuation token">(</SPAN>queryTableDescription<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

                        <SPAN class="keyword token">int</SPAN> count <SPAN class="operator token">=</SPAN> queryTable<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetCount</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>count <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            MessageBox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Show</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Sewer line selected has no preventive maintenance scheduled."</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                        <SPAN class="punctuation token">}</SPAN>

                        <SPAN class="keyword token">else</SPAN>
                        <SPAN class="punctuation token">{</SPAN>
                            <SPAN class="comment token">// Used since query table doesn't display</SPAN>
                            <SPAN class="comment token">// MessageBox.Show($"Row count: {count}");</SPAN>
                        <SPAN class="punctuation token">}</SPAN>
                    <SPAN class="punctuation token">}</SPAN>
                <SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

BradJones3

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;
        }
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍