Saved Traceability Query still shows up in list although deleted already

Description

I select this saved query:

And then I get this error:

So the query should not show up in the list anymore

Environment

None

Observations

None

Activity

Show:
Adrien Ragot (Play SQL / Requirement Yogi)
September 12, 2019, 11:06 AM

Hi all,

Just to be clear, this issue was resolved in the release published yesterday, 2.2.3.

I’m sorry for not communicating much but half the company is at the developer sessions at Atlassian Open in Vienna.

Best regards,

Adrien

Adrien Ragot (Play SQL / Requirement Yogi)
September 9, 2019, 5:36 PM

Hi Michael,

I've understood the problem. Sorry for not understanding earlier. It will be published with the next version, the list will be cleaned up from deleted queries.

Best regards,
Adrien

Michael Glatter-Götz
September 2, 2019, 6:01 AM

Hi Adrien, I now managed to get the query exectued - “select * from BANDANA where BANDANAKEY = 'com.playsql.requirementyogi.query.3'“ does not return any result. Problem still exists.

Augustine
August 21, 2019, 10:03 AM

I’ve similar issue. The deleted query is still appearing in the Saved Query combo box. Anyway to remove it properly?

Adrien Ragot (Play SQL / Requirement Yogi)
August 12, 2019, 4:07 PM

Hi Michael,

It can only happen in two situations:

  • Do you have a "key=..." parameter in the URL?

  • The data may be corrupted. We store those queries in JSON, it usually is a stable format, but maybe it was truncated or wrongly encoded the last time it was saved. Do you know whether it was especially long or did it have special characters?

I can build a tool to save the history of those configurations, but it won't recover your data. You can see your data in your database if you run the following query, and attempt to fix it manually, if it's only a missing quote or similar:

select * from BANDANA where BANDANAKEY = 'com.playsql.requirementyogi.query.3'

Does this query return your data?

Best regards,
Adrien

Resolved

Assignee

Adrien Ragot (Play SQL / Requirement Yogi)

Reporter

Michael Glatter-Götz

Labels

None

Participants

None

Components

Fix versions

Affects versions

Priority

Matter of weeks