~ Efforts

Works are things we create. This note represents the third step in the ARC Framework, Communicate, and shows both works youโ€™ve shared and works in progress.

The following collection shows works in progress (WIPs), sorted by rank.

KEY: ๐Ÿ–‹๏ธ Articles | ๐Ÿ—ž๏ธ Newsletters | ๐ŸŽค Talks | ๐Ÿ“น Videos

TABLE WITHOUT ID
	choice(contains(file.path, "Efforts/Works/Articles"), 
		"๐Ÿ–‹๏ธ " + file.link,
	choice(contains(file.path, "Efforts/Works/Artifacts"), 
		"๐Ÿ’  " + file.link,
	choice(contains(file.path, "Efforts/Works/Lessons"), 
		"๐Ÿ““ " + file.link,
	choice(contains(file.path, "Efforts/Works/Lyrics"),
		"๐ŸŽต " + file.link,
	choice(contains(file.path, "Efforts/Works/Newsletters"),
		"๐Ÿ—ž๏ธ " + file.link,
	choice(contains(file.path, "Efforts/Works/Slides"),
		"๐Ÿ› " + file.link,
	choice(contains(file.path, "Efforts/Works/Talks"),
		"๐ŸŽค " + file.link,
	choice(contains(file.path, "Efforts/Works/Videos"),
		"๐Ÿ“น " + file.link,
choice(contains(file.path, "Efforts/Works/Walkthroughs"),
		"๐Ÿฅพ " + file.link,
	file.link))))))))) as "Works in Progress",
	
    rank as "Rank",
 
	regexreplace(file.path, ".*/([^/]+)/[^/]+$", "$1") as "Parent Folder"
 
WHERE rank and contains(collection,[[Works]]) 
 
SORT rank DESC
 
LIMIT 11

All Shared Works

Here is a list of all shared works, sorted by the most recent published date.

TABLE WITHOUT ID
	choice(contains(file.path, "Efforts/Works/Articles"), 
		"๐Ÿ–‹๏ธ " + file.link,
	choice(contains(file.path, "Efforts/Works/Artifacts"), 
		"๐Ÿ’  " + file.link,
	choice(contains(file.path, "Efforts/Works/Lessons"), 
		"๐Ÿ““ " + file.link,
	choice(contains(file.path, "Efforts/Works/Lyrics"),
		"๐ŸŽต " + file.link,
	choice(contains(file.path, "Efforts/Works/Newsletters"),
		"๐Ÿ—ž๏ธ " + file.link,
	choice(contains(file.path, "Efforts/Works/Slides"),
		"๐Ÿ› " + file.link,
	choice(contains(file.path, "Efforts/Works/Talks"),
		"๐ŸŽค " + file.link,
	choice(contains(file.path, "Efforts/Works/Videos"),
		"๐Ÿ“น " + file.link,
choice(contains(file.path, "Efforts/Works/Walkthroughs"),
		"๐Ÿฅพ " + file.link,
	file.link))))))))) as "Shared Works",
	
    published as "Published"
    
FROM "Efforts/Works"
 
SORT published DESC
 
LIMIT 55

Back to Efforts