Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
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
