on 05-12-2016 11:24 PM
Dears,
I am using row level security in Universe using security profiles.
In that i have to match BOUSER with one column data, that column has multiple employee numbers in it.
structure of that column is like this:
5432-4578-8392-4021
and BOUSER can be either 4578 or the other, So i have to use LIKE operator here.
In Query we write something BOUSER like '%EmployeeNumbers%'
But in Security Profile, We can use Like but when i put query like above, it gives error of syntax.
It only allows BOUSER LIKE EmployeeNumbers,
I Just want to ask if the behavior is same or not.
BR,
Hassan
Hello Hassan,
What is your backend database?
Could you try with BOUSER like '*EmployeeNumbers*'
Regards
Niraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Niraj,
Thanks for responding.
Backend is SQL Server, But Security profile where clause doesnt accept SQL Server syntax.
I have tried.
'%EmployeeNumbers%'
'*EmployeeNumbers*'
it gives error in either case, when i try this:
'%'+EmployeeNumbers+'%'
It gives wrong data.
I am stuck here, Can you please help me out here as i dont know how to use LIKE operator here.
Hello Hassan,
I believe this is something where we have to search for a String in another string to get to know if first string is a part of second one or not.
In this case Like will not work I believe you may have to use CharIndex function of SQL Server.
Here's a link below that should help you with this.
Regards
Niraj
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.