How to Access the Database's Full `.json` file?

Hello everyone!

Objective

  • I'm trying to access the full content of the database's column with the type mSelect.

My approach

  • I have created a new column with the type template and tried to access the values of the mSelect column using index . "columnName".
  • Then, I wanted to get the total number of both selected and non-selected options.

Issue

  1. Only the selected options are getting fetched.

Debug

  • Using .action{toPrettyJson . } it only returned the selected options as an array under the name mSelect.
  • I went to \data\storage\av where all the actual json files are stored and found the file belonging to the database, then I found out that all options are stored there under "key": {"options":[]}.

Question

  • How can I access that json file and not the values from .action{toPrettyJson . }?

    Related articles

    Welcome to here!

    Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

    Signup About
    Please input reply content ...