Here is code that I worked with Epicor to use on a Button (Since quick search and BAQ search do not work). I put this in the script editor in my customization:
Private Sub btnSN10_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnSN10.Click
'// ** Place Event Handling Code Here **
Dim whereClause As String = "Number01 = '' AND Number02 = '' AND Date02 = ''"
Dim recSelected As Boolean
Dim dsUD04 As DataSet = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"UD04Adapter", recSelected, True, whereClause)
Dim edv As EpiDataView = CType(oTrans.EpiDataViews("ShipDtl"),EpiDataView)
'// If a rec is selected...
if recSelected then
edv.DataView(edv.Row)("Character03") = dsUD04.Tables(0).Rows(0)("Key1")
else
messagebox.show("Msg")
end if
end sub
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert Brown
Sent: Friday, July 13, 2012 9:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: 8.03.409a: UD table maintenance app search appears unable to utilize BAQ searches
Thanks Rob/Rick. You saved me a few hrs bumping my head against wall to no avail.
Only a few users involved, I found I can personalize the std search layout to only show the UD fields we really use... Annoying I can't save it as part of a general customization but it will have to do.
Thanks again.
Rob
________________________________
From: that_guyy <rbird@...<mailto:rbird%40rowmark.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Friday, July 13, 2012 9:20 AM
Subject: [Vantage] Re: 8.03.409a: UD table maintenance app search appears unable to utilize BAQ searches
FYI - In 9.05.700B2 - You can create the Quick Search and the Named Search as Default, but nothing works right. It takes 5 min or so for the Search window to open and even then the Search window is unresponsive. I have filed a call on this for 9.05.700B2.
Rick Bird
IT Software Administrator
Rowmark, LLC.
Private Sub btnSN10_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnSN10.Click
'// ** Place Event Handling Code Here **
Dim whereClause As String = "Number01 = '' AND Number02 = '' AND Date02 = ''"
Dim recSelected As Boolean
Dim dsUD04 As DataSet = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"UD04Adapter", recSelected, True, whereClause)
Dim edv As EpiDataView = CType(oTrans.EpiDataViews("ShipDtl"),EpiDataView)
'// If a rec is selected...
if recSelected then
edv.DataView(edv.Row)("Character03") = dsUD04.Tables(0).Rows(0)("Key1")
else
messagebox.show("Msg")
end if
end sub
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert Brown
Sent: Friday, July 13, 2012 9:32 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: 8.03.409a: UD table maintenance app search appears unable to utilize BAQ searches
Thanks Rob/Rick. You saved me a few hrs bumping my head against wall to no avail.
Only a few users involved, I found I can personalize the std search layout to only show the UD fields we really use... Annoying I can't save it as part of a general customization but it will have to do.
Thanks again.
Rob
________________________________
From: that_guyy <rbird@...<mailto:rbird%40rowmark.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Friday, July 13, 2012 9:20 AM
Subject: [Vantage] Re: 8.03.409a: UD table maintenance app search appears unable to utilize BAQ searches
FYI - In 9.05.700B2 - You can create the Quick Search and the Named Search as Default, but nothing works right. It takes 5 min or so for the Search window to open and even then the Search window is unresponsive. I have filed a call on this for 9.05.700B2.
Rick Bird
IT Software Administrator
Rowmark, LLC.
--- In mailto:vantage%40yahoogroups.com, Rob Bucek <rbucek@...<mailto:rbucek@...>> wrote:
>
> In 8 I struggled making a named or quick search on a ud table.. never got one to work
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
> [Description: cid:1.234354861@...]<http://www.dsmfg.com/>
> (Click the logo to view our site)<http://www.dsmfg.com/>
>
> From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Robert Brown
> Sent: Thursday, July 12, 2012 7:02 PM
> To: mailto:vantage%40yahoogroups.com
> Subject: [Vantage] 8.03.409a: UD table maintenance app search appears unable to utilize BAQ searches
>
>
>
> I've been out of the technical side for a few years now & there is probably a solution I've forgotton about.
>
> Simple UD01 table maintenance app which I wrote an equally simple BAQ I had hoped could act as a more focussed search out of the app - but it doesn't appear as available to create a Named (BAQ based) search I can set as the default. (SAme issue with Quick searches & a Dashboard I created to try an Advanced search.)
>
> Is this a limiation I have forgotton of the basic UD table maintenance app BO's or can it be overcome with some client customization code?
>
> Any thoughts appreciated.
>
> Thanks
>
> Rob Brown
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]