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
Now have a look at other three records also with linked Category and their Attribute Values. LEXAN ID 900
LEXAN IP 300
LEXAN IP 600
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.
Now right click on validation Callable Function->Add Branch
Select Property Branch Value as Bottle as shown in below screen-shot.
In this validation Callable Function [Bottle], write expression as shown below:
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.
An Expression pop up window will appear and under Function Drop-down list you can select Callable Function as shown in below screen-shot.
Now once it is done, you will get the desired result as shown below.
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.
