Customer/Vendor Workflow Deficiency Fix
Problem
BC Customer/Vendor workflows require users to submit for approval before a restricted record is created for the customer/vendor.
Example
Even with Vendor Approval Workflows enable...
Query SqlJoinType Property: Anti Join
Based on current MS Documentation, Left-Anti and Right-Anti Joins are not supported. This would make life much easier...
Linking using Record ID
Because RecordId() is a system procedure and not an actual table field, users cannot cannot join data on Record IDs in reports/queries.
If this were a value stored as a system field (like Created/Modified User/Date-time), then these would be easier to achieve.
Adjust DataItemTableFilter handling in Queries
Currently, DataItemTableFilter applies after joining two different data items. The work around is to make your filters occur upstream from your joins; however, queries do not support multiple data items in parallel levels. This means there is a functional gap ...