topic Re: resolve problem without touching datamodel in Management & Governance

resolve problem without touching datamodel

zied_ahmed1 — Mon, 27 Aug 2018 09:03:25 GMT

Hello everybody,

Thanks for your answers. I attached an example of the application.Just one thing when I selected Color in Exist I can't select it in not exist

so now for example when I select color in Exist and Entreprise in not exist I will have a table with just one row with the hostname X

Hope you understand how I need to do

Thanks

omarbensalem‌

Re: resolve problem without touching datamodel

OmarBenSalem — Mon, 27 Aug 2018 09:08:01 GMT

what are those?

Re: resolve problem without touching datamodel

zied_ahmed1 — Mon, 27 Aug 2018 09:15:34 GMT

Sorry...

Re: resolve problem without touching datamodel

zied_ahmed1 — Mon, 27 Aug 2018 09:16:44 GMT

if for exemple we select Statut Exist and Entreprise Not Exist we will have just the row Hostname x.

Re: resolve problem without touching datamodel

OmarBenSalem — Mon, 27 Aug 2018 09:18:19 GMT

Now please explain in better words with some examples;

if u select statut in exist what happens?

if u select statut in exist and rentrprise in not exists, what should happen?

etc

Re: resolve problem without touching datamodel

OmarBenSalem — Mon, 27 Aug 2018 09:19:45 GMT

but u can't select both Statut in exist and ntreprise in Noty exists:

Re: resolve problem without touching datamodel

zied_ahmed1 — Mon, 27 Aug 2018 09:29:41 GMT

Okay..

I used to do the same model but in the real model when you select Color in Exist field it will be disable in the field not Exist

For the example like i said , if select Statut in Exist (Exist is like Statut = 1 in table ) and Entreprise in Not Exist (it means 0 in the table )

-> I will display just the row of hostname X

Re: resolve problem without touching datamodel

OmarBenSalem — Mon, 27 Aug 2018 09:35:41 GMT

Then reattach an application like the real model, PLEASE.

Re: resolve problem without touching datamodel

zied_ahmed1 — Mon, 27 Aug 2018 09:38:22 GMT

I can't export the application that's why

Re: resolve problem without touching datamodel

OmarBenSalem — Tue, 28 Aug 2018 12:03:49 GMT

For me the easiest way to achieve this is to add 2 columns in your final table:

Controler1:

=if([Not Exists]='Statut', aggr(sum({<Statut={0}>}1),Hostname) ,

if([Not Exists]='Entreprise', aggr(sum({<Entreprise={0}>}1),Hostname) ,

if([Not Exists]='Color', aggr(sum({<Color={0}>}1),Hostname) ,Statut )))

Controler2:

=if(Exist='Statut', aggr(sum({<Statut={1}>}1),Hostname) ,

if(Exist='Entreprise', aggr(sum({<Entreprise={1}>}1),Hostname) ,

if(Exist='Color', aggr(sum({<Color={1}>}1),Hostname) ,Statut )))

Result:

Example,

exists ; Statut

No exists : color:

Re: resolve problem without touching datamodel

OmarBenSalem — Tue, 28 Aug 2018 12:04:42 GMT

stalwar1‌, how can I combine my 2 controlers into one?

Re: resolve problem without touching datamodel

sunny_talwar — Tue, 28 Aug 2018 12:08:00 GMT

I am not sure I understand what you mean when you say combine 2 controllers into one?

Re: resolve problem without touching datamodel

OmarBenSalem — Tue, 28 Aug 2018 12:09:41 GMT

So that zied's demand works as he wants it to; the only solution I've found is to use these 2 controlers.

I was hoping that u'd find another way to do it?