PX formula not populating

I tried to use PXDBScalar and it doesn’t work:

 

        [PXInt]
        [PXDBScalar(typeof(
            Search<CycleDetail.cycleID,
                Where<CycleDetail.cycleMajor, Equal<cycleMajor.FromCurrent>,
                      And<CycleDetail.cycleMinor, Equal<cycleMinor.FromCurrent>,
                      And<CycleDetail.date, GreaterEqual<Current<AccessInfo.businessDate>>>>>,
                OrderBy<Asc<CycleDetail.date>>>))]
        [PXUIField(DisplayName = "Upcoming Cycle ID", Enabled = false)]
        public int? UpcomingCycleID { get; set; }
        public abstract class upcomingCycleID : BqlInt.Field<upcomingCycleID> { }

Any way of doing it would be appreciated

Hi ​@Eberen 

Generic Inquiries essentially pull data from the db and present them in a nicer UI.

An unbound field will show as NULL or 0.0 or 0 depending on if you have a PXDefault attribute on the field.

To calculate a field on demand in a GI, you should set the formula in the results grid.

Aleks 

Hi Eberen,

Based on my understanding of the PXFormula attribute, it may not work for your scenario.

The PXFormula attribute is designed to calculate a field’s value from other fields within the same data record. Additionally, it can update a value on the parent record if the DAC is related to another via the PXParent attribute.

However, in your case, I believe you’ll need to use the PXDBScalar attribute instead.

For more details about PXFormulaAttribute.

Thanks,
VardanV.

For PXDBScalar you can take a look above at what I’m using, but I get an error variable @P1 not found.

It looks like when it creates the sql query, it doesn’t declare that variable:

declare @P0 as int = 1034
SELECT
  /* SO.60.20.00, 16B08500 */
  TOP (201) [SeriesDetail].[SeriesID],
  [SeriesDetail].[SeriesRowID],
  [SeriesDetail].[Bookid],
  [SeriesDetail].[ShipDate],
  [SeriesDetail].[CycleMajor],
  [SeriesDetail].[CycleMinor],
  (
    SELECT
      TOP (1) [CycleDetail].[CycleID]
    FROM
      [CycleDetail] [CycleDetail]
    WHERE
      (
        [CycleDetail].[CycleID] = @P0
        AND [CycleDetail].[CycleMajor] = @P1
        AND [CycleDetail].[CycleMinor] = @P2
        AND [CycleDetail].[Date] >= @P3
      )
    ORDER BY
      [CycleDetail].[Date]
  ),
  (
    SELECT
      TOP (1) [CycleDetail].[Date]
    FROM
      [CycleDetail] [CycleDetail]
    WHERE
      (
        [CycleDetail].[CycleID] = @P0
        AND [CycleDetail].[CycleMajor] = @P1
        AND [CycleDetail].[CycleMinor] = @P2
        AND [CycleDetail].[Date] >= @P3
      )
    ORDER BY
      [CycleDetail].[Date]
  )
FROM
  [SeriesDetail] [SeriesDetail]
WHERE
  ([SeriesDetail].[SeriesID] = @P0)
ORDER BY
  [SeriesDetail].[SeriesRowID] OPTION (OPTIMIZE FOR UNKNOWN)