Reference item presentation rules

tkilshaw · Post by **tkilshaw** » Mon May 29, 2006 7:20 pm

When a reference is used in a form its possible to set its Item Rules to display each row differently. It doesn't appear to be possible to use functions in these rules. They seem to want just very simple expressions based only on the object whose instanes are beeing displayed.

What is the set of restrictions for item rules?

For example, I'd like to be able to change the colour on Task items whose due dates are 3 days before today to yellow and on those that are 7 days overdue to red. That means I'd need to be able to use an expression that included a Task timestamp field, a value from SystemSettings and the CURRENT_DATE function.

Also, is a similar functionality available for query results? So far it seems not.

It would be nice to be able to do the same thing for the results of a query.

thanks,

Terry

aware_support · Post by **aware_support** » Mon May 29, 2006 11:47 pm

Terry,

What is the set of restrictions for item rules?
The restrictions are:
1) Only conditions that involve expressions with the attributes of the referred objects are allowed. Expressions do include functions, so you can use CURRENT_DATE (see also the Library applications where overdue loans are displayed in different colors
2) Using reference attributes is not allowed, BUT you can use shortcuts instead, which solves the problem.
3) You can use LoggedIn prefix to check values of the current user
4) Using the SystemSettings object is currently not allowed, but this is an oversight, rather than intentional. We will add this support asap.

The bottom line is that you will be able to use the condition you want as soon as we add support for the SystemSettings object

tkilshaw · Post by **tkilshaw** » Tue May 30, 2006 4:40 pm

"you will be able to use the condition you want as soon as we add support for the SystemSettings object".

Very good. How soon?

Also, are you considering adding display rule support for the output of Queries, ao that they will work the same as items in references?

Terry

aware_support · Post by **aware_support** » Tue May 30, 2006 11:18 pm

SystemSettings support has been implemented already in the 1.6 beta. We are planning support for item rules in queries - whether this support will be in 1.6 has not been decided yet.