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
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?
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
ty all for the responses!
You can with profiler but its hairy