TAGS :Viewed: 4 - Published at: a few seconds ago

[ Is there a way to add more text to a range value? ]

I'm trying to extend a query in Dynamics AX that populates the "My Projects" window. I've found the query that I need to modify, and tried to modify it, unfortunately, the character limit in the Value field (see screen shot), is not sufficient to allow me to enter all of the text I need to extend this query.

enter image description here

I've explored adding additional ranges, but I need to add additional OR arguments here and it appears that adding additional ranges will AND the range instead of ORing it.

Is there any way to bypass this character limit?

Answer 1

If you add several ranges to the same datasource field, the ranges are combined with OR in the SQL.

This is useful sometimes. See this queustion for a (klunky) example.