Conditionally set Query to top row

BLOMASKY

Here is my issue, I have a query and the related form in one VP
so, selecting a row in the query will fill in the form with the appropriate data.
The query on the left is in date entered order and there are columns in the query that are updated when the form is saved. (i.e. the form has a status attribute, and the query has the status attribute. So if the status is changed, and the form saved, I have the query updated.

ALL is good
However, I have an ADD button, which will add a new record and the query will show it on the top (since it is in date added descending order. BUT the cursor stays on the row that was selected. After a new record is added I would like the query to select the top row, so the newly added form is displayed for the user to enter data.

I can't set the query to always select the 1st row, or when it is refreshed, it would always go to the 1st row.

Any suggestions?
Is there any JS to tell Kendo to select the top row?
(I see a "select" method for a grid, the problem is (I think) that the button to add a row is not in that grid. (I "guess" I could move it, but wonder if there is a way to select a grid in a diff. panel maybe???)

Thanks
Bruce

johntalbott

Of course, but you should wait for Vlad to add a checkbox to do it. doh

PointsWell

I am doing something similar (but different) in that I need two panels to show master detail records. I am writing out the BO to the LIRU.

1 the query has a default operation when a row is selected - insert selected BO to LIRU.
2 show the master form in the depfault output
3 the detail view panel has an update on the process in 1 above to refresh views (and select an appropriate alternative view where the current view is inappropriate for the newly selected BO.

The by product of all that above (and where it is more relevant for you:

When I create a new object in that master form space my save is followed by an operation to write out the new BO to the LIRU and then view LIRU.NewBo NoEdit.

This doesn't fix the selected BO in the query being the previously selected BO and not the newly created Bo but it's easier and faster than writing a lot of script.

tford

Bruce,

You may not be wild about another screen refresh, but in the process that creates the new record, would it work for you to call a two rule process:

ENTER NEW Customer USING MAIN
DISPLAY PERSPECTIVE Customer

BLOMASKY

Not sure how that would have the query re-select the top row. Normally users are selecting any row they want in the query to work on the data selected in the form on the right. So, all is good, except when new record is inserted. (and when it is done, I do a Create not Enter New since all of the data is defaulted.

Bruce

PointsWell

BLOMASKY wrote
Not sure how that would have the query re-select the top row. Normally users are selecting any row they want in the query to work on the data selected in the form on the right. So, all is good, except when new record is inserted. (and when it is done, I do a Create not Enter New since all of the data is defaulted.

Bruce

it depends on what is the end game. I had assumed you wanted to show the form and my suggestion achieves the showing of the details in the form (granted with the disassociation from your query grid until the user next selects a record from the grid - I can't remember if you said whether you were using a form in a panel on the VP or a pop up.

If you "only" want the record selected in the query this won't work.

tford

Does this V8 BSV accomplish it?

bruce 8 10 2017.zip

35.29kB

To add new customers, click on the lightning bolt. It uses ENTER NEW, but you can of course change that to create if you'd like.