User based query
How do we write a query for last 3 quotation for a particular item and a particular customer created by a particular user.
I want to create a single for all users and assign it as formatted search.
Suda Sampath replied
Type parameter has options
Number, Date, Currency
Example: If you notice the Unit Price column you have the Currrency symbol also included in the value. To extract just the number part exluding the currency symbol you will use the .Number type
Please go this document on defining Formatted Searches which explains it all