can we write query for fomatted search without from clause

[Former Member]

can we write query for fomatted search without from clause as below.

SELECT (($(u_amt)*14)/100)

here U_amt is a UDF .I want to assign this to another field .

Rgds,

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

You can write query for FMS without from. That is because you can omit it when you get value from active form by default. The grammar of it is:

Select $[$38.u_amt.0\] * 14/100 in your case if you have item type marketing document @line level.

From View-System Information, you can get the info you need for your FMS query at the left bottom of your screen.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi gordon,

As per your below suggestion.I want to use the value 14 in the query below as variable.What I want is based on value of another field , this variable value should change.like if u_tax is ed1 then var1 = 14 else

if u_tax is ed5 then var1 = 15.

Select $[$38.u_amt.0] * 14/100 in your case if you have item type marketing document @line level.

Rgds,

Rajeev

[Former Member · Accepted solution]

Try this one:

Select $[$38.u_amt.0\] * (Case When u_tax = ed1 Then 14 Else Case u_tax = ed5 Then 15 End End)/100

Thanks,

Gordon