There is a client list 'app_client' that I record client J! user id, adviser id and office id in it. all other records in other tables are related to the clients list by a database join element.
right now I have to save J! user id, adviser id and office id in all records include client id that saved by database join.
Is it possible to use a SQL query in pre-filter to avoid save J! user id, adviser id and office id? and show them to the related users?
right now I have to save J! user id, adviser id and office id in all records include client id that saved by database join.
Is it possible to use a SQL query in pre-filter to avoid save J! user id, adviser id and office id? and show them to the related users?
Last edited: