nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

PerformerID in dauditnew table

Frank_Early

Is PerformerID in dauditnew table is a unique id for a user?The reason I'm ask is we'd like to pull out the date information of a user when they last login.select performerid, max(auditdate) from dauditnew where auditid='23' and performerid in ('13616409') group by performeridMuch appreciate any inputs.Michael C

Find more posts tagged with

Comments

Greg_Griffiths_(ggriffiths_-_(deleted))

If you get a copy of the Database Schema from OpenText, via an NDA you will see that the column is a foreign key to KUAF so should do what you want from your sample query, although the GROUP BY and the IN components seem a little useless if you are only looking for one user.