Open Detail UX automatically after Search

[compuaid]

I have a search grid that allows the user to open a UX dialog for the detail view. I would like to automatically open the Detail View UX if only one record is returned from the Search part of the grid. I'm assuming I'll need to do this in the Server Side AfterSearch event and reference the count using:

if Args.Info.TotalRecords = 1

The question is how then to automatically open my UX component and have it populate from the selected (and only) grid row without having the user have to click the Show Details button. What I need is something like the Open a UX Dialog script that I have associated with the OnClick event of the Show Details button.

I always like to eliminate extra steps for my users where possible.

[Peter.Greulich]

Re: Open Detail UX automatically after Search

Brad,

Just create an action JavaScript that opens the UX like you did on the button. Then call that action from your search event.

[compuaid]

Re: Open Detail UX automatically after Search

Yup! That did the trick. All I did was create the Action Javascript in the Javascript Functions of the Grid naming it OpenUXDialog then set it up exactly like I'd done with the button. I grabbed the code to call it by clicking the link on the Define Javascript Actions form. In my Server Side AfterSearch I added the following code:

(This code only worked partially...see the posts below to see my ultimate solution and disregard the code in this post.

with PageVariables
if Args.Info.TotalRecords = 1
	dim aa as p
	aa = args.rtc.A_AjaxResponses
	aa[].text = "{grid.object}.runAction('OpenUXDialog');"
	aa[..].id = 100  'the order in which AjaxResponses are sent to the browser
end if
end with

and Voila the detail form opens to the correct record when the search returns only a single record. Thanks Peter!

[compuaid]

Re: Open Detail UX automatically after Search

There is one glitch. If you have the "Hide Grid when no search active" checked then if the first search returns only one record the grid has not been initialized and nothing shows on the UX Detail form. Once the grid has been opened any subsequent searches that result in only one record will bring up the form correctly. The workaround for now seems to be to let the grid show always even before a search has been created. The obvious disadvantage to this is that records the user is not interested in are selected and returned when the grid is initially opened.

[compuaid]

Re: Open Detail UX automatically after Search

Well I spoke too soon. Iterative testing shows that in some instances searches that result in a single record bring up a fully populated UX Dialog while others result in the dialog being blank. I'll have to do some debugging to see why this is happening. Could be that I'll need to move the call to open the dialog to another event that fires later and simply set a flag for it in the AfterSearch event.

[compuaid]

Re: Open Detail UX automatically after Search

Okay, solved it! For anyone interested here are the steps which also solved the problem with hiding the grid when the search is not active:

In the Server Side event OnGridExecute I added the code to initialize my single record flag:

session.SingleRecord = .f.

Next in the AfterSearch event I used the following to set the flag after a search:

with PageVariables

if Args.Info.TotalRecords = 1
	session.SingleRecord = .t.
else
	session.SingleRecord = .f.
end if

end with

Finally in the OnExistingRowRender event I check to see if the SingleRecord flag is true and if so I call the ActionJavascript function to open the UX Detail:

if session.singlerecord
	e.javascript = "{grid.object}.runAction('OpenUXDialog');"
	session.singlerecord = .f.
end if

Thanks again Peter for pointing me in the right direction! Hopefully this helps someone else with the same or similar issue.