Skip to main content
Solved

The Automation Schedule History is showing 0 in Total Records


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
Did this topic help you find an answer to your question?

3 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • 629 replies
  • 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
  • 21 replies
  • April 3, 2024
Dmitrii Naumov wrote:

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
  • 629 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings