User created boolean fields don't work in database views

[Robert Campbell]

My user created boolean fields don't work in a database view.

Table	Active	Order	Left Join	Variable Prefix	Where Clause
incident	true	100	false	i1
incident	true	200	false	i2	i1.sys_id = i2.sys_id && i2.active = 1 && (i2.priority = 1 || i2.priority = 2) && i2.u_major_incident = 1

If view's where clause doesn't have the last line in red it works just fine.  If it does have the line in red, it gives no results although it should give many.

I've tried i1.sys_id = i2.sys_id && i2.u_major_incident = 1 and that also has no results.

I've also tried using && i2.u_major_incident = true and that doesn't work either.

If I change everything from '.' to '_' I get results but not the right results.  It returns everything

(i1_sys_id = i2_sys_id && i2_u_major_incident = 1 or anything (0, true, false))

[sushantmalsure]

And out of my curiosity what is the purpose of this database view? what are you trying to get with this where clause?

[sushantmalsure]

are you getting any kind of error while looking at DB view? please share the screenshot

[Robert Campbell]

This works

This does not

[Community Alums]

@Robert Campbell did you ever figure this one out? I am having the same issue