Providing Data Source Information

symphonists / uniondatasource

A union datasources allows you to combine multiple datasources to output a single datasource for the primary purpose of a unified pagination.

13 stars 11 forks source link

Providing Data Source Information #15

Closed nilshoerrmann closed 12 years ago

nilshoerrmann commented 12 years ago

It would be nice, if Union Data Source could provide an overview of the attached Data Source's settings in the Duplicators .content area. This way the user could quickly check the settings. If this extension would also provide a direct link to the attached Data Source, quick switching to the other Data Source would become much easier.

brendo commented 12 years ago

Which settings would you consider important?

nilshoerrmann commented 12 years ago

I'm not sure if there are so many irrelevant settings:

filters (so you can quickly see what will be returned)
limits (so you know how many items will be included of that specific DS)
output parameters and included elements (so you know what you get on the front-end)

With my latest pull request the source section is already displayed in the header so it's not needed in an additional overview.

Thinking of an ideal world, Union Data Source would also allow me to adjust settings inline and create new Data Sources inside its interface. But a simple link to the attached original Data Sources would be just fine for the moment :)

brendo commented 12 years ago

limits (so you know how many items will be included of that specific DS)

Pagination from the other datasources is ignored. A Union Datasource's pagination is defined on the actual UD :)

But a simple link to the attached original Data Sources would be just fine for the moment :)

I'll go with this for now so I can get a 2.3 ready release out, but I like the sound of the other ideas. I'd be cautious about letting people modify the datasource inside a UD just incase users think that the settings will only apply to the UD (which in fact it would actually update the original datasource)

nilshoerrmann commented 12 years ago

Pagination from the other datasources is ignored. A Union Datasource's pagination is defined on the actual UD :)

Oh, that's quite surprising to me. I thought I could limit one Data Source to 10 and don't limit another one at all and than filter by 100 on the Union Data Source to get 10 entries of my first and up to 90 entries from my second one.

brendo commented 12 years ago

If that works then it's completely by accident!

nilshoerrmann commented 12 years ago

I don't know if that works, but that's what I was expecting.

brendo commented 12 years ago

Ah, nah. Sorting is more important. For some background:

Union Datasource builds one query to retrieve all the entry ID's from the other datasources.
This query builds each datasources normal SQL query, but then joins them using UNION ALL.
The sorting and limiting applies to result of the entire query, so it will sort all three queries by date and then limit the result.

nilshoerrmann commented 12 years ago

This is really great support here, Brendan. Thank you for your intensive work on this extension. Really appreciated!

brendo commented 12 years ago

No worries, thanks for the feedback :)