Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Add "All location ID info" under Group category location https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6562 |
Page 1 of 1 |
Author: | cburbs [ Fri Nov 11, 2016 8:37 am ] | ||
Post subject: | Add "All location ID info" under Group category location | ||
Hey I am trying to add another XML under Location catagory that will give our locations/location ids plus other info. but get an error. Error Number: 1136 Column count doesn't match value count at row 1 INSERT INTO oa_group_sys (system_id, group_id) SELECT oa_location.location_name, oa_location.location_id, oa_location.location_type, oa_location.location_city, oa_location.location_state FROM oa_location WHERE oa_location.location_id <> 0 Filename: models/m_oa_group.php Line Number: 175 See attached file.
|
Author: | jpa [ Fri Nov 11, 2016 8:45 am ] |
Post subject: | Re: Add "All location ID info" under Group category location |
What version are you on? The query in the XML won't work against the latest schema. If on a recent version search and replace "location_" with "" in the XML. Also remove the Tags column or add it to the query. Although it seems like you should be adding a Query rather than a Group for what you want. |
Author: | cburbs [ Fri Nov 11, 2016 8:52 am ] |
Post subject: | Re: Add "All location ID info" under Group category location |
1.12 I have it working as a query but would rather have it on the main page so I thought I might be able to get it to work and show up under Location have it with a different icon to stand out from the rest. |
Author: | jpa [ Fri Nov 11, 2016 9:31 am ] |
Post subject: | Re: Add "All location ID info" under Group category location |
I don't know if what you want is possible. The main page Group thing is designed to show devices in a group. There's a lot of stuff that goes on behind the scenes with the Select SQL and stuff to gather these devices. You're trying to output Locations which I don't think will work. I can't say definitively that it won't but I'd guess not. Open Audit is getting a fairly extensive rewrite at the moment. I am not privy to the details but the main page is probably going to change a lot. Maybe what you want will be easier when the next release comes out. John-Paul |
Author: | Mark [ Wed Nov 23, 2016 9:26 am ] |
Post subject: | Re: Add "All location ID info" under Group category location |
Will post a screenshot of the current development showing the new main page. |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |