I have a smart contract deployed that I use to store generic data. This generic data belongs to external parties and now they want to query the data which is easy given an ID for the array index and the right permissions. Amongst this, they now want to see all related transactions of said item in the array on the smart contract. I feel the structure of this simple implementation prevents me from doing what I require.
I require a way to search the blockchain for all transactions associated or related to a user id, a transaction id etc..
Questions, To be able to provide a deep level of information based on data stored in a smart contract do I need to create multiple separate smart contracts? Or Store data in a traditional database and reference a transaction?
Basically, I want a way to say a change was made in this transaction and the data was inputted on this date and then I can display this on a UI to the customer.