Skip to main content
Answer

The Automation Schedule History is showing 0 in Total Records

  • April 3, 2024
  • 3 replies
  • 189 views

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

3 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • April 3, 2024

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • April 3, 2024

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


Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • Answer
  • April 3, 2024

@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