Tag combination filtering

[lbgws2]

I found an example about Tag extension

IMDB keywords

IMDB has annotated hundreds of keywords for each movie, and by filtering the combination of keywords (i.e. containing multiple keywords at the same time), one can quickly find related movies that interest them

IMDB stores millions of film and television content, and with such a large amount of data, it is very difficult to quickly find the content that interests oneself. Label combination filtering is undoubtedly a very interesting data filtering method

The specific process is

1. Enter the first label (if there is no label, display the most recently entered label)
2. Retrieve the rows containing the entered tags from the tag library
3. Sort other tags in the tag row according to their frequency of occurrence
4. Generate a pop-up menu
   I completed this process using SQL statements. The specific statement is

SELECT
count(1),tag as count
from Record
where note_id in
(
SELECT
note_id
from Record
where
tag in (query)
)
and tag not in (query)
group BY tag
order BY count(1) desc,tag asc

[lbgws2]

Another request related to tag functionality is Tag filtering, which may not coincide with the target of this plugin, so it is discussed here

When entering tags in the search box, search for all tag rows and provide tag input suggestions based on their frequency of occurrence

My idea is to use tag filtering and tag extension to quickly label and locate relevant content, replacing tree directory classification and keyword search

For example, I have a vim CheatSheet. In the tree directory, should I place it in the vim directory or should I create a CheatSheet directory to store Docker CheatSheet, Linux CheatSheet, and other related content

Perhaps a better approach is to use tags for classification, I just need to label the relevant content, such as #vim #CheatSheet

When I enter the #vim tag, I can list all Vim related content. At this time, the popup input box lists other related tags such as #CheatSheet #scrip #snippet. When I click one tag, I can quickly filter related content,

When a personal knowledge base expands to tens of thousands of pieces of content, traditional keyword based search results are too many to quickly locate relevant content. If you cannot find relevant content smoothly, then it does not exist

I am very willing to work together to improve the relevant functions and provide my own suggestions