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 Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s