Can an Expression rule be used with a query entity to process the data before output?

I am using a process model to export data from the database to a spreadsheet. I am not using the export in the record type, just to be clear. When selecting the fields using the a!querySelection -> a!queryColumn, this immediately pulls the data and exports to a new spreadsheet, with no way of adding code to process it. If I have a CDT that has, for example, twenty fields, and one of those fields contains an employee ID. How can I, or is it even possible, to use an expression rule that takes an ID parameter, and outputs the actual employee name? There doesn't seem to be a path forward on this. I've looked through the process model, all the different query types, etc., but no way to pull the data, then process that data, before outputting to the spreadsheet.

Just to make sure this is clear, I already have the expression rule to process the data, I just have nowhere to do it and if there is a way to do it, I have not found it.

Any help will be greatly appreciated. 

Thanks.

  Discussion posts and replies are publicly visible

Parents Reply
  • I apologize, but again, I have some more questions:

    1. Will I need to break up the CDT into several to do this?
    2. Will the querySelection -> queryColumn -.> object need to separated out as well?
    3. Where in this process am I able to process some of the fields, such as the IDs -> Names and also descending order by date? It seems like it would be an issue if I added the columns at separate intervals.
Children