Skip to Content

In Continuation with Previous blog: MDM Expressions: Use of Callable Function in Search Capabilities (Part 1)

Here, I elaborate a scenario with complete step by step screen-shots for your understanding. 

I have four records in my Main table which is linked to Category Bottle. Bottle has two Attributes named Color and Material Type. I want to search a record which is fulfilling criteria of color has multi-values RED;BLUE;YELLOW and for Material Type it should two values as Copper;PVC as shown in below screen-shot for your reference. LEXAN ID 300

image

 

Now have a look at other three records also with linked Category and their Attribute Values. LEXAN ID 900

image

 

LEXAN IP 300

image

 

LEXAN IP 600

image

 

Now to search this criteria, this is not possible either using Free Form Search OR Drill  Down Search. This is where Callable function is important and makes significance in searching capabilities using Expression under Free Form Search. 

Now create a validation named Callable Function as shown in below screen-shot. 

image

 

Now right click on validation Callable Function->Add Branch
Select Property Branch Value as Bottle as shown in below screen-shot.

image

 

In this validation Callable Function [Bottle], write expression as shown below: 

image

 

Now For searching you can use this callable function in Expressions of free-form search. For searching record, Go To Free Form Search->Click on Expression as shown below. 

image

 

An Expression pop up window will appear and under Function Drop-down list you can select Callable Function as shown in below screen-shot. 

image

 

Now once it is done, you will get the desired result as shown below.

image

 

This is one example where Callable function can be used in Searching records. So use of Callable Functions is very handy in searching complex records requirement. Similarly you can think and make use of Callable Functions in other ways as per your requirement.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply