Search found 4 matches
- Fri Jun 03, 2016 2:13 pm
- Forum: Integration Development
- Topic: Joins on RequestedTask, SecurityIdentity, and Task table
- Replies: 4
- Views: 831
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...
- Thu Jun 02, 2016 12:49 pm
- Forum: Integration Development
- Topic: Joins on RequestedTask, SecurityIdentity, and Task table
- Replies: 4
- Views: 831
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...
- Thu Jun 02, 2016 10:52 am
- Forum: Standard/Enterprise Development
- Topic: Joins on RequestedTask, SecurityIdentity, and Task table
- Replies: 2
- Views: 3896
Re: Joins on RequestedTask, SecurityIdentity, and Task table
In addition, is there an easier way to include profiles based at the parent level?
- Thu Jun 02, 2016 10:47 am
- Forum: Standard/Enterprise Development
- Topic: Joins on RequestedTask, SecurityIdentity, and Task table
- Replies: 2
- Views: 3896
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...