Want to know about how to find a matching string in find browse form


Hi every one,

I got a requirement like I have different group of regards in a find browse form. I the same group of records are present more than once then record should not be repeated in the grid but the record must be counted and display count in the same grid. For better understanding please find the attachment.

Any inputs are highly appreciated.

Thanks in advance


  • Untitled.jpg
    76.1 KB · Views: 16

you can do it in 2 different ways:
1) Do the standard E1 view (use distinct mode and the set of index must be on the same field). Then add to the application new numeric field and add the logic for counting.
2) Use the DB view as fake table and do the counting directly in this view. It´s faster and you don´t need to add indexes on table. This fake table you add to standard E1 view.