Detail View

[lvasic]

Does anybody know how to call the Detail View from the response.redirect method?

response.redirect("EmployeeFe.a5w?EmployeeFe_filter=SysID="+LastIdentityValue)

I can get it to call the grid, but I want it to open the Detail View.

[frankbicknell]

Re: Detail View

If the grid is for this purpose. You could put {grid.Object}.detailView(rowNumber) or any of the other detail view mwthods in the OnGridInitializeComplete event. Of course every time the grid is initialized the detail view would open.

[lvasic]

Re: Detail View

I know what the SysID in SQL is at that point. Is there a method that allows me to say {grid.Object}.detailView.SysId = (Whatever Number I'm passing)

[frankbicknell]

Re: Detail View

You could use {grid.Object}.detailView(1) and it would open with the current record.

[mmaisterrena]

Re: Detail View

This is method I use to open directly a detail view (ill save you lots of time of experimentation).
Create a n a5w page
Insert the Grid you want to display its Detail view
Go to the page "Source" an look for 'Following code allows you to override settings in the saved component.
In the next line after that paste this text after the ".override_settings = " text

<<%override_settings%
	search.has_search_component = .f.
	HasQuickSearch = .f.
	fields = 1
	rows = 1
	HasRecordsPerPageSelector = .f.
	hasRowExpandColumn = .f.
	hasCheckboxSelectColumn = .f.
	show_column_titles = 1
	DetailView.displayStyle = "OnPage"
	DetailView.ShowNewRecordIfNoRecordsInQuery = .f.
	DetailView.OpenMethod = "Click a hyperlink field"
	DetailView.Toggle = .f.
	DetailView.OnlyShowOnRequest = .f.
	DetailView.HideGridIfDetailViewIsVisible = .t.
	DetailView.HasCloseLink = .f.
	DetailView.CloseDetailViewLinkLabel = ""
	DetailView.CanClose = .f.
	DetailView.total_records_row = ""
	DetailView.CloseAfterSubmit = .f.
	componentName = componentAlias
	_gridFilename = "Pr_Actividades_Main_sql"

customizationString.DetailView.toolbar = <<%txt%
{images.dv.firstRecord}="blank.png"
{images.dv.prevRecord}="blank.png"
{images.dv.nextRecord}="blank.png"
{images.dv.lastRecord}="blank.png"
{images.dv.newRecord}="blank.png"
%txt%
%override_settings%

[mmaisterrena]

Re: Detail View

Delete this 2 lines from the text above
componentName = componentAlias
_gridFilename = "Pr_Actividades_Main_sql"

[frankbicknell]

Re: Detail View

Go to the page "Source" an look for [I]'Following code allows you to override settings in

Where is the page "Source"?

[Sparticuz]

Re: Detail View

Sorry to resurrect a semi-dead thread, Mauricio, I have this for my code

search.has_search_component = .f.
search.HideGridWhenNoActiveSearch = .f.
HasQuickSearch = .f.
fields = 1
rows = 1
HasRecordsPerPageSelector = .f.
hasRowExpandColumn = .f.
hasCheckboxSelectColumn = .f.
show_column_titles = 1
DetailView.displayStyle = "OnPage"
DetailView.ShowNewRecordIfNoRecordsInQuery = .f.
DetailView.OpenMethod = "Click a hyperlink field"
DetailView.Toggle = .f.
DetailView.OnlyShowOnRequest = .f.
DetailView.HideGridIfDetailViewIsVisible = .t.
DetailView.HasCloseLink = .f.
DetailView.CloseDetailViewLinkLabel = ""
DetailView.CanClose = .f.
DetailView.total_records_row = ""
DetailView.CloseAfterSubmit = .f.

I've only added line two, but for some reason DetailView.HideGridIfDetailViewIsVisible = .t. isn't working. The grid is still viewable even though the detail view is popped up below it.

Edit: If line two isn't there (or set to .t.), neither the grid or the detailview show up.

[Selwyn Rabins]

Re: Detail View

the hideGridIfDetailViewIsVisible property only makes sense if 'onlyshowonRequest' is also set to .t.
you will notice in the builder that the 'hidegrid' prompt is hidden when 'onlyshownonrequest' is not checked.

so if you are going to override settings, you need to set both properties

tmpl.DetailView.OnlyShowOnRequest = .t.
tmpl.DetailView.HideGridIfDetailViewIsVisible = .t.

however, this will not be sufficient. you also need to set this property to recompute the grid properties

tmpl.flagMustRecalculateAllProperties = .t.


once you do this, when you open the Grid, the grid part will be shown - not the detail view - because 'only show on request' is set to .t.
however, when you click on a grid row, the detail view will be shown, and the grid will be hidden.

you would therefore need to have some javascript in the onGridInitialize complete to actually open the detail view.

{grid.Object}.detailView(1)

[Ken Tjia]

Re: Detail View

{grid.Object}.detailView(1)

this open row one and i got it working and understood.
i set it to {grid.Object}.detailView(5) and it also works.

how do i have this set to current row ?

{grid.Object}.detailView(current_row ???)

[Ken Tjia]

Re: Detail View

i got it, ignore previous question,

var me = {Grid.RowNumber};
{grid.Object}.detailView(me);

[Selwyn Rabins]

Re: Detail View

your solution would only work for a button that was in a row. in that case {grid.rowNumber} would be replaced with the current row number at the time the grid was rendered.

however, if you only had a single button (that was not in a row), then {grid.rownumber} is meaningless, and your code should then be

var rowNum = {grid.object}._selectedRow;
{grid.object}.detailView(rowNum);