Forum Discussion

Yaseen's avatar
Yaseen
New Contributor III
2 years ago

Error using Where clause with 'or' condition inside GetDataBufferUsingFormula

Hello -   is there a way to make the below work inside GetDataBufferUsingFormula . Getting Error processing script 'V#Periodic:F#EndBal_Input:A#:U1#USF02'. Dim SrcDataBuffer As DataBuffer = api.D...
Finance
  • EricOsmanski's avatar
    EricOsmanski
    2 years ago

    Try this removing the square brackets from around the member name, so you don't have 2 sets.

     

    Dim SrcDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(V#Periodic:F#EndBal_Input:S#Actual:T#" & sLastActMth & ":U1#" & mCostCenter.Member.name & ",[A#PNL.Base.Where((Name StartsWith '4') or (Name StartsWith '5') or (Name StartsWith '7') or (Name StartsWith 'X'))], [U3#TopUD3.Base],[U2#TopUD2.Base])").

MikeG's avatar
MikeG
Contributor III

Hi Yaseen just for my sanity, can you confirm if in the StartsWith condition that '4' and 4 without the single quotes works?  It won't throw an error, but I believe the quotes are not needed even for a string condition check.

Yaseen's avatar
Yaseen
New Contributor III
2 years ago

Hi Mike- Yes, works with out single quotes as well. thanks!