Database view error

dgarad
Giga Sage

‎03-28-2024 06:23 AM

 I have created a database view I got an error.

 

dgarad_0-1711632176981.png

 

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

Thanks
dgarad
0 Helpfuls
  • 498 Views
10 REPLIES 10

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-28-2024 06:28 AM

Hi @dgarad 

 

Please share the table and where clause conditions. 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

dgarad
Giga Sage
In response to Dr Atul G- LNG

‎03-28-2024 06:44 AM

Hi @Dr Atul G- LNG 

 below ss of table and where clause conditions

dgarad_0-1711633408741.png

 

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

Thanks
dgarad
0 Helpfuls

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to dgarad

‎03-28-2024 07:01 AM

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.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

dgarad
Giga Sage
In response to Dr Atul G- LNG

‎03-28-2024 10:33 PM

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
0 Helpfuls