formatted Search

[michael_messerschmidt]

Hi,

how is it possible to connect a UDF of Type 'General' structure 'Link' to a formatted search ?

Thanks in advance

[Former Member · Accepted solution]

Hi,

1. Create your UDF (General:Link) like any other UDF.

2. Create your formattet search which selects an valid string (anything that works with windows start->run)

3. Open the form where you want to add your formatted search

4. press and hold the shift key

5. double click on the UDF

6. release the shift key

7. choose your query and autoupdate field

8. click the ok button

to change or remove the formatted search start with step 3.

i hope this helps

[Former Member · Accepted solution]

Hi to All,

How to take out the individual values from a perticular row ie it may be first or it may be middle etc..

select $[$37.2.NUMBER] & $[$37.2.0] like this but its not working , And

How to take out the values of a perticular UserDefined Field Iam using $[$U_ConToKg] but its not working

so any one knows please help me to sort out this issue

[michael_messerschmidt]

Thanks Alexander - that's what we wanted to know

[michael_messerschmidt]

Hi Eric,

thanks for reply but we need a UDF from type 'General' and structure 'Link'. An alphanumeric field with a linked UDF Table doesn´t help.

The customer wants directly run an application out of the marketing document which depends on the selected item.

[michael_messerschmidt]

In the item master data we have an UDF linked field. In the marketing document rows there is the same kind of field.

Now we want automaticaly update the field in the marketing document rows depending on which item is choosed.

It is nessecary to use a linked field.

Thanks for your efforts

[Former Member]

Hi,

Not sure to understand exactly what you want to achieve.

What I did, for one of my customers (I guess it's need was similar to your):

- Create a user table, with all the correct values for the asked functionnality,

- Link this user table to the item master data, as a user field,

- Link this user table to the marketing document lines, as a user field,

- Create a FMS on the UDF in the marketing document, UDF which will retrieve the value stored for the item to "replicate" it to the marketing document, when the item code is changed.

In my case, the SQL stored query for the FMS is similar to the following one:

[code]

SELECT T0.[U_SOFI_OM] FROM OITM T0 WHERE T0.[ItemCode] = $[$38.1.0]

[/code]

Hope this helps... If you need more advices don't hesitate.

Regards,

Eric

[former_member583013]

Michael,

A link field cannot have a formatted search on them. If you could explain the actual business need with an example I might be able to suggest some options

Suda

[michael_messerschmidt]

Yes, of course

I´ve created a User defined field in marketing document rows. It is from type 'General' and from structure 'Link'. Now I want connect this field with a formatted search.

This is a challenge, because the UDF is not active in the marketing document rows.

[Former Member]

Hi,

Could you explain a bit more wwhat you want to do ?

Regards,

Eric