Removing locations from IT Shop (109787)

Removing locations from IT Shop

You need to remove locations that are available in the "Add Employee" section of IT Shop as they are no longer active locations in the organizations.

Is there a way to hide/un-publish locations in Manager so they do not appear in the IT shop?  When trying to remove a location from Manager, "Organizations", "Locations", Right-click "Location" choose "Delete", an error message appears saying that a location cannot be deleted with Employees assigned to it.

Deleting locations in Manager is not an option while there are linked employees.

An ideal solution is to filter the locations that appear in IT Shop using Web Designer.

In Web Designer choose Edit | Configure Project | Column-dependent references...

Click the green plus symbol to create a new entry.

In the example of Locations select the Person table, column Person.UID_Locality.  Locate the correct component you want to make changes to in your form and select it in the "Component" drop down.  For example, VI_Edit_FK.

Then in the "Foreign key filter" use the wizard to build a filter for the Locations you want to appear.  For example, to filter those that begin with the letter 'D' you could enter: "(isnull(Ident_locality, N'') <> N'%d').  Using the WHERE clause wizard is the easiest way to do this.

Test your changes in the Web designer preview to confirm you get the desired results.