Create a data partition

[Felipe Nunes]

Hi everyone,

I would like to create a data partition where the user can see the CI's from 3 different families or the CI's configured on user register (environment). 

So, I tried this configuration:

((family.sym = 'Hardware.Estação de trabalho') AND (cntref.cnt =@root.id)) OR ((family.sym = 'Hardware.Impressora') AND (cntref.cnt =@root.id)) OR ((family.sym = 'Hardware.Monitor')) or cntref.cnt =@root.id

But this condition result in a Cartesian product. 

So, I tried this configuration: 

((family.sym = 'Hardware.Estação de trabalho' or family.sym = 'Hardware.Impressora' or family.sym = 'Hardware.Monitor') and (cntref.cnt =@root.id)) OR
((family.sym = 'Hardware.Estação de trabalho' or family.sym = 'Hardware.Impressora' or family.sym = 'Hardware.Monitor') and (cntref.cnt != @root.id)) 

As can see below, It's saved without error:

But when I try to search the CI's, none of them is showed. 

Anyone has idea to solve this problem?  

------------------------------
Regards,
Felipe Nunes
------------------
IT Analyst
Prodabel
------------------------------

[Jean-Pierre Marsan]

Hi,

Try this :

family.sym IN ('Hardware.Estação de trabalho', 'Hardware.Impressora', 'Hardware.Monitor') OR cntref.cnt IN (@root.id)

Regards

[Felipe Nunes]

Hi Jean,

First of all, thank you for your replay.

I tried as you suggested, but result in a Cartesian product. 

------------------------------
Regards,
Felipe Nunes
------------------
IT Analyst
Prodabel
------------------------------

[thiagooliveira]

Hello Felipe,

Check these KD:

https://knowledge.broadcom.com/external/article/15895

https://knowledge.broadcom.com/external/article?articleId=50056

------------------------------
Best regards.
LinkedIn:
https://pt.linkedin.com/in/thiago-23-oliveira
------------------------------

[Felipe Nunes]

Hi @thiagooliveira,

I've already seen this KD before open the case. 

Thanks for you support.

------------------------------
Regards,
Felipe Nunes
------------------
IT Analyst
Prodabel
------------------------------

[Vito Francesco Mazzotta]

Hi,

did you check the SQL statement if it realize what are you looking for?

I hope this helps,

Vito

------------------------------
Vito Francesco Mazzotta
Regional Technology Officer | EMEA South Italy
Broadcom
mobile: [phone]


[e-mail] | broadcom.com

linkedin.com/in/vito-francesco-mazzotta-802918
------------------------------

[Felipe Nunes]

Hi Vito, 

I don't know how to create de sql query for this condition. Has any idea? 

------------------------------
Regards,
Felipe Nunes
------------------
IT Analyst
Prodabel
------------------------------

[Felipe V]

Hi @Felipe Nunes,

I think that exist a little bit complex way, as previously show example in the link below:

Data partition generating a Cartesian product

You should split the logic on 2 restrictions. Follow the link logic, can be implemented as:

(cntref.cnt = @root.id) AND (family.sym = 'Hardware.Estação de trabalho')) OR
((cntref.cnt != @root.id) AND (family.sym = 'Hardware.Estação de trabalho')) OR
((cntref.cnt = @root.id) AND (family.sym != 'Hardware.Estação de trabalho'))

AND second restriction:

((cntref.cnt = @root.id) AND (family.sym = 'Hardware.Impressora')) OR
((cntref.cnt != @root.id) AND (family.sym = 'Hardware.Impressora')) OR
((cntref.cnt = @root.id) AND (family.sym != 'Hardware.Impressora'))

Case it's works fine, you can improve implementation for 1 restriction more complex. 

------------------------------
Regards,
Felipe Vandrilho

Linkedin: https://www.linkedin.com/in/vandrilho/
------------------------------

[Felipe Nunes]

Hi @Felipe V,

First of all, thank you for your replay.

I did as you suggested, and I could save the condition. But when I search for CI's, only shows one CI in my environment (And I have 3 CI's in my environment). 

I don't know if I can do this. I will create another data partition and separate the condition. 

------------------------------
Regards,
Felipe Nunes
------------------
IT Analyst
Prodabel
------------------------------