CPQ : How to get the total number of quotes in "preparing" status on a domain ?

[agnesbaton]

We need to get the number of quotes which are in status 'preparing" on a specific domain ? How should we proceed to get it ?

[Yogananda]

agnes.baton

If this question is answered, can you please accept the answer.

[Yogananda · Accepted solution]

Hi agnes.baton

you can get the count of quotes which is in "Preparing" status and you can further extend it according to your need

status = 'Preparing'
sql = "select count(*) as Count1 from quotes where OrderStatus = '"+ status +"'"
no_of_count = SqlHelper.GetFirst(sql)

[agnesbaton · Accepted solution]

how to get the quote owner ?

what are the different columns for table quotes ?