IT Shop - Customer

Markus Weiss-Ehlers  Any suggestion please

I do understand your requirement completely. Can you please provide more details?

Hi Markus Weiss-Ehlers 

I have a application which is published currently in IT Shop.

Only the IT Support team should be eligible to raise a group membership of that application as they have more insight knowledge on the role/group suitable for the user profile and now the application is visible for all the users. Currently in approval flow we check whether it raised by IT Support to proceed, if not the request will be aborted.

The requirement is to only IT support user should see in web portal and they can raise for any users in the organization.

How to achieve this ?

TIA,

Aad

Hi,

FIrst or all, you would have to define a SQL filter clause to filter the service items (AccProduct) that the current user is allowed to request.

Then configure the API endpoint for service items by adding a configuration for shop_serviceitems in the Server Administration app under "Portal":

On the shop_serviceitems configuration object, insert the SQL WHERE clause that you need:

Hope this helps,

Hanno

Markus Weiss-Ehlers Hanno Bunjes 

It possible to implement this in older version of web portal and not the angular one.

Regards,

Aad

There are configuration keys for the legacy Web Portal as well that allow you to define the list of available service items based on the current user.

In Web Designer configure your web project and set the condition at the configuration key "VI_ITShop_Filter_AccProduct" (Products to display for a given recipient).

Hello Hanno,

Do you have chance to give an example for SQL Where clause. I want that all managers are able to see and request X product on behalf of an employee but employees shouldn't see X product in OneIM Web Portal. How can provie this? I couldn't write sql where clause query.

BR,

Volkan

Example: IsSpecialProduct@AccProduct = 1 only visible for managers.

IsSpecialProduct = 0
	OR (
		IsSpecialProduct = 1
		AND EXISTS (
			SELECT 1
			FROM PersonInAErole
			WHERE UID_AERole = 'QER-AEROLE-ALLMANAGER'
				AND UID_Person = '%useruid%'
			)
		)

Example: IsSpecialProduct@AccProduct = 1 only visible for managers.

IsSpecialProduct = 0
	OR (
		IsSpecialProduct = 1
		AND EXISTS (
			SELECT 1
			FROM PersonInAErole
			WHERE UID_AERole = 'QER-AEROLE-ALLMANAGER'
				AND UID_Person = '%useruid%'
			)
		)

For version 9.2.1 see release notes (this feature is also included in 9.1.3 released on April 2024 so after the 9.2 release)

In the Administration Portal, you can now define a filter using the
VI_ITShop_Filter_AccProduct configuration key. This filter determines
which service items are displayed in the Web Portal depending on the
selected request recipients.

You can now define a filter in the Administration Portal using the
VI_ITShop_Filter_AccProductGroup configuration key. This filter
determines which service categories are displayed in the Web Portal
depending on the selected request recipients.

Hello Niels,

It works. Thank you so much.