Using both 'AND' 'OR' keyword search for keywords

[RFJ1]

Hi All, 

I have to query records based on the following keywords in the work notes or comments in the incident table

(user OR username OR email OR id) AND (pass OR password OR passwd OR key)

I need to use both AND OR Boolean operations for filtering this using the keyword. Can anyone help me on this?

I tried using only 'OR' keyword but need to use 'AND' also, how can I do it?

Thanks,

RFJ

[AndersBGS]

Hi @RFJ1 ,

According to your requirement: "(user OR username OR email OR id) AND (pass OR password OR passwd OR key)" I would create it as below:

User AND pass or password or passwd or key OR

username and pass or password or passwd or key OR

email and pass or password or passwd or key OR

id and pass or password or passwd or key

Above should resolve your question. If you need more specified help, please let me know which table and field your condition should run on, as I don't think you will have user OR username OR email OR id coming from the work notes or comments field. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[RFJ1]

Hi @AndersBGS ,

I am searching in incident table and finding any records that may contain sensitive info like password or username in worknotes and comments. I will try your method.

Thanks!

[RFJ1]

Hi @AndersBGS ,

What is the difference between small case 'and or' compared to upper case 'AND OR' from your response?

[AndersBGS]

Hi @RFJ1 ,

The small or is Description contains XX or XX, where as the big OR is all these conditions is true OR all these conditions is true - see example below:

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders