nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to implement TableSort to ArcGISPro SDK?

JamesKennedy1

I have a question on how to implement a TableSort in ArcGISPro SDK

In ArcObjects, the ArcMap SDK, you can do something like this

TableSort tableSort = new ESRI.ArcGIS.Geodatabase.TableSortClass();
tableSort.Fields = refMileField;
tableSort.set_Ascending(refMileField, true);
tableSort.QueryFilter = profileScenarioFilter2;
tableSort.Table = profileScenarioTable.Table;
tableSort.Sort(null);

Later on I use this TableSort in order to give a RowCursor its rows it needs.

What is the proper way I can convert TableSort to a RowCursor?

Or is there another way I need to convert the TableSort to another type?

Thank You

Find more posts tagged with

Accepted answers

JamesKennedy1

Thanks for taking the time to answer. My solution ended up being

ArcGIS.Core.Data.SortDescription refMileFieldSortDescription = new ArcGIS.Core.Data.SortDescription(refMileActualField);
refMileFieldSortDescription.SortOrder = ArcGIS.Core.Data.SortOrder.Ascending;
TableSortDescription tableSortDescription = new TableSortDescription(new List<ArcGIS.Core.Data.SortDescription>() { refMileFieldSortDescription } );

tableSortDescription.QueryFilter = profileScenarioFilter2;

Table tableSortTable = profileScenarioTable.GetTable();
RowCursor sortedScenarioCursor = tableSortTable.Sort(tableSortDescription);

you can put a Query filter in the TableSortDescription, which merged the two into being kind of a sort query command.

All comments

JamesKennedy1

Thanks for taking the time to answer. My solution ended up being

tableSortDescription.QueryFilter = profileScenarioFilter2;

Table tableSortTable = profileScenarioTable.GetTable();
RowCursor sortedScenarioCursor = tableSortTable.Sort(tableSortDescription);

you can put a Query filter in the TableSortDescription, which merged the two into being kind of a sort query command.

JamesKennedy1

Thanks that did it!

GKmieliauskas

Hi James,

There is simpliest way to do what you need. Add to your QueryFilter variable PostfixClause and run Search on your table like this:

public async Task SearchingATable()
{
try
{
    await ArcGIS.Desktop.Framework.Threading.Tasks.QueuedTask.Run(() => {
      using (Geodatabase geodatabase = new Geodatabase(new DatabaseConnectionFile(new Uri("path\\to\\sde\\file\\sdefile.sde"))))
      using (Table table = geodatabase.OpenDataset<Table>("EmployeeInfo"))
      {

        QueryFilter queryFilter = new QueryFilter
        {
          WhereClause = "COSTCTRN = 'Information Technology'",
          SubFields = "KNOWNAS, OFFICE, LOCATION",
          PostfixClause = "ORDER BY OFFICE"
        };

        using (RowCursor rowCursor = table.Search(queryFilter, false))
        {
          while (rowCursor.MoveNext())
          {
            using (Row row = rowCursor.Current)
            {
              string location = Convert.ToString(row["LOCATION"]);
              string knownAs = Convert.ToString(row["KNOWNAS"]);
            }
          }
        }
      }
    });
}
catch (GeodatabaseFieldException fieldException)
{
    // One of the fields in the where clause might not exist. There are multiple ways this can be handled:
    // Handle error appropriately
}
catch (Exception exception)
{
    // logger.Error(exception.Message);
}
}

Sample from ArcGIS Pro snippets:

https://github.com/esri/arcgis-pro-sdk/wiki/ProSnippets-Geodatabase

RichRuh

James,

I think setting the TableSortDescription.QueryFilter property will provide what you're looking for.

--Rich

JamesKennedy1

Thanks I transmuted my code to this....

Table tableSortTable = profileScenarioTable.GetTable();
RowCursor sortedScenarioCursorFromSort = tableSortTable.Sort(tableSortDescription);
RowCursor sortedScenarioCursor = tableSortTable.Search(profileScenarioFilter2, false);

But now I have a new question.

How can I make sure I sort, and run my Query Filter at the same time? They both return RowCursors, but how can I merge Sorting and Searching to give me the correct rowcursor after sorting, then searching.

Thank you.

RichRuh

Hi James,

Check out this section in the Geodatabase concepts document; I think it should answer your questions.

Thanks,

--Rich

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.