Can’t see the sub tables

Wappler General How To
#1

@Teodor Will Wappler recognize “junction table” and connection references if they wasn’t created in Wappler but in classic way via Query in DB?

Using Tagify with Multi References
#2

Yes any existing junction tables will be automatically recognized by Wappler as Multi References.

#3

I have “junction table” made with query bellow:

CREATE TABLE sam_sip_groups_membership (
	sam_sip_groups_membership_id SERIAL NOT NULL,
	sam_sip_group_membership_sip_id INTEGER REFERENCES sam_sip(sam_sip_id) ON DELETE CASCADE ON UPDATE CASCADE,
	sam_sip_group_membership_group_id INTEGER REFERENCES sam_sip_groups(sam_sip_group_id) ON DELETE CASCADE ON UPDATE CASCADE,
	PRIMARY KEY (sam_sip_groups_membership_id)
);

Unfortunately Wappler won’t recognize it as Multi Reference table.
I’ve tried Refresh Schema several time and on “db” level, and on sam_sip_groups_membership itself.

image
image527×602 15.7 KB

#4

Do you have the experimental features on? In Wappler’s global options / system

#5
  1. Didn’t found any reference in this topic or Using Multi References in the Database Manager that this is an “experimental feature”
  2. After enabling experimental feature - I can’t see *sam_sip_groups_membership * table (junction table made manually) anymore in Wappler.
  3. After I turned off Experimental Feature - I was able to see sam_sip_groups_membership table again

image

image

Did “Refresh Schema” on all levels - didn’t helped.

P.S. I think this discussion need to be moved to Using Multi References in the Database Manager

#6

When a sub table is recognized it will show under its parent table.

So just expand your sam_sip_groups to see it.

1 Like
Nested queries / sub table joins for tables created outside of Wappler?
#7

Thank you for explanation.
Indeed junction tables are under “parent” tables.