Discussions

 View Only
  • 1.  Iterable Record Object

    Posted 11-07-2022 12:21
    I am using a Pipeline to search for records
    Get the value of a Formula Numeric Field
    Sum and write that value in another record.

    The error message I am getting is:

    Validation error: Incorrect template "
    {{b|sum(attribute='total_event_bom_item_sell_price')}}".
    TypeError: 'Record' object is not iterable



    I have successfully done this with other Formula Numeric Fields, so I am not sure why it would break for the same calculation somewhere else.

    I did open a Support Case but I have got Boston a bit flummoxed.   

    Any ideas?


    ------------------------------
    Don Larson
    ------------------------------


  • 2.  RE: Iterable Record Object

    Posted 11-11-2022 08:41
    Solved with the help of QB Support.

    It was a Pipeline architecture issue.    To sum the data from a Search, you cannot be in a loop under the Search.   The summation has to happen outside of that Search step.

    ------------------------------
    Don Larson
    ------------------------------