Skip to Content
0
Nov 05, 2020 at 08:36 PM

Formatted search query for the Specific users/Users group

89 Views

Hello everybody,

I'm using the formatted search in the Service Call. Everything is ok, except that we have 2 teams with different UI Forms.

And when I changed the query for one field in one UI Form, it changed in another UI form also.

Is it possible to modify the query and show the data depending on User Name/User Groups?

For example,

If the User Group is CS1 the query should be:
SELECT T0.[Substitute], T0.[ItemCode], T1.ITEMNAME FROM OSCN T0 INNER JOIN OITM T1 ON T0.ITEMCODE = T1.ITEMCODE WHERE T0.[CardCode] = $[$14.0.0]

If the User Group is CS2 the query should be:

SELECT T0.[ItemCode] FROM OSCN T0 WHERE T0.[CardCode] = $[$14.0.0]

Thanks in advance.