ORM structure with case when

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • codeboy
    Senior Member
    • May 2018
    • 112

    ORM structure with case when

    I examined the ORM documentation. But I could not find anything related to the "case when" structure. Could you tell me this, please?
    I have to use ORM because I use run time filter. I can not use pure php.
    I tried this way.;

    Code:
    ['SUM: CASE WHEN assignedStatus THEN 1 ELSE 0 END','status']
    not working.

    If you don't have anything like that, say no to me.

    Thanks.
  • tanya
    Senior Member
    • Jun 2014
    • 4308

    #2
    With ORM you can't do this. But you can execute your query

    Comment

    • codeboy
      Senior Member
      • May 2018
      • 112

      #3
      Ok, Then I need this answer please.

      I want to get only the WHERE part of the SQL output. Because I will add "where" as to pure php. for example; WHERE assigned_status = 'Okay' like this

      Comment

      Working...