topic Re: BAPI_USER_GETLIST filtering data in Application Development and Automation Discussions

BAPI_USER_GETLIST filtering data

lrayapat73 — Thu, 31 Dec 2020 12:24:08 GMT

Hi All,

I am trying get all users with certain filters like FirstName="somename", LastName=somename", pls. refer below, how can I pass logical oprtation like "or" , currently with below code it's always going as "and" operation, all the users where FIRSTNAME="Ellena" and LASTNAME="Clarc". But I want as FIRSTNAME="Ellena" or LASTNAME="Clarc"

Code using with .Net connector NCO 3.0,

IRfcFunction fnGetAllUsers = repo.CreateFunction("BAPI_USER_GETLIST");

IRfcTable selectionRange = fnGetAllUsers.GetTable("SELECTION_RANGE");

selectionRange.Append();

selectionRange.SetValue("PARAMETER", "ADDRESS");

selectionRange.SetValue("FIELD", "FIRSTNAME");

selectionRange.SetValue("SIGN", "I");

selectionRange.SetValue("OPTION", "EQ");

selectionRange.SetValue("LOW", "Ellena");

selectionRange.Append();

selectionRange.SetValue("PARAMETER", "ADDRESS");

selectionRange.SetValue("FIELD", "LastNAME");

selectionRange.SetValue("SIGN", "I");

selectionRange.SetValue("OPTION", "EQ");

selectionRange.SetValue("LOW", "Clarc");

Thanks,

Kumar

Re: BAPI_USER_GETLIST filtering data

jmodaal — Thu, 31 Dec 2020 13:17:11 GMT

Hello,

try it using the SELECTION_EXP parameter, filling the first row with 'OR' and specification of 2 following selection criteria that has to be considered. See attached screenshot.

Re: BAPI_USER_GETLIST filtering data

lrayapat73 — Wed, 06 Jan 2021 06:27:43 GMT

Thank you Jan, it's working as explained above.

Is it possible to do like below,

(FIRSTNAME='ELLENA' or LASTNAME='Clarc') AND (E_MAIL='test@test.com' or Department='Sales')

In my application user gets an option to choose the filters, with 'AND', 'OR' combinations.

Re: BAPI_USER_GETLIST filtering data

jmodaal — Wed, 06 Jan 2021 08:28:30 GMT

Hello,

I think that this is not possible in a single call. So, for the selection you gave, you have to call the function module twice and use the intersection of both result lists.

Re: BAPI_USER_GETLIST filtering data

lrayapat73 — Wed, 06 Jan 2021 09:52:18 GMT

Ok, thanks Jan.

Re: BAPI_USER_GETLIST filtering data

lrayapat73 — Wed, 06 Jan 2021 10:33:22 GMT

Hello,

is it possible to search on UserName? Not sure what is the parameter value for Username?

selectionRange.Append();

selectionRange.SetValue("PARAMETER", "<???>");

selectionRange.SetValue("FIELD", "USERNAME");

selectionRange.SetValue("SIGN", "I");

selectionRange.SetValue("OPTION", "EQ");

selectionRange.SetValue("LOW", "Clarc");

Re: BAPI_USER_GETLIST filtering data

jmodaal — Wed, 06 Jan 2021 15:06:57 GMT

Hello,

in that case you have to use the other parameter table SELECTION_RANGE.

Re: BAPI_USER_GETLIST filtering data

lrayapat73 — Thu, 07 Jan 2021 10:22:20 GMT

Thanks Jan.

It's working even with selection exp, with out "Field" property.

selectionExpression.Append();

selectionExpression.SetValue("LOGOP", "AND");

selectionExpression.SetValue("ARITY", "0");

selectionExpression.Append();

selectionExpression.SetValue("PARAMETER", "USERNAME");

// selectionExpression.SetValue("FIELD", "USERNAME");

selectionExpression.SetValue("OPTION", "EQ");

selectionExpression.SetValue("LOW", "TestUserName1");