Internal Error occurred using securityanswers column in analytic

[aundreb]

Hello,

I'm trying to create an analytic report to see if users have filled out their security answers or not. 

Below is my query.

SELECT 
u.username, 
u.firstname, 
u.lastname, 
u.donotdisturbdelegate, 
u.email, 
u.systemusername, 
u.owner, 
u.createdate, 
CASE WHEN u.statuskey = 0 THEN 'Inactive' WHEN  u.statuskey = 1 THEN 'Active' else u.statuskey END AS 'User Status', 
u.departmentname AS 'DEPARTMENT' 
FROM 
users u 
WHERE 
u.securityanswers IS NULL OR u.securityanswers = ''

I get the below error whenever I try to update the analytic. If I remove the securityanswers in the where clause it completes fine.

In Data Analyzer I get this error when I use the above query.

How can I work around this?

[rushikeshvartak]

You can't write query o securityanswers column

[aundreb]

There is no work around? Need to be able to just check if it is null, not display the security answers.

[rushikeshvartak]

• Do below create basic report
• Export using transport functionalty
• update query
• Zip file
• Reimport

[aundreb]

Let's you update it by exporting and reimporting but the query doesn't return any results when there should be. Should be multiple identities without security answers filled out.

[rushikeshvartak]

Then there is no workaround Please raise idea ticket