:blush:
I am creating a list from 2 tables
Example:
Table - DeviceAccessory & Table - EmployeeAccessory
My SQL example would be...
SELECT DeviceAccessory.deviceID, DeviceAccessory.deviceType, DeviceAccessory.deviceSubType, DeviceAccessory.uniqueID, DeviceAccessory.deviceStatus, DeviceAccessory.activationDate, DeviceAccessory.dateAquired, DeviceAccessory.make, DeviceAccessory.model, DeviceAccessory.serialNumber, DeviceAccessory.registeredName, DeviceAccessory.notes1, DeviceAccessory.notes2, DeviceAccessory.notes3, EmployeeAccessory.employeeID
FROM Groundbreaker.dbo.DeviceAccessory DeviceAccessory, Groundbreaker.dbo.EmployeeAccessory EmployeeAccessory
WHERE EmployeeAccessory.deviceID = DeviceAccessory.deviceID
How do I use the Controller for this?
I am creating a list from 2 tables
Example:
Table - DeviceAccessory & Table - EmployeeAccessory
My SQL example would be...
SELECT DeviceAccessory.deviceID, DeviceAccessory.deviceType, DeviceAccessory.deviceSubType, DeviceAccessory.uniqueID, DeviceAccessory.deviceStatus, DeviceAccessory.activationDate, DeviceAccessory.dateAquired, DeviceAccessory.make, DeviceAccessory.model, DeviceAccessory.serialNumber, DeviceAccessory.registeredName, DeviceAccessory.notes1, DeviceAccessory.notes2, DeviceAccessory.notes3, EmployeeAccessory.employeeID
FROM Groundbreaker.dbo.DeviceAccessory DeviceAccessory, Groundbreaker.dbo.EmployeeAccessory EmployeeAccessory
WHERE EmployeeAccessory.deviceID = DeviceAccessory.deviceID
How do I use the Controller for this?
RE: Pulling list which includes columns from mutiple tables
When you pull this Data Source repeat onto your page (probably onto Paging Table), it will automatically create a basic SELECT statement.
In this case it is just a list of DeviceAccessory records, so it will create the majority of your SQL above.
Once the Studio has generated the SQL rule in the controller, go and edit the SQL in the rule to extend it to cover your full SQL above.
In this case I think that would be enough for your needs.
You may need to add another column to the Paging Table to add the single field EmployeeAccessory.employeeID ?
If this is the case drag an output field onto the paging table and manually change its name. Then go to the bindings screen and add the field name to the new field you have added (employeeID).
I think that shoud do it.
J.
RE: Pulling list which includes columns from mutiple tables
Yes I did this...
"In this case it is just a list of DeviceAccessory records, so it will create the majority of your SQL above."
Yes it did...
"Once the Studio has generated the SQL rule in the controller, go and edit the SQL in the rule to extend it to cover your full SQL above."
Yes I did...
"In this case I think that would be enough for your needs."
Unfortunately, it didn't work...
"You may need to add another column to the Paging Table to add the single field EmployeeAccessory.employeeID ?"
I did this also....
"If this is the case drag an output field onto the paging table and manually change its name. Then go to the bindings screen and add the field name to the new field you have added (employeeID)."
I changed the binding for employeeID and it now shows properly... Thank you! apparently I missed that one. :)