Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 2:14 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: v2.0.2 Create Query
PostPosted: Tue Aug 08, 2017 7:05 am 
Offline
Newbie

Joined: Sat Nov 22, 2014 7:25 am
Posts: 18
I am trying to create a custom query on a fresh install of this version. I can run the SQL and the query is valid, but when I go through the "create query" page, and click submit, I never see the query appear. Is there something else I need to do?

Here is the query. I took an existing query and wanted some additional information.

SELECT system.id AS `system.id`,
system.icon AS `system.icon`,
system.type AS `system.type`,
system.name AS `system.name`,
system.domain AS `system.domain`,
system.ip AS `system.ip`,
system.manufacturer AS `system.manufacturer`,
system.model AS `system.model`,
system.serial AS `system.serial`,
system.os_family AS `system.os_family`,
system.memory_count AS `system.memory_count`,
system.form_factor AS `system.form_factor`,
processor.description AS `processor.description`,
system.processor_count AS 'system.processor_count',
disk.manufacturer AS 'disk.manufacturer',
disk.model AS 'disk.model',
disk.serial AS 'disk.serial',
disk.size AS 'disk.size',
network.mac AS 'network.mac',
network.manufacturer AS 'network.manufacturer',
network.model AS 'network.model',
sound.manufacturer AS 'sound.manufacturer',
sound.model AS 'sound.model',
user.name AS 'user.name',
user.full_name AS 'user.full_name',
video.manufacturer AS 'video.manufacturer',
video.model AS 'video.model',
video.size AS 'video.size'
FROM system
LEFT JOIN processor ON (processor.system_id = system.id AND processor.current = 'y')
LEFT JOIN network ON (network.system_id = system.id AND network.current = 'y')
LEFT JOIN disk ON (disk.system_id = system.id AND disk.current = 'y')
LEFT JOIN sound ON (sound.system_id = system.id AND sound.current = 'y')
LEFT JOIN user ON (user.system_id = system.id AND user.current = 'y')
LEFT JOIN video ON (video.system_id = system.id AND video.current = 'y')
WHERE @filter ORDER BY system.name


Top
 Profile  
Reply with quote  
 Post subject: Re: v2.0.2 Create Query
PostPosted: Wed Aug 09, 2017 8:28 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
Yes, a little bit broken. If you want to fix it yourself before Opmantek gets to it.

Edit \code_igniter\application\views\theme-bootstrap\v_queries_create_form.php and change:

Line 37 from [code]<form class="form-horizontal" id="form_update" method="post" action="<?php echo $this->response->meta->collection; ?>">[/code] to [code]<form class="form-horizontal" id="form_update" method="post" action="<?php echo $this->response->links->self; ?>">[/code]

Line 73 from [code]<label for="data[attributes][menu_category]" class="col-sm-4 control-label"><%== l($human_column) %></label>[/code] to [code]<label for="data[attributes][menu_category]" class="col-sm-4 control-label">Menu Category</label>[/code]


Top
 Profile  
Reply with quote  
 Post subject: Re: v2.0.2 Create Query
PostPosted: Wed Aug 09, 2017 11:21 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
FYI - this is fixed for the next release.

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
 Post subject: Re: v2.0.2 Create Query
PostPosted: Thu Aug 10, 2017 1:05 am 
Offline
Newbie

Joined: Sat Nov 22, 2014 7:25 am
Posts: 18
Thank you both!


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group