PR #118: This was my initial pull request where I established join operations for tables and implemented metadata for wavelength and detector for remote sensing instruments.

2. Gallery Examples and How-to Guide for recent implementations(merged):

PR #127: In this pull request, I added gallery examples and a how-to guide showcasing the newly implemented wavelength and detector metadata.

3. Error Handling for SOAR Server Downtime(merged):

PR #135: This update involved catching server errors thrown by SOAR when it’s down, enhancing the robustness of the system.

4. Distance Filtering Query Support(merged):

PR #137: I added support for a new query method, REQUEST="doQueryFilteredByDistance", enabling distance-based filtering for queries.

5. Observation Mode Metadata (Not Yet Merged):

PR #140: This pull request introduced Observation Mode as a new metadata. After discussions with my mentors, we decided not to merge this feature for now.

6. Field of View (FoV) Values Extraction(Not yet merged):

PR #143: I added a third join table to extract Field of View (FoV) values with “earth” and “sun” references, allowing users to plot these on a SunPy map.

7. Developer Guides for Future Development(Not yet merged)

PR #147: This pull request added a section of developer guides designed to assist future contributors in developing sunpy-soar.

8. External Method for URL Construction (closed):

PR #129: This pull request proposed using an external method for making URL calls instead of manually constructing them. However, after further discussion with my mentors, we realized this approach could limit our ability to add future functionality, so we decided not to close it.