Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Where a database has different types of quotes - normal and those with repeating instructions, a custom filter is required to view normal templates that are not closed

Step-by-step guide

Use the following SQL code to create a new filter in Quotes that will display non-repeating quotes that do not have the status of 'Closed'

QO_Main.Status = 0 AND QO_Main.InvoiceID NOT IN (SELECT DISTINCT InvoiceID FROM QO_History WHERE InvoiceHistoryID IN (SELECT QuoteHistoryID FROM QO_HistoryActivate WHERE RepeatEvery <> 0))

 



  • No labels