Brad Harum
unread,Apr 23, 2013, 2:18:20 PM4/23/13Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to intersys...@googlegroups.com
Hello,
I have written a class which extends the functionality of
Ens.Rule.FunctionSet. When I am in my DTL and I insert a "IF" rule the right side pane displays a search that when I click will display the "Data Transform Function Wizard" and a list of all functions I can use. When I select the "Function" I just created "GetOptionValue()" in the "Data Transform Function Wizard" with my class I want to be able to do a select on a paramater from a drop down list. Write now it displays my parameters as a plain text input box but how can I display a list to choose from with a SQL query? My code is below:
On the "Data Transform Function Wizard" page when I select the GetOptionValue(), I want the "InterfaceType" parameter to display as a drop down list selection.
Class PICIS.Core.Util.InterfaceOptionLookup Extends Ens.Rule.FunctionSet
{
ClassMethod GetOptionValue(OptionName As %String, SiteId As %String, InterfaceType As %String, InterfaceName As %String) As %String [ Final ]
{
&sql(SELECT Value INTO :OptionValue FROM PICIS_Data.InterfaceConfiguration
WHERE InterfaceOptionsId IN (
select ID from PICIS_Data.InterfaceOptions where InterfaceId in (
select ID from PICIS_Data.Interfaces where Type = :InterfaceType AND Name = :InterfaceName
) AND Name = :OptionName
) AND Site = :SiteId )
return OptionValue
}
}
Thank you in advance for any help here.
Brad Harum