What table does a record producer saved as a draft save to?

bonsai
Mega Sage

I was able to save the record producer as a draft using the article below!

I would like to know the table information so I can display this saved data in a report. (I'm planning a report that will display items currently in draft.)


 

https://www.servicenow.com/community/sysadmin-forum/can-i-save-a-record-producer-without-sending-it/...

2 ACCEPTED SOLUTIONS

Nehal Dhuri
Mega Sage

Hello @bonsai ,
Draft items are stored in sc_cart_item table.

You can find more details about draft functionality in the following article
https://www.servicenow.com/community/developer-articles/save-catalog-items-as-draft/ta-p/2855484

Please hit like and mark my response as correct if that helps

View solution in original post

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @bonsai 

You can see the save as draft in sc_cart_item table. Create a report on same.

*************************************************************************************************************
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]

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

View solution in original post

4 REPLIES 4

Nehal Dhuri
Mega Sage

Hello @bonsai ,
Draft items are stored in sc_cart_item table.

You can find more details about draft functionality in the following article
https://www.servicenow.com/community/developer-articles/save-catalog-items-as-draft/ta-p/2855484

Please hit like and mark my response as correct if that helps

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @bonsai 

You can see the save as draft in sc_cart_item table. Create a report on same.

*************************************************************************************************************
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]

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

nityabans27
Mega Guru

Hi @bonsai ,

 

Draft items are stored in sc_cart_item table.
Please accept my answer as solution and mark it helpful.

Bhuvan
Kilo Patron

@bonsai 

 

Table name is sc_cart_item 

 

https://noderegister.service-now.com/kb?id=kb_article_view&sysparm_article=KB0958180

 

You can create a report and group by based on Item or Requested For or Created by fields and it will help to track draft items proactively and avoid performance issues.

 

Below are for reference with sample draft records,

Bhuvan_0-1757587179868.png

Bhuvan_1-1757587248936.png

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan