Skip to main content
Solved

The Automation Schedule History is showing 0 in Total Records

  • April 3, 2024
  • 3 replies
  • 265 views
  • Translate All

Forum|alt.badge.img

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

Best answer by Dmitrii Naumov

@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

View original

3 replies

Dmitrii Naumov
Community Manager
Forum|alt.badge.img+7

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

Translate

Forum|alt.badge.img

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

Translate

Dmitrii Naumov
Community Manager
Forum|alt.badge.img+7

@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

Translate