FlexQuery supports the following command-line:

  • C:<Category Name> –  launches FlexQuery filtering out all other categories.
  • T:<Type Name> – launches FlexQuery filtering out all other Types.
  • G:<Group Name> – launches FlexQuery filtering out all other Groups.
  • -R or -REPAIR – schedules a database repair.
  • A:<Group Name> or AUTO:<Group Name> – automatically executes the Custom Views assigned to a group.  Requires pre-configuration in the Custom View Designer and the existence of a FlexEcute Module License to automate exports.

There are a number of ways to configure this. Basically a query intended for one location should have a query filter that  pre-filters for that location e.g.
image (3)

 

The store filter creates the necessary filtering for the store. In the example above, the ‘Viewer’ group would be for Head Office use to isolate the viewer queries from the rest. The ‘Store1’ group is what would be used for the shortcut command line. You will need to assign all queries with a ‘store1’ filter to this group and only this group.  Since the saved filter can be complex, it can filter for subsidiary and store (or a group of stores). The only criterion is that it identifies the data permitted to be seen.

The shortcut target would look like:

C:\RIQ\FlexQuery.exe “G:Store 1”

Quotes around the Group parameter are only needed if the group name contains a space.

When installed on a Citrix or Terminal Services environment, the FlexQuery installer creates an icon to launch FlexQuery in the All Users desktop.  Therefore to create a custom icon with a command line parameter with specific settings, the icon will need to be removed from the All Users desktop and copied the the logged in user’s desktop.  Also, as no security exists within FlexQuery to filter out stores or subsidiaries security should be added to the icon to prevent it from being edited as removing the group filter, for example, would allow access to all Custom Views, whether they are filtered or not.