Skip to main content

Connect to a User Query

Function data​

One of the SAP Business One elements which can be connected are User Queries. This is done by selecting the Technical Handler SAPB1_UserQuery - vx.x.x (latest) within the Function data section of the Function configuration. As usual the other variables and information like the Short Name and the System have to be specified. Please find the general details in the Portal's create a new Function section, also for how to create a Function. Beside the Function data, the following types of information have to be specified as follows:

Authentication Configuration​

In case the "Shared Basic Auth (User and Password)" is configured by the Admin at system-level, nothing has to be specified. Otherwise enter the "User" and a "Password" which should be specifically used for this Function.

Technical parameters​

The only technical parameter which has to be specified for the SAPB1_UserQuery is the QUERY_NAME. Please enter the name of the query to be connected.

User parameters​

In general all Parameters are available and can by applied, if the underlying user query can support the parameter type.

However there are some general limitations and disclaimers:

  • Due tue security reasons VDP does not allow parameters embedded in strings (e.g. "2024-[%0]-01"). Please use the CONCAT SQL-function in this case (e.g. CONCAT("2024-",[%0],"-01")).

  • A placeholder (in a user query) of the form [%<number>] must always be represented by a Parameter with "POSITION" = <number>. The name of the parameter is irrelevant. If the placeholder [%<number>] occurs multiple times, the value of the VDP parameter will be automatically replicated accordingly.

If VDP parameters are created whose value in the "POSITION" field does not exist in the user query, they will simply be ignored. However, if there are placeholders for which corresponding VDP parameters have not been created, an error will occur.