Reporting issue

[pramn]

For the reporting purpose i have created a Database view , and it I have added 2 tables .

However when I am trying it ..its giving me below error 

also i have added this 

can you help me to fix this pls

[Arpan Baishya]

Hi @pramn,

The Variable Prefix column is showing 'Ta' whereas in the where clause, it's written as 'ta'. Could you please change the prefix value to 'ta' and then try again?

[AndersBGS]

Hi @pramn ,

please see this community post which has resolved similar issue: https://www.servicenow.com/community/developer-forum/database-view-quot-invalid-field-quot-error-wit...

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders