Migrating to new where options

[vikas-g2]

Hi,

We have been using a complex filter like this : "Date >= DateTime(#{from_date.strftime("%Y,%m,%d")}) AND Date <= DateTime(#{to_date.strftime("%Y,%m,%d")}) AND BankAccount.accountId == guid(\"#{account_id}\") AND Status == \"#{status}\"" for getting bank transactions.
I am trying to migrate to the new approach of providing where options.

opts = {
  where: {
    status: ['=', "AUTHORISED"],
    "BankAccount.accountId": ['=', '562555f2-8cde-4ce9-8203-0363922537a4'],
    date: from_date..to_date
  },
  unitdp: 4
}

@SerKnight, can you please confirm if this is the right approach? I couldn't find a similar example.

[github-actions]

PETOSS-343

[github-actions]

Thanks for raising an issue, a ticket has been created to track your request