on 2021 Dec 16 11:06 AM
We need to get the number of quotes which are in status 'preparing" on a specific domain ? How should we proceed to get it ?
Request clarification before answering.
Hi agnes.baton
you can get the count of quotes which is in "Preparing" status and you can further extend it according to your needstatus = 'Preparing'
sql = "select count(*) as Count1 from quotes where OrderStatus = '"+ status +"'"
no_of_count = SqlHelper.GetFirst(sql)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This one is in tags
<*LIST(
-- To get the lis
SELECT CONCAT(FORMAT(c.USERID, '0000'), FORMAT(c.CART_ID,'0000'), '; ', osd.ORDER_STATUS_NAME, '; ', c.DATE_CREATED)
FROM CART c
INNER JOIN ORDER_STATUS_DEFN osd ON osd.ORDER_STATUS_ID = c.ORDER_STATUS
WHERE osd.ORDER_STATUS_NAME = 'Preparing'
ORDER BY DATE_CREATED DESC
)*>
<*TABLE(
-- To get the count
SELECT COUNT(*) FROM CART c
INNER JOIN ORDER_STATUS_DEFN osd ON osd.ORDER_STATUS_ID = c.ORDER_STATUS
WHERE osd.ORDER_STATUS_NAME = 'Preparing'
)*>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For a quick count, you could also just filter on the quote list page:
Click the "Load Existing Project/Quotation" icon on the main CPQ side menu.
Set to the "Other Quotes" tab.
Click the Filter icon.
On the pop-up, click in the top "Filter by Status" field, and select "Preparing".
Observe the "Number of items:" value at the bottom of the displayed quote list.
You should also do the same on the "My Quotes" tab, to get the count of your own quotes, if your user-ID has created any such quotes as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.