eQL to bring back documents/person that have an attribute value with blank line in it

Hello everyone,

Does anyone know of some eQL that I could use in a report to bring back documents/people that have a new line/s (blank returns) in one of their attributes? We have some free text attributes and users are pasting in text with blank lines in it, and I would really like a report to highlight these so that Document Control can correct the objects and keep eB as tidy and concise as possible.

Many thanks,

Julie

Parents
  • eQL treats empty values and white space the same as NULLs. To find these values use:

    . . .

    WHERE

    Attributes["Global", "Comments"].Value IS NULL

    . . .

    However, this will return values that are truly NULL, those that have only white space and those that are empty. Note that if you use the form TRIM(Attributes["Global", "Comments"].Value)  = '', it won't find anything, even if you have values that TRIM to an empty string. To differentiate between NULL, empty and whitespace you need to use a SQL query.

    Eric Rajala | Professional Services Consultant

    Bentley Systems, Incorporated

    Email: eric.rajala@bentley.com

    www.bentley.com

       
    This is a test

    Answer Verified By: julie_beck 

Reply
  • eQL treats empty values and white space the same as NULLs. To find these values use:

    . . .

    WHERE

    Attributes["Global", "Comments"].Value IS NULL

    . . .

    However, this will return values that are truly NULL, those that have only white space and those that are empty. Note that if you use the form TRIM(Attributes["Global", "Comments"].Value)  = '', it won't find anything, even if you have values that TRIM to an empty string. To differentiate between NULL, empty and whitespace you need to use a SQL query.

    Eric Rajala | Professional Services Consultant

    Bentley Systems, Incorporated

    Email: eric.rajala@bentley.com

    www.bentley.com

       
    This is a test

    Answer Verified By: julie_beck 

Children