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
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
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´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.
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´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.
Copyright © 2025 Aras. All rights reserved.