Relational Lookup in SQL Postgres

Ask for Help
1

Hi -

Is there a workaround to be able to lookup or build some sort of relation table with Postgres and a Glide Table? Is there a work around anyone has?

Kind Regards

image
image1542×1210 93.4 KB

2

Is your relation a single or multiple relation?
It should work for a single relation, I believe.

Oh, wait. It’s a query. Try using a single value column instead of a lookup.

3

Thank you!! That seemed to work. Single Value.

image
image1542×1210 94.2 KB

4

Yeah. I haven’t used SQL data sources with Glide yet, but I believe that many of the same limitations that apply with Glide Big Tables also apply. One of those is that you can’t do a lookup through a multiple relation or query. If you’re just wanting a specific value (as opposed to an array), then a single value is the way to go.

3 Likes
5

Thanks Darren. Yeah, learning the limitations as well, but glad to see there was a workaround! Appreciate the help and quick response

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.