How to insert into custom table

Question

I have a customization to the Invoice and Memo screen, where I have a completely custom table to which I want to write an error log entry. Since this doesn't really fit with how the training addresses the issue - is there a way to do this directly? I noticed that there's a PXInsert<> command - but there's no documentation that I could find, either in the Framework help, or here on Stack Overflow.

I know I can create a Cache object for my custom table's DAC and use the Insert command of that Cache - but I don't know the exact syntax for doing that (and I couldn't find a good fit for what I'm trying to do in the training manuals). Maybe I missed it.

Answer 1

The syntax to create a Cache object (or I think you might be thinking of a graph) is to use PXGraph object. Here is an example:

private void Function()
{
  //TargetGraph is the name of the custom page
  TargetGraph graph = PXGraph.CreateInstance<TargetGraph>();
  //TargetDAC is the name of the custom DAC in your customizations
  TargetDAC dac = new TargetDAC();
  //Set all data to dac
  dac.Log = log;
  //Finally insert and perform the save action for the graph
  graph.LogView.Insert(dac);
  graph.Actions.PressSave();
}

Perhaps someone could add to this answer on how to grab the errors from the page if that is also what you need.