Skip to main content
venkataharishd0002
venkataharishd0002
November 18, 2021
Question

Need Username while exporting data from Export Datastore Entity to Excel smart service

  • November 18, 2021
  • 3 replies
  • 0 views

Hi Team,

I'm fetching data from database using a storeprocedure. One field is fetching the user ID. While exporting that data into an Excel using Export Data Store entity to excel i want to show that field as username instead of user id. I'm already having a common rule to fetch the username based on User Id. So how can i achieve my requirement.

Thanks in advance.

    3 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 18, 2021

    That smart service is directly writing data from DB into Excel. AFAIK there is no direct way to inject some logic into that process. Maybe you could write the user names in a second step into an additional sheet and then add a lookup in Excel after the export.

    Writing that data to DB beforehand is no option?

    venkataharishd0002
    venkataharishd0002Author
    November 18, 2021

    Actually there is no option before DB, because that Datastore entity dependent on so many Process Models and Expression rules.

    From your above suggestion. Lookup in excel should done manually or any automated way. Because the users will download that excel from Interface. when they open they need to see the user names in one field rather than user id

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 18, 2021

    Why not just maintain a userId-userName lookup table in DB and use that in the stored procedure?

    Terms & ConditionsAccessibility statement