Hi @Daniel Diers ,

After a short view of your problem I see that you are referring to the variable as <=%PO%>, there is a small type, it actually should be <%=PO%>, the equals sign should go after the percentage.

Hope it helps

Javier

To avoid such small typos in the future, I always recommend using the functionality of the PQL editor to use the prebuilt snippets which always provide you with the correct syntax.

Best

Kevin

@Kevin, yes good tip, however, having experienced typed languages, it would be fantastic to have a vs-code like type checking!!

Good suggestions. In this case I recommend opening a ServiceDesk ticket with a feature request so our product team is aware of this issue.

👍

Yes I second Kevin Opinion as PQL editor  functionality is better option as of now to avoid syntax error.

Thanks all for your answers, but problem is still there. The typo was just here in celopeers, not in Celonis, there it is correct. But problem is still there, instead of searching the PO-number (e.g. 4212345678) it searches for "EKPO"."EBELN".

Any idea why?

Thx and br

Daniel

Hi Daniel,

now I understand your issue... variables here do not work in the same way. What you would need to do is use the col.. variable. Col1, col2, col3 indicates in which column in your OLAP table the Purchase Order Number stands. I am not sure if it considers hidden columns as well but I would recommend just trying it out. So what you essentially need to do is: 414D1&view=7&q=<=%col1%> --> this would mean that your PO number stands in column 1 of your table. If it stands in column 3 then you would need to use col3.

It also says it in the description once you enable the functionality. The behavior it has currently is correct because you are adding <%=PO%> to your URL and the variable PO is EKPO.EBELN --> correct behavior.

Thx @kevin.flesc , now it works, but for the local variable it is indeed <%=col7%>, so % and = switched.

&view=7&q=<%=col7%>

Now it is searching for the PO-number from column 7 on the OneDrive, great :-)

Great, glad it works! Yes, you are absolutely right, sorry for the typo ;)