AQL query on attribute "Serial Number" outputs nothing !

[adrien miniere]

Hello,

I habe configured some object type with following attributes (among others):

	Id		Name	Description	Type	Type Value	Additional Value
	2681		Device Name	The name of the object	Default	Text
	2765		Device Type		Default	Text
	2766		Model		Default	Text
	2688		Serial Number		Default	Text
	2767		Device Infos		Default	Text
	2689		Network		Object	Reference

When executing a query like:

"Device name" LIKE 0234 , the query outputs the expected items

When executing a query like:

"Serial Number" LIKE "Q3", the query outputs nothing.

Even if I input:

"Device name" LIKE 0234 AND "Serial Number" != hello

I don't get any output, while:

"Device name" LIKE 0234 AND "Device Type" != hello

works fine.

It seems that the particular attribute "Serial Number" bugs. Is there any reason? What do I do wrong?

Any hint would be great.

Regards

Adrien

[Joseph Chung Yin · Accepted solution]

@adrien miniere -

Can you provide some additional information on the actual object records?  (example the object where "Serial Number" that has Q3)

Afterward, we can suggest further recommendation on your AQL.  In general since the "Serial Number" is a "text" attribute, then your AQL should works.

https://support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[adrien miniere]

Hi Joseph,

for security reasons, I cannot provide too much infos, but I hope this screenshot will suffice.

Regards

Adrien

[adrien miniere]

@Joseph Chung Yin, in that case, this was the output of the AQL:

"Device name" LIKE 0224 ORDER BY "Device Name" ASC

Regards

[adrien miniere]

by the way, the issue arises also when I use the basic search (so without advanced search AQL). This is why I wondered if there is a particular issue with the attribute name "Serial Number"

On the attached screenshot, the basic query was executed one time, without results, and I displayed the search filter again for the screenshot.

[Joseph Chung Yin]

In your image - testing with Serial number you have "Q2J".  However your object example is showing with "Q2F...".

Can you try to test your AQL against Serial Number of just "Q2"?  I believe there may be typo in the AQL search.

Best, Joseph

[adrien miniere]

done :-)

[Joseph Chung Yin]

@adrien miniere -

It is very odd.  At this time, I believe the best course for you is for you to contact Atlassian Support (https://support.atlassian.com) for further assistance, so they check on the system side to determine if there are anything captured in the logs.

Sorry.

Best, Joseph

[adrien miniere]

OK, ticket submitted. Thanks for your support however.