Execute Permanent Query

This is a simple little script for form views. It executes the first permanent query from the list of all stored permanent queries and shows it in the form.

//This sample button script will run first permanent query in data tree

evaluate = { widget ->
def rs = widget.form.resultSet
def dataTree = rs.dataTree

def queries = dataTree.getQueries()

//Change number in get(0) to run any other permanent query, 0 will pick first DFQuery from List of all permanent queries
def DFQuery = queries.getItems().get(0)
def expression = DFQuery.getExpression()

//Query name is returned via DFItem interface, refer to Instant Jchem developer javadoc
println "Executed query name: " + DFQuery.getHandle().getInstance().getName()

def rsLock = rs.lockable.withLock('querying'){ rsEnv ->
rs.applyQuery(expression, rsEnv)

Versions: This script has been tested in IJC version 6.2

Copyright © 1999-2012 ChemAxon Ltd.    All rights reserved.