SAP user query

[Former Member]

Dear All,

Can we make our user query like this

If [%2] != 'C'

Begin

...

End

I tried on my side. It doesn't work. Is there anything wrong with my code? Thanks a lot.

Regards,

yuka

[Former Member · Accepted solution]

User input like [%2\] will not work based on your query. What do you need to achieve?

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks for reply. I would like to have 2 queries in the user query. If user input is not 'S' run query 1. Otherwise run query 2.

User input [%2]

If the input is not 'S'

...

else

...

end if

[Former Member · Accepted solution]

That is not supported within B1. You have to put [%2\] variable in the where clause.

[Former Member · Accepted solution]

Is there any other way I can make my query like that in user query? thanks

[Former Member · Accepted solution]

Using one query to display the result base on user inputs. Post your current query in mind to see.

[Former Member · Accepted solution]

So in SAP user query, if we have 2 queries, we have create 2 user queries? We cannot use input parameter to determine which one we would like to run? Thanks

[Former Member · Accepted solution]

I would do this:

Declare @campo nvarchar (3)

Set @campo = 'xxx'

IF @campo is null or Rtrim (@campo) =' '

BEGIN

Select * From Tabla T0

END

ELSE

IF @campo is not null or rtrim (@campo)< >' '

BEGIN

Select * From Tabla T0 Where T0.campo =@campo

END

-

---

With pop up variables is the same, just replace Declare query format with /* select from ...*/ variable syntax.

(If you need more information about the Declare in SAPB1 user queries, just let me know).

[Former Member]

That is right. You may not have options to create menu like interface for query to run.