Beginner with a simple query that fails

[rbanks88]

What I’m trying to do

Execute a simple Dataview query for a couple of list-type properties.

Things I have tried

Why does this query get “PARSING FAILED” Expected: variable ?

TABLE target as "Target", status as "Status",
FROM "Art/Venues"
WHERE contains(target, "foreign") AND contains(target, "port")

And while trying to troubleshoot the failed parsing, above, I simplified the query below, and while it doesn’t fail, it finds no results. As you can see, I do have one note with a property named “target” whose value is “foreign”:

TABLE Target, Status
FROM "/Art/Venues"
WHERE contains(target, "foreign")

Why might I be getting no results?

Thanks for any help you can provide!

[Pch]

@rbanks88

TABLE target as "Target", status as "Status",
FROM "Art/Venues"
WHERE contains(target, "foreign") AND contains(target, "port")

There’s a rogue comma after "Status" on the 1st line so Dataview expect “something” after the status …

@rbanks88

TABLE Target, Status
FROM "/Art/Venues"
WHERE contains(target, "foreign")

For this one, I don’t know if Dataview is case sensitive or not …
I mean, I don’t know how it sees Target (as you wrote it in the query) vs. target (as you wrote it in Properties) …

You could still try:

TABLE target, status
FROM "Art/Venues"
WHERE contains(target, "foreign")

or

TABLE target as "Target", status as "Status"
FROM "Art/Venues"
WHERE contains(target, "foreign")

[rbanks88]

Thanks for finding the comma. I knew it had to be something that simple, but I just wasn’t seeing it.

And fixing the case also worked.

I appreciate you taking the time to respond.

Regards,
Russell