This is a public Forum  publicRSS

Topic

    Venkat Tanneru
    LongText as Filter in ReportsAnswered
    Topic posted July 17, 2017 by Venkat TanneruExplorer 
    23 Views, 2 Comments
    Title:
    LongText as Filter in Reports
    Content:

    We have a requirement where we need a long text as a filter.

    Can AnyOne Please suggest how to achieve the same.

    Regards

    Best Answer

    Pramod Vasudeva Murthy

    This is the one that I have been searching for ages,

    No, we cannot have a long text field as a filter. Besides, if you think from a cap of DB/ROQL generator, it is not efficient also as long text field cannot be indexed and cause more chaos than desired results.

    ~VIP

    Answer

     

    • Pramod Vasudeva Murthy

      This is the one that I have been searching for ages,

      No, we cannot have a long text field as a filter. Besides, if you think from a cap of DB/ROQL generator, it is not efficient also as long text field cannot be indexed and cause more chaos than desired results.

      ~VIP

    • Mehrzad Kootar

      It depends what you want to search on the one way you can achieve this via a filter only over the incident table is the incidents.search_thread. This is a hidden field so you wont see it in the report but when you add it to the filter it will allow you to search on free form text . 

      Also for other free from text searches you can you to auto filter and it has many functions you can use . Attached is a doc which show how you can use the Auto Filter for searching .

      Mehrzad