Skip to main content
Answer

Process screen: Selected line updates with data from first line RQRequisitionLine

  • September 29, 2025
  • 1 reply
  • 70 views

Forum|alt.badge.img+1

When I select a line in my process screen, the selected line is updated but its values get replaced with data from the first RQRequisitionLine.

I know this happens because RQRequisition only has ReqNbr as a key, but not LineNbr. Unfortunately, I cannot add LineNbr as a key in my projection.

How can I make the grid work so that when I check Selected, only the Selected field changes, and the rest of the data for that row does not get overwritten from the first line RQRequisitionLine?

[Serializable]
        [PXCacheName(Messages.RQRequisitionLineOwned)]
        [PX.TM.OwnedEscalatedFilter.Projection(typeof(RQRequisitionLineSelection), typeof(RQRequisition),
            typeof(LeftJoin<RQRequisitionLine, On<RQRequisitionLine.reqNbr, Equal<RQRequisition.reqNbr>>>),
            null, typeof(RQRequisition.workgroupID), typeof(RQRequisition.ownerID), typeof(RQRequisition.orderDate))]
        public class RQRequisitionLineOwned : RQRequisition

my virtual Dac is Projection.
I can’t set key value to RQRequisition.reqNbr and RQRequisitionLine.lineNbr because i must view records with RQRequisitionLine and without. Help me please

Best answer by bihalivan15

The problem was in the incorrect key fields.

1 reply

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Answer
  • November 24, 2025

The problem was in the incorrect key fields.