Problems with declared field filters

  • Resolved tiicaa

    (@tiicaa)


    4 years, 9 months ago

    Hello I realize that when I declare not to have SLQ – SELECT something in this model:

     SELECT CASE wc.comment_approved 
            WHEN 'in-progress' THEN 'In progress'
            WHEN 'complete' THEN 'Concluded'
            ELSE 'Unknow'
            END as 'Status',

    Even putting the alias information in the Fields (optional) to release the search option it does not return any information, I tried to search for ‘complete’ or for the given name of the field ‘Concluded’. Does the search not occur by the type of select?

Viewing 1 replies (of 1 total)
  • Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    Have you tried entering this as the real name: CASE wc.comment_approved WHEN 'in-progress' THEN 'In progress' WHEN 'complete' THEN 'Concluded' ELSE 'Unknow' END

    I’ve never tested or tried that kind of alias build but it might just work like that. The problem is that you’re changing the value there in the SELECT and the code that Exports and Reports runs needs to know exactly how to use it when doing a WHERE.

Viewing 1 replies (of 1 total)
  • The topic ‘Problems with declared field filters’ is closed to new replies.