Solved

The Automation Schedule History is showing 0 in Total Records

  • 3 April 2024
  • 3 replies
  • 35 views

Userlevel 2
Badge

Hi,

I created a custom processing screen and is working as expected. I configured an schedule and is running fine, but in the Automation Schedule History window the total records always is zero.

For the DAC I’m using an SQL View. 

public class NewWindow : PXGraph<NewWindow >
{
public override bool IsDirty => false;

public PXFilter<Filter> filter;

public PXCancel<Filter> Cancel;

[PXFilterable]
public PXFilteredProcessing<
ShipmentToProcess,Filter,
Where<ShipmentToProcess.processflag,Equal<Current<Filter.processflag>>>>
Document;

public NewWindow ()
{
Document.SetProcessCaption(PX.Objects.IN.Messages.Process);
Document.SetProcessAllCaption(PX.Objects.IN.Messages.ProcessAll);

}

public void _(Events.RowSelected<Filter> e)
{
IUtilService serv = new UtilService();

//inside this method I set the PxProcessing<class>.SetError or Info ...
Document.SetProcessDelegate(list => serv.ProcessShipment(list));
}
}

Acumatica 2023 R1

 

Thanks,

EV

icon

Best answer by Dmitrii Naumov 3 April 2024, 21:53

View original

3 replies

Userlevel 7
Badge +5

Make sure your DAC contains NoteID field. Scheduler uses it to identify rows that were processed.

Userlevel 2
Badge

Make sure your DAC contains NoteID field. Scheduler uses it to identify rows that were processed.

Hi,
My DAC reference an Sql view and this reference tables from others databases. I added the cast(null as uniqueidentifier) NoteID, to my view but is not working. 

 

Also add the property to the DAC.

public abstract class noteID : BqlType<IBqlGuid, Guid>.Field<noteID>
{
}

[PXNote()]
public virtual Guid? NoteID
{
    get;set;
}

Thanks,

EV

Userlevel 7
Badge +5

@edsonvelez64 it must not be null.

 

I’d say map it to some of the underlying DACs NoteID. 

 

Also, I must note that SQL views are not recommended. Use PXProjection instead 

https://help.acumatica.com/(W(20))/Help?ScreenId=ShowWiki&pageid=5d9021cb-f014-4607-896a-bd709b74cfff

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved