* Research Note Query Help

[Beerbadger]

Hi,
I've just been trying to use the Query capability to produce something from Research Notes and failed with all but producing a list of all my Research Notes and being able to exclude some based on various criteria.
The big problem is where to look in the hierarchical list of what is available to include in the Column tab.
What I see is shown in the attached screnshot.
I understand that I click the plus icons to open up more columns that I can add to the query and I have done that but cannot find anything meaningful for the Research Notes. For example where is Research Note ' Status', so that I can produce an output of all my Open Research Notes for example.
What is the difference between 'Source' and 'Source Note' and what relevance are the File Root, File Owner and File Header in this context ?
Is there somewhere that the hierarchy that is visible on clicking the plus icon is explained ?
Thanks.

[tatewise]

See the associated posting Research notes, to do and hash tags by Helen that shows Column settings.

See the 7th line that displays Status by using the =GetLabelledText(...) function.
That is how to handle all such labelled lines in any long text field such as Notes and Text From Source as well as Research Notes.

BUT in your Research Note case use %_RNOT.TEXT% instead of %NOTE.TEXT%

The difference between Source and Source Note is the former is a normal Source Citation and the latter is a local Note.

The others are refs to general records that are sometimes useful in every context. You will find them everywhere.

[Beerbadger]

Thanks Mike, just what I needed - a way in
I had begun to suspect that the Research Note was just a long text field and it didn't have fields for Status, Date and Title etc.
As a result they are not there to be selected from the hierarchical list that appears when you click the available plus buttons.

[Mark1834]

There is a KB article in preparation that puts all this in context and explains in more detail how to use Research Notes. I’ll post the link when it’s published.

[Beerbadger]

Thanks Mark.

[Mark1834]

This is the KB article on Research Notes.