Skip to Content

Custom ovs

Hi All, @Fred K, @Stefan Krauth, Former Member

I have created custom ovs as shown in below images.

when i was searching for particular record irrespective of case it was not working so i posted the question in scn() and followed the steps mention by Former Member and it's working fine.

When i create new entry for ovs it save data in cap's even though i enter data in small case this is because i have taken data type "ID" to make case insensitive search. But my client wants to save data the way he/she has given.

when i search for the record by putting "*". search is not working.

I change it to "contains pattern" as shown in below image even though it not working.

I have following things to be done

1) I want to make the search irrespective case.

2) Data should be save the way it has given( for this i have taken other data type "Language independent..". If take this data type case insensitive search is not working.)

3) I want to search record by putting "*" i.e "Lob*" .

Could you please help me.

Thanks,

Quddus.

1.png (1.6 kB)
2.PNG (4.0 kB)
4.PNG (4.1 kB)
1 (1).PNG (4.1 kB)
2 (1).PNG (14.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 23, 2015 at 12:27 PM

    Hi Quddus,

    As I have written already in the mentioned other thread:

    So if you need the data stored in a case-sensitive way but search case-insensitive, you have to store the case-insensitive data in a separate field (read: an additional field) where the search is performed upon while the original data is in the first field which also will be shown.

    Regarding placeholder search:

    Use the "Basic Search" functionality of a custom query.

    Best regards,

    Ludger

    --

    Custom Development with all4cloud.de

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 01:45 AM

    Hi Md,

    Even if you use ID as datatype , you cannot search using " * "?

    Have you tried the following workaround?

    1. create two fields

        a) Text (external use)

        b) ID    ( internal use)

    2.  whenever a new record is saved, copy Text value to ID field.

    3. bind search text with ID on UI

    Best Regards

    Fred

    Add comment
    10|10000 characters needed characters exceeded