Loading...

Accessing Arguments

How to access

To access the arguments passed to the executed object (SQL Script, Report, etc), you can use the Context.Arguments API.

namespace Local
{
using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Profitbase.Invision.Scripting.Dynamic;
public class MyMacros : MacroExpansionProvider
{
public string CheckArguments()
{
// will throw invalid cast exception if @EmployeeID cannot be cast to int
if(this.Context.Arguments.TryGetValue<int>("@EmployeeID", out int employeeId))
{
// do something with employeeId
}
if(this.Context.Arguments.TryGetValue("@ManagerID", out object managerId))
{
// do something with Manager ID
}
// Check if the @CustomerID was passed
bool customerIdExists = this.Context.Arguments.Contains("@CustomerID");
// will throw if KeyNotFoundException if @SalesRepID does not exist.
// will throw invalid cast exception if @SalesRepID cannot be cast to string
var salesRepId = this.Context.Arguments.GetValue<string>("@SalesRepID");
object objValue = this.Context.Arguments.GetValue("@SomeObjectID");
return string.Empty;
}
}
}