topic Re: Searching by Bind Variable in Open Q&A

Searching by Bind Variable

KVZ — Wed, 15 Jun 2022 06:11:49 GMT

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?

Re: Searching by Bind Variable

AntonioSousa — Tue, 14 Jun 2022 20:32:24 GMT

@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

Re: Searching by Bind Variable

techean — Wed, 15 Jun 2022 06:06:38 GMT

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

Re: Searching by Bind Variable

Babar_Qayyum — Mon, 15 Dec 2025 06:39:21 GMT

Dears @AntonioSousa & @KVZ

Is there any update regarding this matter?

Regards,

Babar Qayyum

Re: Searching by Bind Variable

Julius_Loman — Mon, 15 Dec 2025 07:16:56 GMT

@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.

Re: Searching by Bind Variable

Babar_Qayyum — Mon, 15 Dec 2025 08:37:01 GMT

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

Re: Searching by Bind Variable

Julius_Loman — Mon, 15 Dec 2025 09:02:52 GMT

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.