AX7: Storing queries in the URL


In earlier versions of AX you could store queries you did in forms and then add them to favorites to be just one click away from a filtered form.
Did you know that you can do the same thing in AX7?

Here is how:

First you need to activate a parameter on your user options called “URL Manipulation” (User options > Preferences > Miscellaneous > URL Manipulation)

AX7_URLManipulation.png

This will, when you do a form query, add the “q” parameter to your URL. The data is an encoded string representing the query.

This is  an example of a query for Account numbers starting with US in the “All customers” (CustTableListPage) form:

AX7_URLManipulationFilter1

Resulting in the following URL:

https://[YourURL].cloudax.dynamics.com/?cmp=usmf&mi=CustTableListPage&q=AQAAADFCybBpzE4abl5b6rZo5ooytoBPoXUZV2YRzvwfRUyQ6TuSDopIQbohIVz5cFU4AXZxJznn9uUMdXtWbhCgyNHnhXQa5meSwNceGv3P4Pr9mb2V7RJmBBbruBbMHYHhZJG%2BIRr7JnT9%2F2EHzHwNeiA5pA%2Fb30Sewgv20e4nsLdKA%2F6Xe6aNcuwYJ0kSQBJAQdTi691SjJhSJ7tmayHapXDu%2F2NDV3Zn9dOsIk2sBwiBJJ6omSxdbOqGA9CTP%2F3NKTGjUHq6DJomyJKRe00E7eMoc%2FrcIDdyrB%2BwfTFcygUJfMk3fOdw3n%2FvpD17L5ZCkwqK985kUEOPxy5n5wnvqS%2Fw5iZl8GB7w88ecKT29%2F0mcJWsR64FhLIK4Wagnb%2F8a06HNNWj9SMJwhT%2Fi03rHEFhbxudVGKmT3CWtekZlp4LZ4NCWGTVMngMUZkDM6FsBqpfgBPSGeq5NC9%2FKA5x4hGRJEStLYwJKtbrfgazl%2F575sfbqr%2FFKbAh9R%2B1vcBAS8v7iZ3JycwiKYUTuYAmnvKSO%2BXAqEM65n9Zo1n1TpC05xUelRqZwiG7V%2BkXUHkBVWZEs7cseEI%2F2MLoRfsh8zNdw1aHJMov5D3a9EE5BivIQ4ohkVB%2Fz77WcGh81RhWtyzW9exhYscnaHMHNr%2FDOTJipRFSxnpo6jB4%2BvX3%2FyIK4fL7blY27JAzE4kXZpQCdyNyEFSI6zLYLfvkSWJGc8gaedOVKVjMdxryqgt1LOremnXKT5oAD9XJ%2BNDvcLk9ZqOlq63XCvqYaL9%2BasgDuxA4bOtINLCVnB9AvZKGHHTjVzpwYJsHmKwOS9ZPFhapSGP6NZlCtRqPExxVG8I%2F2ZnR2s73ylZs0K3FiXX%2B%2BT9C9WCpkTMqBpb%2F6D%2B80etR1tvDUhiv7VqbcIfpLwMZOyGOomNwb%2BzlUGTlxONeeMeWE1eNPptMrBFEJa%2BK697atNgQEgV62ozPpIVdCqOluTBatSlrEtzqPnx9jrIiqYAT62ZEBLxwGejwyk8axYSzswygoHX7qMKW

 

Opening the URL directly will open with the specified filters.

It does open it in the details form which I don’t know the reason for.

AX7_URLManipulationFilter2
This is result of opening the URL …
AX7_URLManipulationFilter3
… and the filters are there.

 

Leave a comment