New to Dataview - stumped by simple query

[griffimu]

Hi - I have the following query I am trying to run:

TABLE doc_type, last_reviewed, Industry
WHERE doc_type AND contains(Industry,”Health Care”)=true

When I switch to Preview mode, I receive the following error:

Dataview: Error:
-- PARSING FAILED --------------------------------------------------

1 | TABLE doc_type, last_reviewed, Industry

2 | WHERE doc_type AND contains(Industry,”Health Care”)=true
| ^
3 |

Expected one of the following:

'(', 'null', boolean, date, duration, file link, list ('[1, 2, 3]'), negated field, number, object ('{ a: 1, b: 2 }'), string, variable

I know this is very simple but I am stumped. Can someone let me know what I'm doing wrong?

Thanks!

[filmgal]

try this in your where condition:
WHERE contains(Industry,”Health Care”)

[griffimu]

Same message. It is showing an error parsing the string, from what I can tell.

Dataview: Error:
-- PARSING FAILED --------------------------------------------------

1 | TABLE doc_type, last_reviewed, Industry

2 | WHERE contains(Industry,”Health Care”)
| ^
3 |

Expected one of the following:

'(', 'null', boolean, date, duration, file link, list ('[1, 2, 3]'), negated field, number, object ('{ a: 1, b: 2 }'), string, variable

[filmgal]

If you need to limit to doc_type try another where condition, ie
either this
where doc_type!=null and contains(Industry, "Health Care") OR
this
where doc_type!="" and contains(Industry, "Health Care")

[M-bot]

The quotation character in your query is different. Use " instead of ” (yes, they look extremely similar)

If this is happening consistently then potentially something is modifying them automatically. A plugin might be (though I don't know of any that would) or if you're using a document editor (like Word) somewhere along the way those also tend to change the quote character.

[griffimu]

That's it!! Smart punctuation on the iPad. Turned off, and it worked. Thanks for your help.

[Sheldontao]

but, some condition on Mac.

[AB1908]

Try copying example queries from the docs.