Searching by Bind Variable

[KVZ]

We have a scenario where we want to see for example that an ID that has been inserted into a table and later needs to be deleted from that table.

The ID is seen as a bind variable, and I wanted to know if there's any way to search by this bind variable to see the different sql executions which used it?

[AntonioSousa · Accepted solution]

@KVZ,

I imagine you are a Managed customer, as SaaS customers don't have the option to get bind variables.

There is no current way that I know of to find bind variables by their value.

But I get your point, and I believe it would be a good product idea. You can create one in the Product Ideas: https://community.dynatrace.com/t5/Dynatrace-product-ideas/idb-p/DynatraceProductIdeas

[techean]

Yes @AntonioSousa  something like auto tag top queries with bind variable for advance filter search.

I believe @KVZ  definitely go ahead converting this to an idea

[Babar_Qayyum]

Dears @AntonioSousa & @KVZ 

Is there any update regarding this matter?

Regards,

Babar Qayyum

[Julius_Loman]

@Babar_Qayyum for SaaS this is certainly possible for DPS SaaS instances having traces in grail where you can query spans and filter on attributes, including bind variables.
For Managed, I don't think this is possible at the moment.

[Babar_Qayyum]

Hello @Julius_Loman 

I appreciate your thoughtful feedback. However, due to our managed setup, we are unable to take advantage of it.

Regards,

Babar Qayyum

[Julius_Loman · Accepted solution]

In Managed, I'd try to define a request attribute to get the value. However, it might not be easily possible. It depends on how your application code is structured.