Filter Expression in DataUnit ExecuteMethodCommand
What is the correct syntax for the filter expression in the DataUnit method command used in BRAPi.Database.ExecuteMethodCommand()?
We are trying to filter on Flow member EndBal. The following syntax does not work:
MethodQuery: {FinRpt}{CorpEntity}{}{}{ACTUAL}{2024M1}{YTD}{True}{F#EndBal} results in the follwoing error:
| The expression contains invalid date constant '#End_Inp'. |
MethodQuery: {FinRpt}{CorpEntity}{}{}{ACTUAL}{2024M1}{YTD}{True}{WHERE Flow LIKE '%EndBal%'} results in the follwoing error:
| Syntax error: Missing operand after 'Flow' operator. |
{WHERE Flow = 'EndBal'}, {WHERE Flow IS 'EndBal'}, and other variations all result in the same syntax error.