Dataview/embedded search help: embed list of highlighted text within a given date range

Topic

Summary
  • How to get the highlighted texts like ==text== instead of == text== from the file.lists?

Test

Summary
  • dataview: v0.5.46

Input

Summary

dictionary files:

  • Location: “100_Project/01_dataviewjs/01_by_example/Q21_Highlight/Q21_test_data”

folder: 03

  • filename : dic_19840301
  • file.ctime: “1984-03-01T19:30:50”
---
Date: 1984-03-01
---


### input_data
#### a
- a1  ==One highlight== test
- a2

#### b
- b1
- b2  ==Another highlight== test ==Some highlight== test

#### c
- [x] c1
- [ ] c2

#### d
- [ ] d1
- [x] d2

#### e
- [!] e1
- [ ] e2

#### f



folder: 04

  • filename : dic_19840401
  • file.ctime: “1984-04-01T19:30:50”
---
Date: 1984-04-01
---


### input_data
#### a
- a1
- a2

#### b
- b1
- b2

#### c
- [>] c1
- [ ] c2  ==This is some highlight.== test

#### d
- [x] d1
- [ ] d2  ==It is another highlight.== test

#### e
- [ ] e1
- [x] e2

#### f



folder: 05_Unicode

  • filename : dic_19840501
  • file.ctime: “1984-05-01T19:30:50”
---
Date: 1984-05-01
---


### input_data
#### a
- a1  Greek Alphabet ==αβγδεζηθικλμνξοπρςστυφχψω== test
- a2

#### b
- b1
- b2  Turkish characters ==ÇçĞğıİÖöŞşÜü== test

#### c
- [ ] c1  Japanese hiragana Alphabet ==今日の天気は良いです== CJK Unified Ideographs
- [ ] c2  Warning Sign Emoji ==⚠⛔== No Entry Emoji

#### d
- [ ] d1
- [ ] d2

#### e
- [ ] e1
- [ ] e2

#### f



folder: 08_excluding_case

  • filename : dic_19840801
  • file.ctime: “1984-08-01T19:30:50”
---
Date: 1984-08-01
---


### input_data
#### a
- a1  == Not highlight == test
- a2

#### b
- b1
- b2  == Not highlight == test == Not highlight == test

#### c
- [x] c1
- [ ] c2

#### d
- [ ] d1
- [x] d2

#### e
- [!] e1
- [ ] e2

#### f




DVJS10_groupBy_fLink_flatten_fLists_and_taskList_under_the_heading

Summary

Main DVJS

Code Name Data type Group By Purposes Remark
DVJS10
_groupBy_fLink
_flatten_fLists
_and_taskList
_under_the_heading
file.lists yes
groupIn:no
1.To groupBy page.file.link as G1 (G1=group.rows)
2.To flatten page.file.lists
3.To gather a list item(or a task item) under any heading
4.To gather a list item(or a task item) that contains a highlighted text
5.To gather a highlighted text and push it into the aMatch array
6.To display each highlighted text in each single line
The DVJS10 is based on the DVJS90 in the following topic.
- Solutions: by Justdoitcc

Notes

Summary

Q1: The same codes

Summary_Q1
  • To filter the data by page.file.ctime
Original Example10
  • To compare the dates
```JS
// M11. define pages: gather all relevant pages
// #####################################################################
let pages = dv
    .pages('"100_Project/01_dataviewjs/01_by_example/Q21_Highlight/Q21_test_data"')
    .where(
        (page) =>
            page.file.ctime >= dv.date("1984-03-01T00:00:00") &&
            page.file.ctime <= dv.date("1984-05-31T23:59:59")
    );


```
Another Example11
  • To compare the strings of the dates
```JS
// M11. define pages: gather all relevant pages
// #####################################################################
let pages = dv
    .pages('"100_Project/01_dataviewjs/01_by_example/Q21_Highlight/Q21_test_data"')
    .where(
        (page) =>
        page.file.ctime.toFormat("yyyy-MM-dd HH:mm:ss") >=
            dv.date("1984-03-01T00:00:00").toFormat("yyyy-MM-dd HH:mm:ss") &&
        page.file.ctime.toFormat("yyyy-MM-dd HH:mm:ss") <=
            dv.date("1984-05-31T23:59:59").toFormat("yyyy-MM-dd HH:mm:ss")
    );
  
    
```

Q2: What does the following Regular Expression mean?(M31)

Summary_Q2
```JS
    // M31.FR10 define REGEX_HIGHLIGHTED_TEXT: 
    // The pattern matches highlighted texts like `==text==` instead of `== text==`
    // Capturing Group (x) : Matches x and remembers the match.
    // Non-Capturing Group (?:x) : Matches "x" but does not remember the match.
    // Quantifier *? : Matches the previous token between 
    //                 zero and unlimited times, as few times as possible,
    //                 expanding as needed (lazy)
    // Modifier g : global. All matches (don't return after first match)
    // Modifier u : unicode. Enable all unicode features and  
    //              interpret all unicode escape sequences as such
    // #####################################################################
    // Capturing Group (x) + non-greedy y*?
    // const REGEX_HIGHLIGHTED_TEXT = /(==[^\s].*?==)/gu;  
    // Non-Capturing Group (?:x) + non-greedy y*? : (For better performance)
    const REGEX_HIGHLIGHTED_TEXT = /(?:==[^\s].*?==)/gu;
    
```

A2:

Non-Capturing Group (?:x) + non-greedy y*?
  • Non-Capturing Group (?:==[^\s].*?==)
  • Global pattern flags
    • g modifier: global. All matches (don’t return after first match)
    • u modifier: unicode. Enable all unicode features and interpret all unicode escape sequences as such
Screenshots(DVJS10_A2)


Q3: How to get the file.path of the note named dic_19850301?

Summary_Q3

A3:

using Inline DQL
```SQL
full_file_path = `=[[dic_19850301]].file.path`
```

//=>100_Project/01_dataviewjs/01_by_example/Q84_Contains/Q84_test_data/03/dic_19850301.md
From the result, you can copy the path as needs.

using Inline DVJS
```JS
full_file_path = `$=dv.page("dic_19850301").file.path`
```

//=>100_Project/01_dataviewjs/01_by_example/Q84_Contains/Q84_test_data/03/dic_19850301.md
From the result, you can copy the path as needs.


code DVJS10_groupBy_fLink_flatten_fLists_and_taskList_under_the_heading

Summary_code
title: DVJS10_groupBy_fLink_flatten_fLists_and_taskList_under_the_heading => 1.To groupBy page.file.link as G1 (G1=group.rows) 2.To flatten page.file.lists 3.To gather a list item(or a task item) under any heading 4.To gather a list item(or a task item) that contains a highlighted text 5.To gather a highlighted text and push it into the aMatch array 6.To display each highlighted text in each single line
collapse: close
icon: 
color: 
```dataviewjs
// M11. define pages: gather all relevant pages
// #####################################################################
let pages = dv
    .pages('"100_Project/01_dataviewjs/01_by_example/Q21_Highlight/Q21_test_data"')
    .where(
        (page) =>
            page.file.ctime >= dv.date("1984-03-01T00:00:00") &&
            page.file.ctime <= dv.date("1984-05-31T23:59:59")
    );


// M21. define groups:
// To groupBy page.file.link AS G1 (G1=group.rows)
// #####################################################################
let groups = pages
    .groupBy((page) => page.file.link);
    //.sort((group) => group.key, "desc");


// M31. output groups:
// #####################################################################
for (let group of groups) {
    
    // M31.FR10 define REGEX_HIGHLIGHTED_TEXT: 
    // The pattern matches highlighted texts like `==text==` instead of `== text==`
    // Capturing Group (x) : Matches x and remembers the match.
    // Non-Capturing Group (?:x) : Matches "x" but does not remember the match.
    // Quantifier *? : Matches the previous token between 
    //                 zero and unlimited times, as few times as possible,
    //                 expanding as needed (lazy)
    // Modifier g : global. All matches (don't return after first match)
    // Modifier u : unicode. Enable all unicode features and  
    //              interpret all unicode escape sequences as such
    // #####################################################################
    // Capturing Group (x) + non-greedy y*?
    // const REGEX_HIGHLIGHTED_TEXT = /(==[^\s].*?==)/gu;  
    // Non-Capturing Group (?:x) + non-greedy y*? : (For better performance)
    const REGEX_HIGHLIGHTED_TEXT = /(?:==[^\s].*?==)/gu;
    
    
    // M31.FR11 define aMatch: to store highlighted texts
    // ##################################################################### 
    let aMatch = [];
    
    
    // M31.FR13 define a_filtered_lists:
    // FLATTEN_CASE_10:To FLATTEN page.file.lists and gather them
    // WHERE_CASE_11  :To gather a list item(or a task item) under any heading
    // WHERE_CASE_12A :To gather a list item(or a task item) that contains a highlighted text
    // WHERE_CASE_12B :To gather a highlighted text and push it into the aMatch array
    // #####################################################################
    let a_filtered_lists = group.rows
        .flatMap((page) => page.file.lists)
        .where(
            (L) =>
                // M31.FR13.WH11 gather a list item(or a task item) under any heading
                // #####################################################################
                L.header.type === "header"
        )
        .where((L) => {
            // M31.FR13.WH12A: gather the L that contains a highlighted text
            // #####################################################################
            // #####################################################################
            
            // M31.FR13.WH12B : define aHighlights            
            // to store the highlighted texts from the L.text temporarily
            // #####################################################################
            // str.match(/regex/g) returns all matches as an array, but capturing groups are not included.
            let aHighlights = L.text.match(REGEX_HIGHLIGHTED_TEXT);
            
            if (aHighlights) {                
                // M31.FR13.WH12B.IFT10P: to push the aHighlights array into the aMatch array
                // #####################################################################
                aMatch.push(aHighlights);
                
                // M31.FR13.WH12A.IFT10Q: to gather the L
                // #####################################################################
                return true;
            } else {
                // M31.FR13.WH12A.IFF10: Not to gather the L
                // #####################################################################
                return false;
            }
        });


    // M31.FR15 check a_filtered_lists.length :
    // #####################################################################
    if (a_filtered_lists.length === 0){
        continue;
    }
    
        
    // M31.FR21 output page.file.link :
    // #####################################################################
    dv.header(3, group.key + ":");
    
    
    // M31.FR33 output a_filtered_lists.text: [without the desired structure]
    // #####################################################################
    //dv.span(a_filtered_lists.text);

    
    // M31.FR35 output aMatch: 
    // #####################################################################
    // #####################################################################
    // CASE_A: Output it as a list and
    //         display highlighted texts that are from the same L.text in a single line
    // #####################################################################
    // dv.span(aMatch.join("<br>")); 
    
    
    // CASE_B: Output it as a list
    // #####################################################################
    // dv.el("span", aMatch);
    
    
    // CASE_C: Output each highlighted text in each single line
    // #####################################################################
    for (let e of aMatch) {
        dv.el("span", e);
    }
    
    
}


```

Screenshots(DVJS10):


Reference

Summary

2 Likes