How can i display the first 2 characters of the object LOV's in IDT??

[vaibhav_rathore]

Hi All,

I have been stuck in a situation now, where i would like to show the limited Characters of the Object, in IDT.

Eg: My object is "Distribution_Channel" which have LOV's "EXPORT" and "IMPORT"

I want to display the "EX" of "EXPORT" and "IM" of "IMPORT" whenever this particular object is called in either Dashboard or Webi Report.

How can i achieve this in IDT??

Thanks and Regards

Vaibhav

[Former Member · Accepted solution]

If your backend database is MS SQL server then you can use following code:

Create new object on IDT like:

DC = substring([Distributon_Channel],1,2)

Now you can use this object on report to get your desired output.

Thanks,

Swapnil

[vaibhav_rathore · Accepted solution]

Thanks Swapnil.....it worked

[Former Member · Accepted solution]

you can mark my answer as correct and close the thread!

Thanks,
Swapnil

[former_member195292]

In the Object you may try this function LEFT("Object", 2) which give you first 2 Char from left of whole string  that could be use for Lovs as well.

[amitrathi239]

Hi,

Create new object for Distribution_Channel in IDT.Use  substring function to get the first two character  values in the new object.

  create List of value object in business layer then create a parameter object and associate newly created list of value object to the parameter

Amit