Is it possible to write client script or BR on database view table

[VIKAS MISHRA]

I have merged few table including location table. now as per the below screenshot 3rd party team fetching all the information mentioned in this database view table along with country. 

I want to add one condition here in this table that if user is member of group "RSD" then instead of country code group name "RSD" should be visible in this table corresponding to that record. so that 3rd party team pick up that in integration . 

Please suggest if this is possbile.

[VIKAS MISHRA]

Please check that i have added group member table , as mentioned in the screenshot.

Howveevr due to this the record count in table increased from 12k to almost 2.5 lakh, as its showing record in multiple time due to group member table . 

Is it possible to add some "where clause" thrugh which its shows the same record it was showing earlier but also shows the group name only if the group name is "Regional service delievery" 

[Gurpreet07 · Accepted solution]

Hi Vikas,

Please try below in the where clause for group member table

gm_user = us_sys_id and gm_group = "sys_id of group Regional service delievery"

Also you may need to check left join for sys_user view table

[VIKAS MISHRA]

I have added the caluse mentioned by you, but its giving error 

[Gurpreet07]

use   and  instead of &&

[VIKAS MISHRA]

It worked completed fine for me, thanks for your effort.