Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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))


 

Filter by label (Content by label)
showLabelsfalse
max5
spacesJ7UG
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ("filters","quote","quotes") and type = "page" and space = "J7UG"
labelsquote quotes filters

...

Page Properties
hiddentrue


Related issues