Hi,
This strategy is basically sound, but why do it with SQL-stuff when a normal
Join-form will get the job done just as well?
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi Robin,
>
> Unfortunately, no, you can't directly do what you want here. The table &
> column coloring configurations are embedded in some very low level "display
> properties" associated with the table & column fields in the data
> dictionary. There is no way to either dynamically change these, or have
> user specific configurations.
>
> I actually *can* think of a solution, but it'd be pretty involved and would
> require:
>
> 1) An additional form to capture the users' color configurations for each
> Priority value to a limited pre-existing set of colors (one entry for each
> user and Priority value)
> 2) Creating a SQL view joining that configuration with the source table,
> and pulling in that user configuration data
> 3) Creating a Remedy View on top of the SQL View, and adding a Selection
> field on top of the user color configuration value
> 4) Setting up the table (or column) to use this field as the 'Resuts Color'
> source with the pre-existing colors.
> 5) You'd have to also add a UI allowing the users to add/edit this
> configuration.
>
> I'm not sure this is very clear...this is off the top of my head, but I'm
> pretty sure it could be made to work. Like I said though, it's pretty
> involved and would take a bit of time to put together.
>
> Charlie
>
>
> On Tue, May 6, 2014 at 11:56 PM, Robin Mathew <[email protected]>wrote:
>
>> Hi all,
>>
>> I request your help for the following requirement.
>>
>> Requirement
>>
>> I need to provide a configuration screen to user where he can define color
>> coding for table field rows and columns.
>>
>> Example,suppose a table field has 'Priority' column.In the configuration
>> screen,provision should be given to the user for selecting any color for
>> Priority column.
>>
>> if 'User A' selects green color for Priority column,when he view this
>> table field,Priority column should be displayed in green color.
>> if 'User B' selects Red color for Priority column,when he view this table
>> field,Priority column should be displayed in Red color.
>>
>> Similarly, provision should be given to user for defining color coding for
>> table field rows.
>>
>> Example,User A wants to define Blue color for table field row if a record
>> has Priority = "Medium".
>>
>> User B wants to define Yellow color for table field row if a record record
>> has Priority = "Medium".
>>
>> Is it possible to set user-specific color coding for table field rows and
>> columns in remedy table field?
>>
>> if not possible in Remedy,kindly suggest any other options.
>>
>> Thanks
>> Robin
>>
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
