Print out the available entity sets under the SpiraTestEntities

Thursday, January 16, 2020
Avatar

Hi,

 

I am trying to find a command to list all of the available entity sets under the SpiraTestEntities entity container. I want to custom query for incidents and any associated incidents, I am assuming i will have to query for incidents and use a join with a query for the artifact links. I cannot find any documentation on this

2 Replies
Saturday, January 18, 2020
Avatar
re: ccox095 Thursday, January 16, 2020

Hello,

We don't have a listing in the application (yet), it's planned. For now if you display the dropdown of the list of entities in the custom reporting section, that has the current list.

Also we have this new blog on custom graphing that might be useful.

Regards

David

Monday, January 20, 2020
Avatar
re: inflectra.david Saturday, January 18, 2020

Thanks for replying David

I want to query for R_ArtifactAssociations but get an error that it is not defined.

aside from that issue, is it possible to call custom defined stored SQL procedure from the custom query section?

Statistics
  • Started: Thursday, January 16, 2020
  • Last Reply: Monday, January 20, 2020
  • Replies: 2
  • Views: 1002