/
Incoming User Assignments
Incoming User Assignments
- Devan Robertson
Owned by Devan Robertson
It is important that you always include tenantID in your WHERE clause. Not doing so will result in poor performance. WHERE tenantid = 'YOURTENANTIDHERE'
SQL
select
*
from
assignment as a
where
a.tenantid = 'YOURTENANTIDHERE'
and a.assignmentstate = 'Created'
and a.workgroup NOT IN ('System', 'Pending')
and a.createdatetime=:daterange
order by a.createdatetime desc
Change Log
| Date | Description |
|---|---|
| 7/23/2024 | Added create date filer |
, multiple selections available,
Related content
Resolved Disputes - Detail
Resolved Disputes - Detail
Read with this
Assignment Event
Assignment Event
More like this
Merchant Collaboration Details
Merchant Collaboration Details
Read with this
Assignments Report
Assignments Report
More like this
Resolved Disputes - Summary
Resolved Disputes - Summary
Read with this
Assignments Approaching Association Deadline
Assignments Approaching Association Deadline
More like this