Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,276
Community Members
 
Community Events
176
Community Groups

Insight 6.1.3 iqlFunction returning nothing

Hi, we're using Insight to connect to an Active Directory and read all users details, in a schema named "Users AD". We also have a custom field in JSD named "Reporter details", which links the Insight object from schema "Users AD".

One of these details we read are "title" and "description".

We need to have a filter for priority tickets opened by Managers.

So, we have the following JQL:

project = DVCOR AND cf[10800] in iqlFunction("Users AD", "title like \"Manager\"")

However, nothing is shown, even though there are several tickets created by users who are Managers indeed.

Any hint or idea why is this not working? should be pretty straightforward...

Thanks!

1 answer

2 votes

Hi.

   Can you try:

project = DVCOR AND cf[10800] in iqlFunction("objectType=\"UserObjectType\" AND title like Manager")

Please replace UserObjectType with the corresponding objectType you use to populate the CF with.

Note that both Attribute Name and Attribute Value are case sensitive.

Kind regards,

Yinon

Team Riada

   

Hi @Yinon Negev 

Insight created a lot of "object types", one per OU. I tried with the OU the user Gerente belongs to, but again, no results:

project = DVCOR AND cf[10800] in iqlFunction("objectType=\"GTD Teleductos\" AND title like Manager")

And GTD Teleductos is the right name:

About this Object Type

Id 178

Name GTD Teleductos

Hi.

   Can you try by removing the IQL Filter Scope in the CF configuration, and adding it to the Filter Issue Scope in the same configuration, using AND?

Kind regards,

Yinon

Team Riada

Hi Yinon,

Actually the provider came up with the solution:

project = DVCOR AND cf[10800] in iqlFunction(title like Manager)

So I guess... i'd appreciate some confirmation/explanation... I guess the customField somehow defines the ObjectType(s) since that cf points to an schema of Active Directory Users, where each different OU in the AD domain is a different ObjectType...

Regards,

Thanks 

Some fields name doesn't work properly with some users request. As admin I can't reproduce the problem but to fix the user request I change the field name by cf[XXXXX] and it works :)

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events