SQL Report no filters

May Cai shared this question 3 years ago
Answered

I am writing a new report using freehand sql under advance authoring. After I wrote the report, the data doesn't give me any filters option unlike other regular report. Is it true that filters do not apply to freehand sql?

Best Answer
photo

Hi May Cai,

Thanks for your email.

In order to get a filter in the FREEHANDSQL report you need to define the parameters and assign the column you want to filter on.

I have attached a couple of screenshots, please see below:

a71d2b8b4feee4368c8ae5875e99570f


ce6bb1f6244f867daed8cdf04e52ed0f


91e589ff1212364f656e2fb278b3c9fb


3b5c494f838db914d1188984e0e4fedf

I hope this will help you.

Let me know if you have any questions.

Regards,

Mahe

Comments (4)

photo
1

Hi May Cai,

Thanks for your email.

In order to get a filter in the FREEHANDSQL report you need to define the parameters and assign the column you want to filter on.

I have attached a couple of screenshots, please see below:

a71d2b8b4feee4368c8ae5875e99570f


ce6bb1f6244f867daed8cdf04e52ed0f


91e589ff1212364f656e2fb278b3c9fb


3b5c494f838db914d1188984e0e4fedf

I hope this will help you.

Let me know if you have any questions.

Regards,

Mahe

photo
1

Hi Mahe,

Thanks! It seems that I cannot change the filter logic? It shows me "equal to" under the advance setting under Filters.

photo
photo
1

Hi May Cai,

I am not in office.

I will get back to you on this by Monday.

Let me know if you have any questions.

Regards,

Mahe

photo
1

Hi May Cai,

Yes, we can only use Equal to at the moment.

You can probably raise an idea ticket, explaining the use case and the options you are looking for.

Let me know if you have any questions.

Regards,

Mahe

photo
1

Hi May Cai,

Hope you are doing well.

I am just wondering if you have any questions on this ticket.

If everything is ok, I may mark this ticket as answered.

Regards,

Mahesh