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; } } }

USER Activity Report help

no__longer_(nolonger1_-_(deleted))

I can get activity results (login) for a specifc user but for some reason I can not get correct results for my query on a specifc event (FETCH/VIEW). I know I need to join KUAF.ID to Daudit.UserID and then use Daudit.Event to test for a particular event. Iguess I am not good at joins. can anyone help???

Find more posts tagged with

Comments

I.S._Support_(bupauser3_-_(deleted))

JessicaNot sure what join you are after here, but I guess that you can use the followingselect * from KUAF a, DAudit b where a.id =b.UserID and b.UserID=%1 and b.Event like %2 ORDER BY AUDITDATE DESCParam%1 UserIDParam%2 EventYou will have to tune this a bit