How to show a particular record at the first record of the table always?


  • I have an Entity A inwhich there are like 1000 records. There is an Entity B and One of the column in Entity B is domain based for Entity A. So, when user click that column in Entity B, it opens a window in which user can select  any of the 1000 records. Here, i have a requirement like, when the window opens, i want 'a particular record to show at the top' from Entity A. How can i do that? That record is a frequently choosed record and hence i want to show that record at the top , so that users no need to find that record by scrolling down to 1000 records. Please help me on this. i can't use sort ascending or  descending in the prestg tables or in the stored prcedures because if we use that then that record will go somewhere in the middle - pleas help!
    Tuesday, April 16, 2019 5:06 PM