using the "Where" in distinct query

[Spark Chao]

Thanks!!!

[EJLD]

Hi There, thk you for this. it works well for me too in the service.
However, I'd like to write this distinct query as server code because I need to att'd to each distinct data from other tables via more queries.
May I ask you how would you make the "body" setting instead of "query" in the server code ?
thk you,
Eric

[EJLD]

Hi again, I found how to place the "where" in the "body" of the distinct query in server code. it works as expected. happy enjoy your week!