How to hide grid rows?

(0) Share

Report

Posted on by Community Member

Hi Im working on a problem in which im trying to hide the grid rows. The records are repeating and i want to remove the repetitive records but hiding the grid rows that are repeating.

I do not want to use group by. as it is causing disturbance somewhere else. and I cant add any other data source or query or view.

Currently i have an AOT query and have added my code of searching for the repetitive record in the ExecuteQuery() method of the data source in that query. But what to do after that.

Or if there is any other solution please tell..!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

XB 1,875 on at

Like (0)

Report

Are the records repeat on the table or when you add some datasource the grid repeat the lines?maybe your the link type of the DataSource is wrong.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

if you will not use GroupBy, that will not exclude Distinct records. Doing this manually by a loop will make it expensive in terms of form may take more time to load etc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi JBB thank you for the response, I have put an outer join between the both tables. the data source is a query. and in that query i have added 2 data sources .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Sohaib thank you for your word of advice. But right now i have this as an only solution.

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report

is there a join on a parend table?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes there is an outer join

Was this reply helpful? Yes No
Hajish 460 on at

Like (0)

Report

Is it solved?

Was this reply helpful? Yes No
Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

Could this be a solution?

Create a database view and do grouping to exclude duplicates, but don't summarize your numeric fields. Use min, max or mean to get wanted value.

Use this view as your data source in your form or if you need it to be a query because of publication through odata feeds, you can make a query of that view.

Was this reply helpful? Yes No