"Like" join in view

Bryan Mack shared this question 10 months ago
Answered

I need to use a "Like" join in a view, is this possible? Example of the join I'm trying to accomplish:

p.funding_agencies like '%'||fa.fund_agncy_id||'%'


Is there any way outside of a sql-based view that this can be accomplished?

Comments (3)

photo
1

Hi Bryan,

Thanks for reaching out. There is no way to use a LIKE join in a drag and drop View. We just have not implemented a way for users to do more advanced joins as of yet. Indeed this would currently only be possible in a Freehand SQL View.

That said, in lieu of creating a Freehand SQL View, you may be able to achieve your end goal using LIKE queries on subsequent filters and/or calculated fields at the View-level if they have to be reused a lot, so they don't have to keep getting rebuilt at the report level.

I'm afraid support can't assist too much with implementing a solution for this should that be desired, but hopefully this gets you pointed in that direction.

Please let me know if you have any other questions or concerns on this.

Regards,

Mike

photo
1

Hi Bryan,

I just wanted to check in and see if you had any follow-up questions on this.

Regards,

Mike

photo
1

Hi Bryan,

I'm going to go ahead and close this case out sine I haven't heard back from you, but if you have any further questions or concerns on this if you reach back out, the ticket will re-open and I'll be happy to assist you further.

Regards,

Mike