I have a Report Definition, where the query is built like below.
Select Column1, column2.. From Table TableName
Where UserID IN ('abc','def','ghl',.....,'xyz')
I have been provided some 150 UserIDs and i cannot type all of them inside the IN() for this clause. I have been instructed to consider using a Decision table above all. Is it possible to use a Decision table in this scenario ? What alternatives do i have ?
PS: I am using this Report Definition in an activity.
You can set all of the user ids on a value list property and then refer that property directly in the report definition. RD automatically understands if it's a value list property, it converts to IN clause.
Now that value list can be populated in any way since you are running an activity before.
Let us know if this helps or you need more information :)