• How do I set a where statement on a Query Definition against the current date the query is run?

    I want to only have it pull a specific relationship (Part AML) if a custom date field "Valid To" is greater than the current date. I am able to create the Where that compares it against a specific date, but this query definition is pulled by another process…

  • SQL in a TreeGridView

    I want to display the results obtained by SQL in a TreeGridView, but I want to implement it. QueryBuilder does not allow me to achieve this. Can I display TGV trees? I want to narrow down my search by conditional branching.