[SOLVED] Sc_where_add and refinded search or quicksearch not work

Scriptcase 9 Bugs
#1

I have a field “employeeprofileID” with entries e.g. 1,2,6. I want that when the grid is started, user 1 can only see the data of employeeprofileid 1.

How do I proceed? netmake advertises scriptcase with the argument “without coding” without knowledge. i think what i want is pretty standard and should be possible in such a development environment.

In the forum (since 2015) this non-functioning macro is also often pointed out without the netmake providing a solution

Where is the multi-user function?

1 Like
#2

Why not just add it directly into the WHERE SQL statement on the Grid

WHERE employeeprofileID = [employeeprofileID]

#3

When you use sc_select_where(add) always add parenthesis around your code like

sc_select_where(add) = "AND (fieldX = [global_variable])";

1 Like
#4

the record level access is not a basic feature and i am glad it is done via the code. it gives the most flexibility. some IDE try to built it in the interface but … what if you want to test it and delegate rights , or access records for the whole team or built in some task planning and assign work?

i agree , more examples are welcome from SC. SC is a low code solution, they say you can achieve a lot without coding , even build a whole solution without coding, this is different. IMHO

#5

Of course, I got so fixated on it that I didn’t think about it!

Thanks, problem solved!

1 Like