6 Replies Latest reply: Jul 6, 2016 3:53 PM by Cassandra Baqir RSS

    Where criterion SQL Syntax

    Cassandra Baqir

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

       

      7-6-2016 11-29-06 AM.gif