I have two lists, 'A' and 'B'. I need to display their joined data according to certain filters.
A and B are joined using Linked sources and I can filter data by column values from A thanks to this little trick: http://www.sharepointdev.net/sharepoint--design-customization/dataformwebpart-in-sharepoint-designer-linked-to-sql-not-being-able-to-filter-2821.shtml
Does anyone know of any workaround how to filter and sort the displayed form by items from A and B? For example, can I somehow trick SharePoint into making an SQL query on those two lists or this isn't a job for the SharePoint Designer?