Use <Search Term> from a script

[emiliano.davila]

Hi, we need to use the <search term> entered in the search window during the execution of a JS script. This works in a SQL query (query builder), but the same query doesn't work from a search script. Does anyone know if this is possible? I checked the Sparx Systems documentation and couldn't find anything about it.

I leave an example below

SELECT o.OBJECT_ID AS SERVER__ID,
                p.PACKAGE_ID AS SERVER__SALA
                FROM t_object AS o
                JOIN t_objectproperties AS op
                ON op.VALUE = '<Search Term>'
                JOIN t_package AS p
                ON p.PACKAGE_ID = o.PACKAGE_ID
                WHERE o.OBJECT_ID = op.OBJECT_ID

[Geert Bellekens]

no, you can use the search term.

Solution: get the input from the user yourself, and replace the <Search Term> in the script with the input from the user.

VBScript has inputbox, and I believe there are workarounds for Jscript and Javascript to call this VBScript function as well.

Geert