whereClause JobHead issue

Epicor ERP 10
1

It’s been one of those days and I’m sure I just need to walk away from this for a minute but does anyone have any idea why this whereClause for JobHead :“Company=‘BWF’ and JobType=‘MFG’ and JobClosed=‘FALSE’” would return results with jobs that were closed? If I leave the JobClosed parameter out it returns all manufactured jobs. Just for the record, I’ve also tried FALSE, false, ‘false’, and 0 and all have returned the same thing.

2

For false, you do not need quotation.

Try JobClosed=false

Here is a trace of mine.

<parameter name="whereClause" type="System.String"><![CDATA[((Inactive = false) AND (SystemTranID = 'StockStock'))]]></parameter>
1 Like
3

Thanks for the reply. I’ve already tried false with the same results.

4

Can you show me the full code? Are you doing it in customization?

5

Just a small external interface that needs to display a list of open jobs in a combobox:

Erp.Proxy.BO.JobEntryImpl _job = WCFServiceSupport.CreateImpl<Erp.Proxy.BO.JobEntryImpl>(epiSession, Epicor.ServiceModel.Channels.ImplBase<Erp.Contracts.JobEntrySvcContract>.UriPath);

bool outBool;
JobEntryDataSet jed = _job.GetRows(“Company=‘BWF’ and JobType=‘MFG’ and JobClosed=false and JobReleased=true”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, “”, 100, 0, out outBool);

jobCB.DataSource = jed.JobHead;
jobCB.DisplayMember = “JobNum”;
jobCB.ValueMember = “JobNum”;

6

Thanks for the help. As it turns out my code was pointing to our test system (smart) but I’ve been comparing the results against our production system (less than smart). All sorted out now.

1 Like