I have a secondary index defined for database. the secondary index has two fields Record number and date. Record number is also part of primary index.
The date is not always present in input so I need to get records that match record number. A search with Record number alone can get multiple records and same might happen when both record number and date are given. This is possible because record number has suffix which varies for multiple entries for a particular date.
I want to know how can i access database through secondary index/key when i only have record number. What do I need to specify for date so that I get all the record numbers?