link(file.path, Name) AS “Name”,
embed(Arte) AS “Arte”,
Raza AS “Raza”,
Clase AS “Clase”,
Ocupacion AS “Ocupacion ”
WHERE contains(Tipo, “PJ”)
SORT file.name asc
link(file.path, name) AS “Name”,
QuickNotes AS “QuickNotes”
WHERE contains(NoteIcon, “SessionNote”) AND contains(WhichParty, “Party 1”)
SORT file.name desc LIMIT 9
link(file.path, name) AS “Name”,
QuickNotes AS “QuickNotes”
WHERE contains(NoteIcon, “Quest”) AND contains(WhichParty, “Party 1”) AND contains(status, “Active”)
SORT file.name asc
link(file.path, name) AS “Name”,
QuickNotes AS “QuickNotes”
WHERE contains(NoteIcon, “Side”) AND contains(WhichParty, “Party 1”) AND contains(status, “Active”)
SORT file.name asc
link(file.path, name) AS “Name”,
QuickNotes AS “QuickNotes”
WHERE contains(NoteIcon, “ServiceRequest”) AND contains(WhichParty, “Party 1”) AND contains(status, “Requested”) OR contains(status, “In-Progress”) OR contains(status, “Pending Pick-Up”)
SORT file.name asc
link(file.path, name) AS “Name”,
QuickNotes AS “QuickNotes”
WHERE contains(NoteIcon, “Letter”) AND contains(WhichParty, “Party 1”) AND !contains(status, “PlayerRecieved”)
SORT file.name asc