Search found 4 matches

by WNCWSupport
Fri Jun 03, 2016 2:13 pm
Forum: Integration Development
Topic: Joins on RequestedTask, SecurityIdentity, and Task table
Replies: 4
Views: 820

Re: Joins on RequestedTask, SecurityIdentity, and Task table

To display the information you want, you would need to change your query. Instead of using MAX on the date and grouping by the completed by full name, you would need to do sub queries or temp tables to get the ID of the max task record for each task description for the order . Then you would need t...
by WNCWSupport
Thu Jun 02, 2016 12:49 pm
Forum: Integration Development
Topic: Joins on RequestedTask, SecurityIdentity, and Task table
Replies: 4
Views: 820

Joins on RequestedTask, SecurityIdentity, and Task table

Hello, Hope I can get some assistance from someone as I'm trying to create a small dashboard report for our post closing employees based on 6 checklist task-Completed date and 1 requested task-Requested Date.. The issue I'm having is joining the security identity table with checklist task and reques...
by WNCWSupport
Thu Jun 02, 2016 10:52 am
Forum: Standard/Enterprise Development
Topic: Joins on RequestedTask, SecurityIdentity, and Task table
Replies: 2
Views: 2643

Re: Joins on RequestedTask, SecurityIdentity, and Task table

In addition, is there an easier way to include profiles based at the parent level?
by WNCWSupport
Thu Jun 02, 2016 10:47 am
Forum: Standard/Enterprise Development
Topic: Joins on RequestedTask, SecurityIdentity, and Task table
Replies: 2
Views: 2643

Joins on RequestedTask, SecurityIdentity, and Task table

Hello SoftPro, Hope I can get some assistance from you as I'm trying to create a small dashboard report for our post closing employees based on 6 checklist task-Completed date and 1 requested task-Requested Date.. The issue I'm having is joining the security identity table with checklist task and re...