dropdown

Contents

dropdown=fieldname

dropdown=dw_x.fieldname (beas9.1 PL:8)

dw_x.item.dropdown (beas9.2 PL:6)

open the dropdown window

Will be used for e.g. Bitmaps.

The DropDown Information will be provided with Field properties. ( use Strg+N+N on the Field )

Attention: this are old function. Please work with item.<itemname>.dropdown. More Information

See item

Commands:

ddsql=sql-command

Describes the SQL Statement for the DDDW

you can define the output-format in the field-description

see dropdown-sql-format

ddfelder=field=Index=width,feld=Index..

Field definition for Output.

Index is the field index provided in the SQL Statement.

SQL-Statement - value1=Index1, value2=Index 2

bei select itemcode,itemname from oitm ist itemcode=index 1 and itemname=index 2.

Declare like:

fieldname=Index=width

fieldname must be a unique Name without White Space

Automatic Creation

If you do not provide ddfelder than it will be created automatically.

All Output fields will be shown. The first field will have a width of 350 Pixel. The Rest of the Fields will have a width of 400 Pixel

How to control the "automatic creation":

If you use an SQL Field with the name "__<width>" so the given Width will be used.

Example:

ddsql=select "ItemCode" as itemcode__300,"ItemName" as itemname__1000 from "OITM"

Better is to use the dropdown-sql-format

Translate

To translate a field, you can use the word "translateme"

Example:

Operation-Typ-Description are in german. You will display the description in your language.

Solution: convert fieldname "description" with

description+'' as ...

and insert the key "translateme" in the name

as desc_translateme__800

full example:

ddsql=select "AGTYP","DESCRIPTION"+'' as desc_translateme__800 from "BEAS_AGTYP" order by "AGTYP"

ddeingabe=..

Show Input field

ddreturn=fromfield=tofield

Optional: Describes a Field mapping. Which DataWindow Field should be mapped to which Target Field.

ddwidth=breite

Optional: Width of the DrowpDown. Reserves a extra of 50 Pixel for Scrollbars.

dditem=field=value,field=value..

Fill DataWindow by hand if not working with "Values"

Example:

ddsql=select rpad(' ',50) as valuesid

dditem=valuesid=red

dditem=valuesid=yellow

Attention: use hana-format. See select

ddscript=<beascipt>

Optional: This Script will be executed before the Selection Form will be opened.

You can specify more than one line.

ddok=<beasscript>

Optional: This Script will be executed after a successful selection.

ddemptyrow

insert an empty row

ddfilter=<sql-filter>

replace the text "(filter)" in the sql-statement

ddreturnfields=fieldname,fieldname

beas set the variable dd:<fieldname> in the source window

normaly the field of sql-statement or if you have values in dropdown then variable dd:text and dd:inhalt

Example

ddsql=select "ItemCode","ItemName" from "OITM"

create 2 variables

dd:itemcode

dd:itemname

width ddreturnfield you can set the variable name

exampe:

ddsql=select "ItemCode","ItemName" from "OITM"<tab>ddreturnfields=result1,result2

created variables

result1

result2

ddvar=variable=value

Example for SQL Statement

ddvar=itemcode=A%

you can insert this variable in SQL-Statement:

select "ItemName" from "OITM" where "ItemCode" like N'[itemcode]'

Example for Series for purchase orders in one line

select:docseries::ddvar=objcode=22

Alternative you can put the Syntax into the variable "dropdown:<feldname>".

This would be mostly used for specific Customer customizing since this Alternative has a higher Priority inside the Engine.

if you need more then one command, then you can define the next parameter with <tab>

setvar=dropdown:itemcode=ddsql=select "ItemCode","ItemName" from "OITM"<tab>ddreturnfields=result1,result2

If the selection criteria has been deposit into the Edit Values than you need to use "ddsql=*"

Examples:

(old version! Please work with item)

// In connection with a value SQL Statement

ddsql=select "ME_ID" from "ME"

// In connection with a variable

setvar=dropdown:me_id=ddsql=select "ME_ID" from "BEAS_ME"