This is a little SQL puzzle I've been wrestling with for awhile now. I am getting requests from users for List and Output Set elements that mimic the functionality of FT_GET_ADDRESS. Namely, to return a control grouped email address, postal address, salutation based on a parameter selection and then return the primary value if the selected type doesn't exist.
I'm struggling with how to implement this as a view. I've built something for salutations but it is pretty kludgy. Essentially, I create the Cartesian results of T_CUSTOMER and VRS_SIGNOR and then make the needed joins to get the primary value when the control grouped salutation doesn't exist. This works ok in limited circumstances. But it definitely has the potential to generate several million rows if I use it in the wrong spots.
Can anyone suggest a way to implement a call to FT_GET_ADDRESS or FT_GET_EADDRESS in a view? This means that I would have to make the parameter calls to the function from inside the view without knowing what the user is doing when they invoke the view itself.
Or am I just barking up a dead tree?
Thanks!
- Levi
I'm also wondering if Contact Points in V12 might make this a little simpler? Will there be functions or views in 12 or 12.5 that would streamline this process?