How to automatically highlight specific row in query?

MichaelQ

If a record is added to a query of 100s of records, after the query is refreshed, how can one automatically go to the correct query page and highlight the record which was just added?

Many Thanks,

BLOMASKY

one way, is to have a DateOfLastChange in the BO, have it updated to CURRENT_TIMESTAMP and then sort the query by this field, DESCENDING. It will now be the 1st row.

bruce

MichaelQ

Thanks Bruce.

In native Windows apps one can programatically highlight/select a specific row in a grid.
I don't know if this is possible in a web app, but is it possible in AwareIM to automatically select (highlight) a query row? Say I wanted to select the third row down. How could this be done?

BLOMASKY

I would "ASSUME" that could be done in Javascript, but Aware is lacking the "FIND INDEX OF ITEM IN A STORE" function
or any way to loop through an arrray of records. The good news is it is very seldom needed. The bad news is you are hosed if you need it.

Again, you can filter and sort the records, but thats not what you are looking for.

oh well, we can wait for version 8

bruce

johntalbott

http://docs.telerik.com/kendo-ui/api/javascript/ui/grid#methods-select

MichaelQ

Thank you.

pureist

In your first message you just say "highlight". But in your second message you say "highlight/select" and "select (highlight)".
Which is it? They are different.
Is it merely just, highlight?
Or is it, select (which ordinarily inherently highlights the row to indicate selection)?
The way your first message reads it seems you just want to highlight the most recently added record (not select it) so the user is aware which record was most recently added/that a record was added.

MichaelQ

I was just wondering if there is a setting in AwareIM that highlights the most recently added record (not select it) so the user is aware which record was most recently added/that a record was added.

pureist

Although I've never used it, it seems you could have and maintain an attribute of the object which acts as a flag, and use Item Display/Presentation Rules with appropriate criteria.

OR, in the RegularUser object have a separate attribute for each query for which you want to highlight the last added record. Then update the corresponding attribute with the ID of the last added record when the form is saved.

Then in the query Item Display/Presentation Rules the criteria for the highlight (different background color) would be:
objectname.ID=LoggedInRegularUser.objectname_lastaddedinstanceID

And if you only want to highlight the last added record during the 'session' in which records are being added for an object (ie. not highlight it a week later when next login occurs or 10 minutes later after the user has gone and done something else and then come back to the query) then you could just use one attribute in RegularUser to manager it.

MichaelQ

That seems like quite an elegant solution.

It would be nice if support could add this (as well as ability to select the row) as a built in feature.

pureist

"add this"??.. Add what? Everything I described already exists.

"(as well as ability to select the row)"??.. There you go misleadingly using "select" again.
The ability to HIGHLIGHT (which is what you ultimately clarified that you want to do) already exists per the explanation in my previous message.

You gotta do some work yourself. It's not hard.

MichaelQ

Point taken.

hpl123

MichaelQ wrote
That seems like quite an elegant solution.

It would be nice if support could add this (as well as ability to select the row) as a built in feature.

Yes, having this in Aware would be nice 🙂.