Hi,
In JDBC aggregation query, I want to pass the some identity attributes and fetch the corresponding results through query. How can i achieve this in single account aggregation query.
use parameterized queries with aggregation functions like SUM, COUNT, AVG, etc., in combination with a WHERE clause.
Thanks for your reply.
Let me explain my usecase in detail, Usually for a single account aggregation, We use WHERE clause to pass native identity to fetch the single account aggregation. Here along with that, I need to pass some additional identity attributes to fetch the value from the target.
Can you share some example of passing more than one identity attribute in aggregation query.
You’re working on an aggregation query where ?, in addition to a primary identity (like user_id or account_id), you need to pass multiple identity attributes in the WHERE clause to filter and fetch the correct aggregated values from the target data.
@chandramohan27
you can use something like this for single account aggregation query
SELECT * from tabl_name where userid =‘$(identity)’
I want to use filter based on email address, Can I use something like this?
WHERE EMAIL_ADDRESS= ‘$(identity).EMAIL_ADDRESS’
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.