similar issue (but with workaround) happens when I try to search what currencies are available for the vendor (see screenshot#1). This data is exposed via currencyList on the Vendor and is returned in VendorSearchBasic (screenshot#2). But it is just not there in VendorSearchAdvanced and not joins are available to query that. Again, this is limitation of advanced search? So AdvancedSearch is not an all-mighty at all and we need to use BasicSearch as a workaround?

what do the results look like when adding the currency column

I believe you started to answer to the upper message. this seems to be another example of advanced search limitations - that curencyList from basic search is just not exposed in VendorSearchRowBasic at all. We just have there one property "currency" and it returns the preferred currency for the vendor, but not the list of all available currencies for this specific vendor. So it looks like if I want this data then I'm forced to use BasicSearch (which is much slower). I am just wanted to verify my understanding - that AdvancedSearch cannot really substitute BasicSearch/JoinedSearch in 100% of times.

advanced searches mimic saved searches