How to set an Assets custom field to filter based on another field OR on that field being empty?

[Evelyn Lewis]

I would like for a custom Assets field to display the assets available based on a previous field OR all assets if that previous field is blank.

E.g.

Assets Field 1 is CUSTOMER

Assets Field 2 is SITE

If CUSTOMER has an entry, SITE should only display in drop down the sites linked to that customer in Assets. Or, if CUSTOMER is empty, SITE should display every site available in the Assets schema.

Is this possible? Or is this going to require two fields for SITE? 

[Kai Krause · Accepted solution]

Hi,

i think actually there is no "fallback" for the placeholder functions, that does let you add a fallback that shows all objects when the placeholder is empty.

In the moment you use a placeholder (${Customer}) in the Filter Issue Scope, the query becomes invalid (and therefore returns zero objects) as soon as that placeholder has no value.

Filter Jira Assets Field Using Multiple Object References in Jira Cloud | Jira and Jira Service Management | Atlassian Support

You need two Site fields (one filtered, one unfiltered) and simple show/hide logic in Forms for the customer portal. 

BR
Kai

[Evelyn Lewis]

Hi @Kai Krause and @Marc - Devoteam

Thanks for your help! I figured that was the case.

Cheers,

Evelyn

[Marc - Devoteam]

Hi @Evelyn Lewis 

@Kai Krause is correct, there is no fallback option.

This as the 2nd field is based on the value provided in the 1st field.

If this has no value, no options will be shown, as none apply the the 1st required value.