Expression/Jython

I know that the two are different and are used differently. Such as Jython using the FPMI usualy goes under buttons and other type action items. Where as Expression is used in other location.

My question is: Is there a way to use the FPMI.SECURITY.GETROLES() in an IF statement in something that used expression?

What I want to do is have a query against a data base. If you have say level4 or higher the where clause will contain this, if you are under a level4 the where clause contains a differnt set of criteria.

Hope this is clear.

There are various ways to achieve this. You could use the runScript() expression which bridges the two languages, or you could use the {[System]Client/User/RolesDataSet} tag directly.