Database View Where Clause Confusion

[brandon_chamber]

Hello,

I'm trying to setup a very basic database view of the Service Catalog table (sc_cat_item). However, I'd like the view to contain only active items. When I try to setup the view, add the view table and setup a Where clause (cat_active = true), the resulting view returns all records in the table. Why is this? This seems like a simple enough "filter" clause....


Thanks,

Brandon

[Daniel Draes]

Hi Brandon,

this is indeed weird. Just successfully reproduced your behaviour on my instance. No matter what I tried on the active field, always all rows get returned. I assume this is some kind of bug in the module as technically the boolean flags are stored as 0s and 1s. But also trying to filter on that does not work.

It is probably a good idea to raise an incident on HI. I could not find a record on this already.

Cheers,
Daniel

[brandon_chamber]

Thanks for looking into this. I will setup an incident in HI.

Brandon

[Rodrigo Higa]

Hi Brandon,

I'm currently facing the same issue here, did you have your issue solved by HI Support?

Please, could you share your solution for this case?

Regards,

Rodrigo

[brandon_chamber]

No.   Not really.   The summary of any information I was able to obtain was that the WHERE does not really work this way.   It is only meant as a selecting condition after a table JOIN.   If no JOIN is performed then the WHERE will not filter.