i have like this data in bd based for one cif we may have multiple child request id
i have to show the data in editable grid like below
Discussion posts and replies are publicly visible
OK. What is your question then? Are stuck with any specific detail? Can you share your current implementation?
to show the data in grid like this how can i query? need to use any aggregation query or normal query with filters
1. Do you want to display data of particular Source Row Id, then use filter in the query and get the data and display.
2. If you want to display all the source row ids and its child data, then directly query data and display in the grid.
I do not see any aggregation in your SQL, so a normal record query, filtered by CIF and SOURCE_ROW_ID, should do it.
Hi KM ,
Do you want to group the child request id column?
SQL - Use group by function
In Appian - use queryaggregation function
Hi KM based on your SQL query, you don't have to use any aggregation, a!queryFilter() would works well in this case with an AND operator inside the LogicalExpression