Skip to main content
R
Rob
November 9, 2021
Solved

Clear data on Origin Forms

  • November 9, 2021
  • 3 replies
  • 0 views

Does anyone have a piece of code to clear data on the origin Forms member for just a few accounts? The api.data.clearcalculateddata is not possible (data is not calculated) and api.data.setdatacell doesn't work. Thanks. 

    Best answer by ChristianW

    You can combine calculate with clearcalculateddate like this:

    Dim script as string = pov

api.data.calculate($"{script} = 0 * {script}")

api.data.clearcalculateddata(script)

    The first row will make it calculated, the second row will delete it, because now it is calculated.

    3 replies

    C
    ChristianWAnswer
    November 9, 2021

    You can combine calculate with clearcalculateddate like this:

    Dim script as string = pov

api.data.calculate($"{script} = 0 * {script}")

api.data.clearcalculateddata(script)

    The first row will make it calculated, the second row will delete it, because now it is calculated.

    P
    poswald
    November 22, 2021

    I've tried this, but I'm not following how to do this.  I have several accounts where I only want to clear the Forms data.  

     

    I need the forms data cleared for all the accounts where Text 8 Startswith VarPercentofSales

    This was the code I tried:

     

    Dim script As String = "A#All:F#EndBal_Input:V#Periodic:O#Forms:U1#Local_Input:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None.Where(Text8 Startswith VarPercentofSales)"

    api.data.calculate($"{script} = 0 * {script}")

    api.data.ClearCalculatedData("TRUE","TRUE","TRUE","TRUE","A#IncStmnt.Base.Where(Text8 Startswith VarPercentofSales)",,"O#Forms",,,,,,,,,)

     

    C
    ChristianW
    November 25, 2021

    The script and the syntax is not correct, try this:

    Dim script As String = "A#All"

api.data.calculate($"{script} = 0 * {script}","A#IncStmnt.Base.Where(Text8 Startswith VarPercentofSales)",,"O#Forms")
api.data.ClearCalculatedData(True,True,True,True,"A#IncStmnt.Base.Where(Text8 Startswith VarPercentofSales)",,"O#Forms")

     

    R
    RobAuthor
    November 9, 2021

    Thanks Christian, tested this and works as expected. 

    E
    EricOsmanski
    November 19, 2021

    Can also use the below where amount is 0.0 and isNoData is True.

    api.Data.SetDataCell(memberScript, amount, isNoData, isDurableCalculatedData)

    Terms & ConditionsAccessibility statement