Need help with Ens.Rule.FunctionSet

21 views
Skip to first unread message

Brad Harum

unread,
Apr 23, 2013, 2:18:20 PM4/23/13
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
Reply all
Reply to author
Forward
0 new messages