Initial search?

Applications Search
#1

Hi,

I want to load my grid with initial search request : WHERE client = (user id connected from sec_users table).

  1. How to get user ID from sec_users for the current user connected ?
  2. How Initialize the request ?

During the other searches I no longer want any filter on the field CLIENT.

Idea ?

Thanks

#2
  1. In your Form Login, save the user ID in a global variable like “[glo_usr_id]”
  2. in your grid, in the “OnScript” event, play around with the “sc_select_where” macro.
1 Like
#3

Hello Jefch,

Thank You very much !

This is my solution :

  1. Save user ID from App login

app-login
app-login995Ă—632 42 KB

  1. Apply where query

where
where962Ă—407 21.2 KB

Now, how aplly this query only on load page and not during search request ? Because during search request, this is my error message :

where

Have a nice day !

1 Like
#4

My solution :

select-where
select-where1114Ă—519 29.2 KB

1 Like
#5

Great. Happy to know you have figured it out.