ApiServer: Configure service categories and products to display

I guess we'll need to code it, although it does not seem to be hardcoded. Let's take the case of the service categories. This is implemented as a GET portal/shop/categories (see new-request-product.component.ts) that returns a list of service categories for a given, comma separated, uid_Person list. It would also take a filter .

Now, and in that I agree, the filter configuration is far from being a normal string with an sql expression such as those we used in the configurable options for the old web designer, like VI_ITShop_Filter_AccProduct . I would appreciate if one of the experts could give us a hint on how we could set up a filter and how the Expression and FilterType.Expression elements work , so we can create our own config keys in the admin portal and use them in our code.

Thanks for pointing out the 'Filter' option of the serviceitems end-point.
I discarded it too hastily as a proper solution for my use case.

New plan...

Create custom column CCC_IsToHideFromEmployee@AccProduct
Set 'Show in wizards' option on the new column in Designer (IsFilterDesignerEnabled = 1)

Check end-point with filter:
https://itshop.groot.net/apiserverdev/portal/shop/serviceitems?PageSize=20&UID_Person=d941eb12-57c6-4362-8045-846300a54421&
filter=[{"Expression":{"Expressions":[{"PropertyId":"CCC_IsToHideFromEmployee","Operator":"=","LogOperator":0,"Value":1}],"LogOperator":0}}]

Use existing or create new 'program function/feature' (Table: DialogFeature) to have a conditional lever in the angular project
In this case only managers can see the AccProducts where CCC_IsToHideFromEmployee = 1
Managers have the 'Portal_UI_PersonManager' feature per default

In the Angular project something like...

if (!this.isManagerForPersons) {
 this.navigationState = {
      ...{ PageSize: settingsService.DefaultPageSize, StartIndex: 0 },
      ...{
        filter: [
          { ColumnName: 'CCC_IsToHideFromEmployee',
            Type: FilterType.Compare,
            CompareOp: CompareOperator.Equal,
            Value1: 0,
          },
        ],
      },
    };

Thanks for pointing out the 'Filter' option of the serviceitems end-point.
I discarded it too hastily as a proper solution for my use case.

New plan...

Create custom column CCC_IsToHideFromEmployee@AccProduct
Set 'Show in wizards' option on the new column in Designer (IsFilterDesignerEnabled = 1)

Check end-point with filter:
https://itshop.groot.net/apiserverdev/portal/shop/serviceitems?PageSize=20&UID_Person=d941eb12-57c6-4362-8045-846300a54421&
filter=[{"Expression":{"Expressions":[{"PropertyId":"CCC_IsToHideFromEmployee","Operator":"=","LogOperator":0,"Value":1}],"LogOperator":0}}]

Use existing or create new 'program function/feature' (Table: DialogFeature) to have a conditional lever in the angular project
In this case only managers can see the AccProducts where CCC_IsToHideFromEmployee = 1
Managers have the 'Portal_UI_PersonManager' feature per default

In the Angular project something like...

if (!this.isManagerForPersons) {
 this.navigationState = {
      ...{ PageSize: settingsService.DefaultPageSize, StartIndex: 0 },
      ...{
        filter: [
          { ColumnName: 'CCC_IsToHideFromEmployee',
            Type: FilterType.Compare,
            CompareOp: CompareOperator.Equal,
            Value1: 0,
          },
        ],
      },
    };