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.
Discussion posts and replies are publicly visible
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?
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
Why not just maintain a userId-userName lookup table in DB and use that in the stored procedure?