Advanced Search SugPODtl

Epicor ERP 10
,
1

Hello
I would like to create an Advanced Search that could be used in New PO Suggestions.

image
image996×473 26.7 KB

I know that I must to use Dashboard for it so I created BAQ and then attached it to my Dashboard but can’t choose SugNum in “Like” columns.
image

As you can see above BAQ has this field.

image
image864×741 24.2 KB

Has anyone this kind of issue? What’s the reason and is it possible to make this field available to choose?

2

Not 100% sure, but often these require the SysRowID

2 Likes
3

Sorry but I did not understand your answer @Jason_Woods.
Could you clarify?

4

Add SugPoDtl.SysRowID to the BAQ and advanced search.

Jason Woods
http://LinkedIn.com/in/jasoncwoods

5

I did it but it’s the same. Actually no column from SugPoDtl is available in Advance Search.

6

I ran a trace and it shows that it needs SugPoDtl.SugNum. However, that field doesn’t show in the Advanced Search area of the Dashboard. I would let support know.
Are you able to make this a Quick Search? Or, it may be possible to inject a record with a BPM on this method…

<tracePacket>
  <businessObject>Ice.Proxy.BO.DashBoardImpl</businessObject>
  <methodName>GetDashboardsWithLike</methodName>
  <appServerUri>https://ausmtsapp01.epicorsaas.com/SaaS203/</appServerUri>
  <returnType>Ice.Tablesets.DashBdDefListTableset</returnType>
  <localTime>6/24/2020 22:47:13:5203191 PM</localTime>
  <threadID>1</threadID>
  <correlationId>1ee315f8-7e02-473f-a6f4-30f7f6aaaf1e</correlationId>
  <executionTime total="175" roundTrip="170" channel="0" bpm="0" bpmDataForm="0" other="5" />
  <retries>0</retries>
  <parameters>
    <parameter name="productId" type="System.String"><![CDATA[EP]]></parameter>
    <parameter name="likeField" type="System.String"><![CDATA[SugPoDtl.SugNum]]></parameter>
  </parameters>
  <returnValues>
    <returnParameter name="returnDS" type="Ice.BO.DashBdDefListDataSet">
      <DashBdDefListDataSet xmlns="http://www.epicor.com/Ice/300/BO/DashBoard/DashBdDefList" />
    </returnParameter>
  </returnValues>
</tracePacket>
7

Thanks for quick response.
I did QuickSearch but they want more :wink:. It’s strange that columns from SugPoDtl are not available.

To be able to add QuickSearch I created temporary customization with textbox bounded to SugNum and then add QuickSearch.
After that it is visible in New Po Suggestions “Binoculars” search but only if the QuickSearch is set to Base Default.
image

Note it will not even appear down here if you won’t select Base Default.
image

A little off topic but maybe someone will find it helpful some day.

8

Yeah. It seem like this field isn’t setup the same as, say, Part.PartNum.

9

Great idea, and since I love necroposting, here’s an unconventional idea you can try. No warranties.

Ice.DashBoard.StoreData Pre-Proc method directive

var myid = "cc_posugg_search"; //your dashboard id here

var theRec = ds.DashBdLike.FirstOrDefault(f => f.DefinitionID == myid);
if(theRec != null) return; //our injected record already exists

var theDash = ds.DashBdDef.FirstOrDefault(f => f.DefinitionID == myid && !f.Deleted());
if(theDash == null) return; //where the hell is the dashboard?

var newrow = (DashBdLikeRow)ds.DashBdLike.NewRow();
newrow.Company = theDash.Company;
newrow.ProductID = "EP";
newrow.DefinitionID = myid;
newrow.LikeField = "SugPoDtl.SugNum";
newrow.RowMod = "A";

ds.DashBdLike.Add(newrow);

image
image1164×618 108 KB

It shows, it opens, it searches. I didnt get back a result yet but I havent played with it and it may be something silly (I am pretty sure I have SysRowID on there)

Either way, enjoy

1 Like