Passing custom query to objectlocator

Hi,

We have a problem in that the attribute editor for repeating attributes in Webtop 6.5 has become inpractical to use with very large value assistance picklists. Usually, long picklists are unadvisable, but in some cases they are unavoidable. The ideal would be a value assistance selector, which allowed users to search or browse for values. Our value assistance data is comprised of contentless sysobjects.

The object locators seem to tick most of the boxes, but as yet I havent worked out how to pass down a custom query without significant customisation. I can see that its possible to change the type & filter, but some of the value assistance queries we have are more complex (e.g. there's one VA query that is 3 unioned queries!), so it would be easier to just give it the DQL statement.

Has anyone done this before ? I dont mind loosing the VA queries, and hardcoding them into a config file instead. Any pointers ?

Many thanks.

Keith

Find more posts tagged with

Comments

lastnitescurry

common enough problem... been there done that.... got a nice decent version working a few months ago. Table to select from, columns to display all defined in Webtop xml configs. Code based on objectlocator and returns selections in same format as single or repeating selections.

Keith Bailey

In the end, I decided to extend the edit component for the repeating attributes (handled by DocbaseRepeatingAttribute) - and found a clever jQuery plugin which provided me with a slick UI.

Since it supported AJAX, I wrote a simple servlet which ran the right query for the selected attribute (configured in a properties file) and returned a maximum of 25 results. This allowed me to drop some of the value assistance queries, which has made the rendering of the properties page much quicker.

DCTM_Guru

What jQuery plugin did you use?