Skip to content
Snippets Groups Projects
New look: Off

Select properties of children/references

    • Closed Issue created by Henrik tom Wörden @henrik

    Created by: Henrik tom Wörden

    SELECT is a powerful tool to collect data for further processing. However, currently it is only possible to select properties of the records in the result set (suppose you have "houses" in your search result you can get their height: select height from houses). You cannot access properties of records that are referenced (you might get windows of the houses: select window from houses; but there is no select window.height from houses)

    This promotes a flat data structure where all relevant attributes are connected to a single Record which stand in contrast to the semantic data model that CaosDB uses.

    Thus, I recommend, that it should be possible to select properties of referenced records. A dot notation could be a good option. Example: SELECT window.height FROM house.

    Imported comments:

    By Timm Fitschen on 2020-07-16T00:29:01.373Z

    mentioned in commit 30d3d3d4

    By Timm Fitschen on 2020-07-16T00:29:01.265Z

    closed via merge request !47 (merged)

    By Quazgar on 2020-07-14T17:19:42.318Z

    mentioned in merge request !47 (merged)

    By Quazgar on 2020-07-14T17:18:12.681Z

    See !47 (merged) for an implementation.

    By Quazgar on 2020-05-27T13:46:05.263Z

    changed the description

    By Quazgar on 2020-05-27T13:45:08.032Z

    changed the description

    To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information

    Child items 0

    • No child items are currently assigned. Use child items to break down this issue into smaller parts.

    Activity

    Please register or sign in to reply