Link in configuration SQL Source Pickers UNDER REVIEW

6

Hi,

In my opinion, the biggest advantage of BPS data sources is the ability to link to a selected element.

However, the disadvantage is much lower performance in advanced conditions, inability to join data, use union, and combine data from different content databases.

By changing the source from BPS to SQL, users lose the functionality of the link. Of course, we can achieve this in a different way, but it is not consistent, for example, with other pickers using a BPS source.

Would it be possible to introduce configuration options in the picker with an SQL source where we can map columns with ID, Appid, and dbid? Alternatively, a configuration where we return, for example, the entire constructed link (e.g., references to applications other than Webcon)?

In environments where we use several content databases, this would be very useful and would introduce greater consistency for users.

Regards.