Adding additional AML parameters to the quick search?

Question

Hello, 
 Is there a blog anywhere on finding a way to edit the default AML sent with quick search? 
 For instance, when typing in, I want the records retrieved to be of a certain WHERE condition all the time. 
 Best Regards, 
 Frank

AngelaIp · Accepted Answer

Overwriting the default AML on general level sounds like a bit of an overkill for your use case. 
 1. You can use the "Default Search" column in the ItemType property relationship. E.g. you can add a filter to the state property and by default the grid will only display items with this state. I use this for ECOs so people only see stuff that isn&acute;t completed yet. Pro: User can see the filter and remove it when needed. 
 2. onBeforeGet Method can overwrite AML query. I do something similar with the select query: How to color grid cells according to properties that are hidden in grid? 
 Look at the "select" sample code below the green Chris answer. Should work for "where" the same way. I use it since years.

bubblyeducate · Answer

You can use the "Default Search" column from the ItemType property relationship. For example, you can apply a filter to the state property, and the grid will only display objects that have this state. I use this for ECOs so that people only see things that haven't been completed yet. Pro: The user may view the filter and delete it as needed.

Adding additional AML parameters to the quick search?

Top Replies

Legal

Connect With Us