Additional operators on the query builder window for string types

[samodovdi]

trafficstars

Storage Explorer Version: 1.3.1 Platform/OS Version: macOS Architecture: x64

Would be great to have such operators as 'contains', 'starts with', 'end with' for string types on the query builder

[MRayermannMSFT]

The addition of more operators is dependent on the platform. We'll leave this open so we can track it.

[samodovdi]

why this issue/feature is closed? won't be implemented? AzureStorageExplorer - this one - https://archive.codeplex.com/?p=azurestorageexplorer implemented it this way:

` CloudTable table = tableClient.GetTableReference(tableName);

            // Query the table and retrieve a collection of entities.

            var query = new TableQuery<ElasticTableEntity>();

            IEnumerable<ElasticTableEntity> entities = null;

            if (EntityQueryEnabled)
            {
                EntityQuery.IsChecked = true;

                IEnumerable<ElasticTableEntity> q = null;

                switch (EntityQueryCondition[0])
                {
                    case "equals":
                        q = table.ExecuteQuery(query).Where(e => e.Value(EntityQueryColumnName[0]) == EntityQueryValue[0]).Select(e => e);
                        break;
                    case "does not equal":
                        q = table.ExecuteQuery(query).Where(e => e.Value(EntityQueryColumnName[0]) != EntityQueryValue[0]).Select(e => e);
                        break;
                    case "contains":
                        q = table.ExecuteQuery(query).Where(e => e.Value(EntityQueryColumnName[0]).Contains(EntityQueryValue[0])).Select(e => e);
                        break;
                    case "starts with":
                        q = table.ExecuteQuery(query).Where(e => e.Value(EntityQueryColumnName[0]).StartsWith(EntityQueryValue[0])).Select(e => e);
                        break;
                    case "ends with":
                        q = table.ExecuteQuery(query).Where(e => e.Value(EntityQueryColumnName[0]).EndsWith(EntityQueryValue[0])).Select(e => e);
                        break;
                }

... `

[samodovdi]

sorry, the other issue was closed as duplicated. @MRayermannMSFT any progress on this?

[adityadeshpande]

Any update on this? Can't really wait for Dec 16, 2028 milestone