problem description
the result set data obtained from a requirement query database is not complete. Use the id in the result set to query data from other systems to supplement the complete data to the dataset. This dataset needs to support multi-conditional data retrieval after it is given to the front end. The problem is that it is OK to use id to retrieve data in my result set, but what should I do when id goes to the data queried by other systems as a retrieval condition? At present, there is less data, the result set data will not exceed 1000 (only ID is unchanged, the data checked by other systems according to ID will change, so my table will not be stored permanently)
what methods have you tried
prepare to put the result set into an array, and then filter the data according to conditions, each conditional filtered data is put into an array, and finally find the intersection and difference of all the data in the array, so that it is good to have less data, but not if you have more data.