HighAley wrote: ↑Thu Apr 11, 2019 10:40 am All that you can do is to pass necessary information to the report right after loading it.
At this moment you should know the tenant and you could use this variable anywhere inside the report.

This is exactly my question. How can I pass it to the report so it will be available within a function

Hi, Let us try to put all together, because I have a feeling we speek different languages. 1. There is a multi tenant system 2. Report is executed for one of the tenants 3. We are registering a custom function using StiFunctions.AddFunction("Category", "LookupCode", "LookupC...

Hi,

that sounds good, but how do I get this instance of report property in the body of the static custom function?

Thanks
Vitaly

Hi, let me try to explain step by step. * We have a multi-tenant system. * User USR1 executing an async task to generate a report for tenant ABC subsidiary EFG. * The report contains a custom function. * Within this function I have to know that the generation is executed for "tenant ABC - subsi...

Hi,

I know we can and we are doing it. But as I mentioned before....

tayar wrote: ↑Fri Mar 15, 2019 9:03 am @HighAley,
we need is to be able to get a tenant context in a multi tenant environment to be able to execute different functions based on this context.

So how can we do it within the code of this function?

Thanks
Vitaly

HighAley wrote: ↑Sat Mar 16, 2019 3:49 pm Hello,

What kind of functions do you want to execute?

Hi,
We are talking here about custom functions added using StiFunctions.AddFunction.

Thanks
Vitaly

@HighAley,

Let me please generalize the question. The example mentioned by @Arysmyatov is only one use case.
What we really need is to be able to get a tenant context in a multi tenant environment to be able to execute different functions based on this context.
Thanks
Vitaly

Hello Lech, yes, this is correct. This query works. However the query has not been written manually but generated automatically by Stimulsoft designer while selecting the available tables. End user has no idea and knowledge that they need to modify query. Also in our environment they won't know anyt...

Hi Edward, The designer runs on Windows 10 x64. The DB is PostgreSQL 9.6.5 on x86_64-pc-linux-gnu (running within docker) Another interesting observation, the connection string in the report you sent contains Min Pool Size=0 wich is not recognized in my environment. The data adapter has been automat...

Hi Edward,

There is no workaround on the topic you mentioned. That topic mentions databases other than public.
This one says that even with pubic it does not work

Best regards
Vitaly