Good morning! I must be asking way too many questions, but this is due to my sincere interest at your project :-) In Forms, we can have a post-query trigger on a block that allows us to do a lot of things while the data is being fetched. We can compute non-DB fields, do formatting (ex., color coding) at the row level, and etc. The implementation does have its pros and cons, but it's there. Is there similar functionality in Formspider that would allow a developer for changing a row background color in a grid based on a field value? Say, in your master-detail example, I'd like to change row color and font style in the bottom grid based on the hire date value. |
Hi Ilia, Instead of post query triggers, we use wrapper views. We define columns for non-DB fields and row level formatting. To change background color and font style on row level, you can create bgColor and fontStyle columns in your Datasource Definition view (or query). Then, you can bind backgroundColorColumn and fontStyleColumn attributes in the grid XML to the columns you created (bgColor and fontStyle). I sent you a sample application for this. |
Thank you! This is what I was looking for! Can we use a datasource column name as a value for other attributes? For example, if I want to enable/disable a component (a button or a field), can I set enable="myDatasourceColumn"? |
You are welcome. We can bind attributes as ...column to datasource columns. So, we can not bind enable attribute to a column. However we can set enable attribute in runtime. After executeQuery of datasource, use API
|
Hello Ugur, can you please provide the solution for the binding of fontstyle and bgColor with the XML Grid ? Could you paste here some examples. Thanks Uwe
(21 Nov '13, 05:45)
Ibrahim Sand... ♦♦
|