Highligting Current Record

[ahmad]

Since the calculation suggestion is the most powerfull, we prefer that one.

Let's go for the powerful one.. Hope there won't be any performance issue under networked solutions with huge records

[Jan Blok]

Hope there won't be any performance issue under networked solutions with huge records

There will be none, the calc is only be executed for visible records.

[Harjo]

Will this be implemented in RC5?

[jcompagner]

yes

[faheemhameed]

Hi there,

I am unsure how to do highlighting records. A method is called during "onRecordSelection" event or what? Can someone explain the process?

Thanks
Hameed

[maarten]

sure,

the highlighting isn't triggered by an event script.
In fact in works with an unstored calculation with a specific naming:
"servoy_row_bgcolor".
If you create a calculation with this name it will automatically starts influencing your row color.

The calculation works on all visible rows in your form:

Code: Select all

var recordIndex = arguments[0]; // gets the index of the record
var selected = arguments[1]; //checks if this record is currently selected
if (selected)
{
   return '#CCCCEE';
}
else
{
   if (recordIndex % 2 == 0)//alternate on even oneven
   {
      return '#0000FF';
   }
   else
   {
      return '#FF0000';
   }
}

[patrick]

Hi! I have just tried the new possibilty and it does work great! Thanks!

There is one issue, though. The function also changes the background color of my controller. So depending on the record you touch, the controller changes its colour everytime. This looks a little odd... Is this fixable?

[jcompagner]

yes for now don't base the controller on the same table..
use dummy

[faheemhameed]

I am displaying a found set of a table (for ex: table_A) in a tab panel as list. That tab panel is in a form and that form is linked to the same table_A.

The "servoy_row_bgcolor" effects both the form and list in the tab panel. That's is correct. But I want the servoy_row_bgcolor to take effect only in the list layout of the tab panel.

I think if we can have arguments[2] that could return the current form name. We can return the background color only if the form name is so and so.

Please advise.

Thanks
Hameed

[patrick]

yes for now don't base the controller on the same table..
use dummy

that is tricky to do, because I have some controller-driven logic in my controller.

That leads to a question that we have discussed before via mail: does a controller need a dataprovider or wouldn't it be easier if the controller always refers to the dataprovider of the form that it controls?

I always have a problem to pass information between controller and form that reside on the same dataprovider. Under certain circumstances these two get "out of synch". I wonder if we could do without these issues if the controller refered always to the data provider of the controlled form.[/quote]

[jcompagner]

what kind of things do you use in your custom controller so that it has to be based on the same table?

[patrick]

for example a record count (1/20 that sort of thing)...

[patrick]

another issue: since the background color also applies to my controller of course it does the same to my single record view, which is definetly not nice. I think this should only be calculated for forms in list or table view.

[Jan Blok]

We realize the current method is not fine grained enough, in a later version of Servoy we will add the property 'rowBGColorCalculation' to a form and a portal, to make it fully adjustable.

[pbakker]

Could we also get "servoy_row_fgcolor"???

BTW: as for the rowcolor showing on every form based on the table where you add the calculated field: As a work around I added another if-then-else clause int he calculation, in which I evaluate the value of a global, which caries the current formname. If the formname is one of the ones I do not want to use the highlightning for, I just set the color to the normal background color.

Dunno if you could make this work for a controller though. Sadly, the getName function is not available in the calculation area.

Paul