Izenda Reports 6.4: User Defined Constraints with Wildcards

(This is part of a series of posts on the new Izenda Reports 6.4, presently at the Release Candidate stage.)

New virtual constraints are easy to add in Izenda Reports. Complicated schemas no longer require extensive user education or the changing of database schemas. Virtual constraints allow Izenda Reports to know about any connections between tables. For example, users can even run reports on Sales Force databases without reshaping the schema. These may be required to use smart join.

AdHocContext.Driver.AddConstraint("Account.Id", "*.AccountID");
AdHocContext.Driver.AddConstraint("User.Id", "*.OwnerId");
AdHocContext.Driver.AddConstraint("User.Id", "Account.OwnerId");

You can try user defined constraints with wildcards on your data with a free trial of Izenda.