How can I search a BAQ by one of it's calculated fields

Epicor ERP 10
1

Hello,

One of my BAQ combo does not work anymore, I verified and the BAQ name has been deleted!! (I did not remove this… someone must have)

So I have the field (Calculated_PO) but no BAQ to reference it.

I have over 500 BAQ’s…to search into. I do not remember which one is the right one.

Would it be anyway to search the BAQ by searching for the word ‘Calculated_PO’?

thank you

2

Hi @Hogardy. Try the attached BAQ.
SpecWordInQueryPhrases.baq (12.2 KB)

3

Thanks but it seems not working well for some reason.

I even tried the query in MSSQL

select * from [Polymos-Prod].[Ice].QueryHdr
where DisplayPhrase like ‘%Calculated_PO%’

It gave me a result of 50 queries. But looking into 2 of them, searching for the wordings I could not find the wordings Calculated_PO…

AS if the like did not work properly…
Got similiar results using your BAQ…

I am flabergasted! I do not understand why it gave me results and then looking into it it is not there !

Pierre
EDIT: Stupido of me… I was looking for the Full wording… not part of it… into my Notepad++…
It works ok now…

Thanks a lot for this! Found it!

4

Someone’s played this game before… :rofl: