I need some help to move a variable to a custom sql query.
I have a list of group names.
depart status
test1 active
test2 active
test3 active
What I want to do is to make the department names clickable to open up a grid below the list form and above the footer field.
I have people assigned to departments and want to show whom is assigned to the 'test1' upon click.
So far I have created the foldable section in the list view.
_list.htm
<DIV id="content" Style= "display:none">
<P>
</P>
{BEGIN container_grid}
pageevent onload
Runner.pages.PageSettings.addPageEvent("posse",Runner.pages.constants.PAGE_LIST,"afterPageReady",function(pageObj,proxy,pageid,inlineRow,inlineObject){window.toggle=function(id)
{if(document.getElementById('content'+id).style.display=='none')
{document.getElementById('content'+id).style.display='block';document.getElementById('handle'+id).innerHTML='';}
else
{document.getElementById('content'+id).style.display='none';document.getElementById('handle'+id).innerHTML='Show2';}}});
----------------------------------------
Now I am trying to figure out how to pass the department_value selected onclick to js? so I can execute a custom query and pass the data back into the page for display in the visable expanded grid section. The tables I intend to reference are a member's table but is not part of the master table.
Am I way off on my thinking?