After selection, selecting single row from the result set based on the condition.
Hi Everyone,
Scenario: I have loaded list of clients and their history related to the licenses purchased/renewed by them. When user selects any single client, then I am showing history table for the selected client, which may have single or multiple records related to all the licenses he has purchased/renewed in the history. Now from this result set, I want to select single row based on the condition. Condition may be like selecting a row from the result set where expiry date is yet to come, and if license was already expired then selecting a row from the result set where the license was expired most recently.
After this, I want to represent this row data in a various form. I hope I put the problem correctly. I dont know whether I have to use set analysis for this. Any help would be greatly appreciated. Thanks in advance.
