Advertisement
dhniceday

Untitled

Aug 4th, 2023
445
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.68 KB | None | 0 0
  1. Frontmatter example:
  2. ---
  3. cardtitle: "Backfire Effect"
  4. definition: "A [[Cognitive Bias]] that causes people who encounter **evidence that challenges their beliefs to reject that evidence**, and to *strengthen their support for their original stance*."
  5. ---
  6.  
  7. Query:
  8.  
  9. ``` dataview
  10. TABLE
  11.     definition
  12. FROM ""
  13. WHERE
  14.     definition and cardtitle
  15. FLATTEN
  16.     date(now) as Now
  17. FLATTEN
  18.     (file.mtime.year + file.mtime.hour + file.mtime.day + file.mtime.hour + file.mtime.minute + file.mtime.second + file.size + Now.hour + Now.minute + Now.second) * 15485863 as Hash
  19. FLATTEN
  20.     ((Hash * Hash * Hash) % 2038074743) / 2038074743 as Rand
  21. WHERE
  22.     max(Rand)
  23. SORT
  24.     Rand
  25. LIMIT
  26.     1
  27. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement