Depselect and fieldgroups not Updating
Archived from the Xataface Developers forum.
jb606 — Fri Jan 27, 2012 2:33 pm
When editing an existing record with depselect widgets the “slave” field will come up blank(Chrome) or “Please Wait…“(Firefox) when the master and slave fields are in different fieldgroups. My Javascript foo is basically not existent so my debugging has been just looking for errors on the page and in my Apache error logs, none have been found. The joys of beta code, sorry I could be more helpful with providing a possible solution.
Version Info:
Xataface: 1.5 2734
Depselect: 0.1 2345
PHP 5.3.3
–fields.ini–
[SrcRoomID]
widget:type = depselect
widget:label = “Source Room”
vocabulary = “RoomList”
widget:table = “Rooms”
group = “Rooms”
[SrcDeviceID] ;; This field is blank on load and won’t update when SrcRoom is changed.
widget:type = depselect
widget:table = NetworkDevices
widget:filters:RoomID=”$SrcRoomID”
widget:label = “Source Device”
vocabulary = “DeviceList”
group = “SourceDev”
[SrcDevicePortID]
widget:type = depselect
widget:table = DevicePorts
widget:filters:DeviceID=”$SrcDeviceID”
widget:label = “Source Port”
vocabulary = “DevicePortList”
group = “SourceDev”
[fieldgroup:Rooms]
order = 1
[fieldgroup:SourceDev]
order = 2
label = “Source Devices”
–DB–
TABLE Rooms (
RoomID int(11) NOT NULL AUTO_INCREMENT,
SiteID int(11) NOT NULL,
BuildingID int(11) NOT NULL,
RoomNumber varchar(32) NOT NULL,
PRIMARY KEY (RoomID)
)
TABLE NetworkDevices (
DeviceID int(11) NOT NULL AUTO_INCREMENT,
SiteID int(11) NOT NULL,
BuildingID int(11) NOT NULL,
RoomID int(11) NOT NULL,
DeviceName varchar(32) NOT NULL,
PRIMARY KEY (DeviceID)
)
TABLE DevicePorts (
DevicePortID int(11) NOT NULL AUTO_INCREMENT,
DeviceID int(11) NOT NULL,
RoomID int(11) NOT NULL,
DevicePortNumber varchar(32) NOT NULL,
PRIMARY KEY (DevicePortID)
)
TABLE Connections (
ConnectionID int(11) NOT NULL AUTO_INCREMENT,
SrcRoomID int(11) DEFAULT NULL,
DstRoomID int(11) DEFAULT NULL,
SrcDeviceID int(11) DEFAULT NULL,
DstDeviceID int(11) DEFAULT NULL,
SrcDevicePortID int(11) DEFAULT NULL,
DstDevicePortID int(11) DEFAULT NULL,
PRIMARY KEY (ConnectionID)
)
shannah — Sat Jan 28, 2012 9:14 pm
Thanks for reporting this. The depselect widget currently only looks within the same field group… Upon reflection, this limitation doesn’t seem to have any purpose. I have added this issue to the issue tracker.
http://bugs.weblite.ca/view.php?id=927