Skip to content

Idea: option to show sub document collection per "type" #41

@osexpert

Description

@osexpert

Hi,
We typically use a field in a collection to differ on type\modelType. This may be a field called type, modelType, label etc. (different for every collection). If we would specify what the type field is for a collection, CosmosDbExplorer could somehow create sub document nodes below "Documents" node to show the different types (and also one for documents that does not have this field at all).

The logic:
select top 1 * FROM c where IS_DEFINED(c.{typeField})
returns: {typeField} = "a"
select top 1 * FROM c where c.{typeField} not in("a")
returns: {typeField} = "b"
select top 1 * FROM c where c.{typeField} not in("a", "b")
returns: {typeField} = "c"
....

This would off course be an opt-in feature:-D

BTW: also missing the option to eg. Select top 1, but seems i can not edit that part of the query.

Good work!

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions