How to know what sql execute Base Search?

Hi Everyone,
I have a little Issue, want to see the SQL or BAQ that executes some Basic Search, exactly on “New Po Suggestion” Search. Anyone has idea how to do?

Regards.

Daniel

SQL Profile will help with this, but its a big rabbit hole you are going down into. What’s the end goal?

1 Like

Sometimes enabling Tracing will show the parameters passed into the search…

I tried SQL Profiler, but gime a lot of querys and internal querys for row information, dont apply for my issue.

End goal is to know aprox whats is going to do the filters on teh Base Search, where go to query that.

i will try

At the end i find whats the problem. The Requisition (im searching requisitions, filter on Sort By “Requisition”) was entered on another plant, and the filter plant is filled automatically. that filter the requisition i search…

now i have no problem… but im curious and want to know how can i search whats the query that base search executes, is not a BAQ?

No it is not always a BAQ it is likely some back service

ok, so not ever can see what is the query, atleast i resolve the problem setting empty the Site Filter :slight_smile:

ty all for the responses!

You can with profiler but its hairy