Forum Discussion

Tom_R's avatar
Tom_R
New Contributor III
3 years ago

Join Framework table data to Application table data using SQL

SOURCE: ONESTREAM CHAMPIONS Hi - I am trying to create a journal entry summary report, and am able to get most of my data from the application tables, however the created by, submitted by, etc user...
Data Integration
adykes's avatar
adykes
New Contributor III

Sorry, I have another question: In your code, you refer to "JStatus", but I am trying to connect the dots back to the database tables and JStatus does not seem to be a column in the Journal Header application table. FYI, I am trying to use this code to join the SecUser table with the DataEntryAuditSource application table, so I am tweaking the code slightly to fit my purposes, hence the question 🙂 

Krishna's avatar
Krishna
Valued Contributor
3 years ago

The Jstatus see below which is the Journalstatus column in the DB Tables JournalHeader and I am loading into the Datable of JSTATUS. Make Sense ?

 

ASQL.AppendLine("Select Case When JournalStatus = 4 Then 'Posted' Else 'Unposted' End AS JStatus,
PostedUserID From JournalHeader")

  • adykes's avatar
    adykes
    New Contributor III
    3 years ago

    I understand, thank you!