Database view error

dgarad · ‎03-28-2024

I have created a database view I got an error.

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad

Dr Atul G- LNG · ‎03-28-2024

Hi @dgarad

Please share the table and where clause conditions.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

dgarad · ‎03-28-2024

Hi @Dr Atul G- LNG

below ss of table and where clause conditions

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad

Dr Atul G- LNG · ‎03-28-2024

HI @dgarad

https://www.servicenow.com/community/developer-forum/database-view-giving-error-syntax-error-or-acce...

The fix was to update "order" column. So the table that is primary and have no dependency then it should be 100 and subsequent can be 200 and so on.

*************************************************************************************************************
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/dratulgrover [ Connect for 1-1 Session]

****************************************************************************************************************

dgarad · ‎03-28-2024

Hi @Dr Atul G- LNG

I have changed the order also not working.

Thanks

If my answer finds you well, helpful, and related to the question asked. Please mark it as correct and helpful.

Thanks
dgarad