Adding a Detail Grid to Sales Category (IN204060) - Parent/Child Issue

Question

I am trying to add a detail grid tied to the selected sales category on the Sales Category screen (IN204060)

Created a DAC that holds the grid data:

public class INCategoryFilesCTC : IBqlTable
{
#region CategoryID
[PXDBInt(IsKey = true)]
[PXUIField(DisplayName = "Category ID")]
public virtual int? CategoryID { get; set; }
public abstract class categoryID : IBqlField { }
#endregion

#region Type
[PXDBString(1, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Type")]
public virtual string Type { get; set; }
public abstract class type : IBqlField { }
#endregion

#region NoteID
[PXNote()]
[PXUIField(DisplayName = "Price Source")]
public virtual Guid? NoteID { get; set; }
public abstract class noteID : IBqlField { }
#endregion

#region Uploaded
[PXDBDate()]
[PXUIField(DisplayName = "Uploaded")]
public virtual DateTime? Uploaded { get; set; }
public abstract class uploaded : IBqlField { }
#endregion

#region FileName
[PXDBString(50, IsFixed = true, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "File Name")]
public virtual string FileName { get; set; }
public abstract class fileName : IBqlField { }
#endregion
}

Then added a data view delegate select (was having issues with Current<> due to the non standard selects for the rest of the graph data)

        public PXSelect CategoryFiles;
    protected virtual IEnumerable categoryFiles()
    {
        var cache = Base.Caches[typeof(INCategoryFilesCTC)];
        cache.AllowInsert = true;
        cache.AllowUpdate = true;
        cache.AllowDelete = true;

        var select = PXSelect>>>.Select(Base,Base.Folders.Current.CategoryID).FirstTableItems;
        foreach (INCategoryFilesCTC item in select)
        {
            cache.SetStatus(item,PXEntryStatus.Held);
        }

        return cache.Cached;

    }

The grid lives inside of 1/2 of a split container, and inside a tab. Search for ID="WebFiles" ( is the half it lives in, figured I wouldn't drown you guys with aspx code, if you want the rest let me know)

When I select a tree element, if there are records that would show up in my custom table (tree element categoryID = grid record categoryID) I get the following error:

Error: an invalid argument has been specified
Parameter name selectParent

Absolutely nothing comes up in trace, and nothing comes up during debugging, so I am at a bit of a loss.

A few things:

The error goes away when I comment out my custom PXGrid, and I can use the screen normally even with the tabs and groups i have added
The error does not go away if i comment out the PXParent and PXDBDefault attributes on the grids CategoryID DAC Field
If there is no detail record for the selected tree choice, there is no error. If I make a record and save it, the error appears (with the inserted record now showing in the grid, and a saved detail record in the database table)

This lends me to believe something is happening on the select of the detail records. Any advice?

Thanks -Kyle

Adding a Detail Grid to Sales Category (IN204060) - Parent/Child Issue

Answers (1)

Related Questions