lavatory | Tooling to define repository specific retention policies

As we are dealing with an id tag there is no need to use contains, you should search the XPath for the element that matches the id tag you are looking for:

Here is code you can try. I don't see a FLDeptName node in the XML, so I commented the lines related to that node.

The default value for the :test keyword argument in REMOVE (and more generally functions that accept a test function parameter) is EQL.

When you write (remove '(1 2 3) '((1 2 3) (4 5 6))), you have no guarantee that both lists that print as (1 2 3) are identical. They are likely to be represented by different cons cells:

This is an artifact of the printer. The # signify omissions in the output. You most likely have *print-level* active at some low value. If you inspect your result, it will be revealed to be complete.

This behaviour is intended to make REPL interaction with large outputs manageable.

Of course, it shows that your output is not correct, as it is deeply nested.

I don't have a way to test this right now ... but

To get all part numbers and their applicable aircraft ... simple query joining the tables (not including any formatting you want to do on the output)

select AircraftParts.PartNumber, BoeingModels.B_ModelName, AirbusModels.A_ModelName from AircraftParts join Part2Aircraft on AircraftParts.P_ID = Part2Aircraft.P_ID join BoeingModels on Part2Aircraft.B_ID = BoeingModels.B_ID join AirbusModels on Part2Aircraft.A_ID = AirbusModels.A_ID;