topic Where criterion SQL Syntax in QlikView

Where criterion SQL Syntax

cbaqir — Wed, 06 Jul 2016 18:30:06 GMT

These should be so simple and neither are working. What is wrong?

Objects:
LOAD ID,
ObjectType,
ObjectModifiedTimeUtc;
SQL SELECT *
FROM Objects
where ObjectType = 'AnnotationTopic';

Annotations:
LOAD ID,
FileName,
AnnotationTitle,
AnnotationText,
AnnotationAuthor,
AnnotationParentObjectId,
AnnotationCreationTime,
AnnotationModificationTime
SQL SELECT *
FROM Annotations
where FileName in ('*AU FINANCIAL*');

Re: Where criterion SQL Syntax

sinanozdemir — Wed, 06 Jul 2016 18:59:02 GMT

I would use LIKE operator in SQL so:

Objects:
LOAD ID,
ObjectType,
ObjectModifiedTimeUtc;
SQL SELECT *
FROM Objects
where ObjectType Like 'Annotation Topic';

And in this one, I would swap out "*" for "%". I am assuming you are using MS SQL.

Hope this helps.

Re: Where criterion SQL Syntax

cbaqir — Wed, 06 Jul 2016 19:09:58 GMT

I tried this as well but it didn't work. ???

Re: Where criterion SQL Syntax

rwunderlich — Wed, 06 Jul 2016 19:17:59 GMT

It looks like you are using the QvServerObjectConnector. AFAIK that connector does not support Where clause. I believe it only supports a basic "SELECT Field" syntax.

If you want to do filtering, do it in the preceding load statement.

Objects:
LOAD ID,
ObjectType,
ObjectModifiedTimeUtc

where ObjectType = 'AnnotationTopic';

;
SQL SELECT *
FROM Objects;

Also be aware that I have encountered a bug with the Objects table where output is sometimes incomplete, but no error is thrown.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com