Filter options on paragraph and multi-select picklist fields in reports

[mpasumarti]

The filter options provided for paragraph and multi-select picklist fields (there may be other fields which fall into this bucket) in reports are Contains, Starts With, Ends With, Does Not Contain and Is. The challenge here is how can I configure/build a report looking for items with either of those fields populated (are NOT NULL)?

[james.l.bryant · Accepted solution]

Hello @mpasumarti,

Thank you for taking time to contact Autodesk Forums and Support.  I have recently been made aware of your questions/issue.    In reports the goal is to  show all workspace items missing data values for multiple picklist field name but report filtering is missing filter option 'Is Blank'.

@mpasumarti,  thank you for bringing this to my attention.  This is a great IDEA which could be beneficial to Fusion Lifecycle members.  I would suggest reaching out to product management directly and posting this with them at IDEAS here. 

This as you mentioned affects only particular data fields like multiple picklist.  As work around I may suggest running report against the workspace, open report in Excel and utilize the additional Filter options under Data Tab which include Filter for blank.

With your acceptance of solution I will now close this discussion. Please let us know if we may be of future assistance. Thank you

[mpasumarti]

Submitted an idea in IdeaStation as you suggested.

https://forums.autodesk.com/t5/fusion-lifecycle-ideas/filter-options-on-paragraph-and-multi-select-p...