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
Reference item presentation rules
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
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
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
Aware IM Support Team
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact: