Discussion Board for collaboration on QlikView Scripting.
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*');
Go to 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.
I would use LIKE operator in SQL so:
Objects:LOAD ID, ObjectType, ObjectModifiedTimeUtc;SQL SELECT *FROM Objectswhere 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,AnnotationModificationTimeSQL SELECT *FROM Annotationswhere FileName Like '%AU FINANCIAL%';
Hope this helps.
I tried this as well but it didn't work. ???
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.
What about using the 'like' condition? I'm still having issues with that.