I’m new to obsidian, and code actually, and I wanted to tweak my dataview table a little bit.
In the metadatas of my notes I have “status:”. So far I have 4 status possibles for my notes.
In the dataview table, I would like those status to be replace by a pictogram/emoji.
I have trouble setting “conditions” to the replace() expression
I tried using IF() and CASE WHEN but it doesn’t work.
Maybe I’m not doing it right. Or maybe I need to stick with manually choosing the pictogram/emoji within the metadatas and it’ll show in my table.
It’s not capital but I was intrigued to see if it was possible!
What do you think?
What kind of values does status have? Textual? Single character?
In any case, given that it’s only going to be four different values, you could also try the following:
FLATTEN {
"A": "Icon for A",
"B": "Icon for B",
"C": "Icon for C",
"D": "Icon for D" }[status] as statusIcon
Then you’d use statusIcon instead of status in the column setup. The FLATTEN should go somewhere in between your TABLE/FROM and the WHERE/GROUP/SORT clauses. If you get any issues, please show us more of your query.
Bonus tip: How to present code properly in a forum post
If you want to showcase either markdown, or code blocks, or dataview queries properly in a forum post, be sure to add one line before and one life after what you want to present with four backticks, ````. This will ensure that any other backticks (like for code blocks or queries) is properly shown.