Custom ovs

[former_member187270]

Hi All, , ,

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 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.

[Former Member · Accepted solution]

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

[former_member187270 · Accepted solution]

Hi ,

Thanks for quick response.

I got it. Could you please help me in searching record with "*".

Thanks,

Quddus.

[Former Member · Accepted solution]

Hi Quddus:

Here is a document explaing how to use custom queries:

The (for you) important bit is about the "basic find" and the "SearchText" field binding at the end of chapter 1.1 (chapter 1.2 is strangely missing).

Apply that part to your OVS (you might need to modify the OVS to use a custom query though) and it will solve your placeholder search issue.

Best regards,

Ludger

--

Custom Development with all4cloud.de

[former_member187270 · Accepted solution]

Hi ,

Many Thanks... I achieved it.. .

Thanks,

Quddus.

[former_member200567]

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