CODEWITHSUNDEEP
oracle-databasechartsoracle-apex
bbowen14
bbowen14

Reputation: 47

Filters For Charts on Apex

I have figured out how to add a filter to my chart, is there a way that if I leave this filter null that it will display all data as opposed to no data?

This is the line I used to create the filter:

Paint_shop = :P9_Select_Shop

Upvotes: 1

Views: 600

Answers (1)

Littlefoot
Littlefoot

Reputation: 142733

Use

where (Paint_shop = :P9_Select_Shop or :P9_Select_Shop is null)

Upvotes: 2

Related Questions