search

catalyst / totara-mod-ojt

https://github.com/catalyst/totara-mod-ojt/wiki
5 stars 21 forks source link

Status incorrectly named in item object #2

Closed markgrahamlp closed 7 years ago

markgrahamlp commented 8 years ago

The topic Item 'status' was inaccessible due to the SQL case not returning 'status', it was not possible to complete the Topic Items because of this missing alias.

Instead of column having the name 'status' it was called 'CASE WHEN c.status IS NULL THEN 0 ELSE c.status END'

markgrahamlp commented 7 years ago

Hi @eugeneventer,

Just wondering if you got the chance to look at this? We are hoping to use this activity type on our Totara sites.

Thanks, Mark

euven commented 7 years ago

Hi @podo0,

Let me see if I can have a look at this today ;)

Cheers, Eugene.

euven commented 7 years ago

Thanks @podo0, out of interest, which db were you using? This seemed to work fine in postgresql.

markgrahamlp commented 7 years ago

Hi @eugeneventer, this was on a MySQL database. Hope this is the information you are looking for.