Where criterion SQL Syntax

[cbaqir]

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*');

[sinanozdemir]

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.

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

Hope this helps.

[cbaqir]

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

[rwunderlich · Accepted solution]

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

[cbaqir]

Thanks!

[rwunderlich]

Hi Cassandra,

It looks like you may be working on something similar to something I never finished due to lack of interest.

Looking for help with new Notes & Annotations tool

I've attached the code as far as I got. Feel free to use any of it that helps.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[cbaqir]

What about using the 'like' condition? I'm still having issues with that.