IQL - Filter Object Question

[Attila Gillioz]

Hi,

I'm new to the IQL syntax.

And i wanted to know : How to give the user only the rooms that are in the building he has selected using the IQL Filter objects.

Thanks for your respond :)

[Björn Gullander]

Hi, 

You should be able to do this by using a placeholder in the IQL filter. 

In the configuration for the Salles attribute, you can add the following IQL: 

Ecole = ${Ecole}

The left hand side of this condition should be the attribute name for the School reference in the Salles object type. 

The right hand side will insert the School you have selected in the object you are editing/creating. (Selecting no school and you will get no room to select.)

[Attila Gillioz]

Hi,

Thanks for your reply but it's not working.

When i try to Creat an object and I select the School then the Room. The filed say "No Matches"

[Björn Gullander]

It should work... :)  Please double check the requirement for this to work: 

• Salle object type has an object attribute Ecole which keeps track on which school each room is located
  • This attribute is filled in for the rooms 
• PCP contains object attributes for both Salle and Ecole. 
• Salles attribute in PCP object type has IQL filter Ecole = ${Ecole}

Björn

[Attila Gillioz]

Yes,

• Object type Salle has an attribute that links it to Ecole. And Say which room goes to which school (first picture).
• PCP has Salle and Ecole that need to be fill in. (second picture).
•  And the attribute Salles in PCP has the IQL filter Ecole = ${Ecole}. (third picture).

[John Funk]

Hello Attila - Welcome to the Atlassian Community!

You cannot do that natively in Jira Cloud. You can have nesting/dynamic field values using an add-on like ProForma Forms. 

[Attila Gillioz]

Hi,

Thanks for your quick repsond !

I just finishied work :( I'll tried your solution ASAP