Search Button Blank Title 129451

Yahoo Archive
1
Thank you Jose, Dan. That will work for me!! 
2
Hello group,
 I am in Vantage 8.03.409c. I need a search button in Miscellaneous Shipment Tracker to search for packnum and some other fields and return the results to the same form. How can i do this? Can anyone help me out. Thanks.
3

I am not sure what you are asking for.  That form already has a PackID search button.  So are you wanting to change the data results that you search for?  If that is the case then you can right click on the PackNum field and select “Quick Search Entry” at the buttom.  This will require that you set up a BAQ of the datset that you are looking for.  The Quick Entry Form allows you to make the Quick Search default.

 

I hope I was on the right path.

Dan

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sanjay219@...
Sent: Tuesday, April 08, 2014 11:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Search Button

 

 

Hello group,

 I am in Vantage 8.03.409c. I need a search button in Miscellaneous Shipment Tracker to search for packnum and some other fields and return the results to the same form. How can i do this? Can anyone help me out. Thanks.

------------------------------------------------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance. X3BTB534
4
You'll have to translate it to VB


string whereClause = "OrderHed.OrderNum="+edvShipHed.dataView[edvShipHed.Row]["OrderNum"];

System.Data.DataSet dsSalesOrderAdapter = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(Script.oTrans, "SalesOrderAdapter", out recSelected, false, whereClause);

if (recSelected)
{
System.Data.DataRow adapterRow = dsSalesOrderAdapter.Tables[0].Rows[0];
if((decimal)adapterRow["OrderAmt"] > 10000 && (bool)adapterRow["CheckBox09"]==false)
result=true;
}



Jose C Gomez
Software Engineer



T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Tue, Apr 8, 2014 at 2:11 PM, <sanjay219@...> wrote:

  
<div>
  
  
  <p>Hello group,</p><div>&nbsp;I am in Vantage 8.03.409c. I need a search button in Miscellaneous Shipment Tracker to search for packnum and some other fields and return the results to the same form. How can i do this? Can anyone help me out. Thanks.</div>


</div>
 


<div style="color:#fff;min-height:0;"></div>

5
Thank you Jose, 
 I need to see MscShpHd.Character01 too in my search results. How can I do that?
Thanks.
6
Private Sub btnEpiCustom1_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnEpiCustom1.Click
'// ** Place Event Handling Code Here ** 
Dim recSelected As Boolean
Dim whereClause As String = String.Empty
Dim dsMscShp As DataSet = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"MiscShipAdapter", recSelected, True, whereClause)
If (recSelected) Then
        messagebox.show("test")
End If
End sub
7
This part of the code (bool)adapterRow["CheckBox09"]==false gets you CheckBox09... so simply add another one like it to get the fields you need


Jose C Gomez
Software Engineer



T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Tue, Apr 8, 2014 at 4:28 PM, <sanjay219@...> wrote:

  
<div>
  
  
  <p></p><div>Private Sub btnEpiCustom1_Click(ByVal Sender As Object, ByVal Args As System.EventArgs) Handles btnEpiCustom1.Click</div><div><span style="white-space:pre-wrap;">		</span>&#39;// ** Place Event Handling Code Here **&nbsp;</div>
Dim recSelected As Boolean
Dim whereClause As String = String.Empty
Dim dsMscShp As DataSet = Epicor.Mfg.UI.FormFunctions.SearchFunctions.listLookup(oTrans,"MiscShipAdapter", recSelected, True, whereClause)
If (recSelected) Then
        messagebox.show("test")
End If
End sub

</div>
 


<div style="color:#fff;min-height:0;"></div>

8
Thank you Jose,
 Is there any way I could add character01 field in the search results when I search from the original PackID button in the Misc Shipment Form?

9
Not sure I understood that one....


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Wed, Apr 9, 2014 at 11:37 AM, <sanjay219@...> wrote:

  
<div>
  
  
  <p>Thank you Jose,</p><div>&nbsp;Is there any way I could add character01 field in the search results when I search from the original PackID button in the Misc Shipment Form?</div><div><br></div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>

10
Sorry Jose,
 The form already has a "PackID" button. I am trying now to change the search results when I click this button. By default it has columns/fields: PackNum, Ship Date, Order Num, CustID, CustName, PO, Entry Person, Supplier ID and Supplier Name as the Search Results. I need to add Character01 field too along with this search results.ie. the search results should look like this:
 PackNum, Character01, Ship Date, Order Num, CustID, CustName, PO, Entry Person, Supplier ID, Supplier Name
How can I do this?


11
Quick Search 
Write a BAQ

Right clikc on the fileld and Quick Search Entry . Make the quick search the default.



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Wed, Apr 9, 2014 at 11:58 AM, <sanjay219@...> wrote:

  
<div>
  
  
  <p>Sorry Jose,</p><div>&nbsp;The form already has a &quot;PackID&quot; button. I am trying now to change the search results when I click this button. By default it has columns/fields: PackNum, Ship Date, Order Num, CustID, CustName, PO, Entry Person, Supplier ID and Supplier Name as the Search Results. I need to add Character01 field too along with this search <a rel="nofollow" target="_blank" href="http://results.ie">results.ie</a>. the search results should look like this:</div>
 PackNum, Character01, Ship Date, Order Num, CustID, CustName, PO, Entry Person, Supplier ID, Supplier Name
How can I do this?


</div>
 


<div style="color:#fff;min-height:0;"></div>