User prompt Filters for Relational Operators

Hi Chandana,

Thanks for your email.

I believe, this similar issue is raised by Venu Gopal K.

I have converted his ticket into idea ticket.

Is it ok if I merge your ticket with Venu Gopal ticket.

Let me know if you have any concerns.

Regards,

Mahesh

Hi,

I have requirement where i have three prompt values:

1. Department

2. Relational Operator (<,>,<=,>=,<>,etc)- This also should be user prompt

3. Years of Service (Measure)

The above three filters should be user prompt, as i know 1 and 3 but i don't know how to provide user prompt for option 2. Would be great if you can let me know any workaround or direct solution.

Example:

Scenario 1: When user executes the report, the selection would be as follows:

1. Department ---> Finance

2. Operator ---> >= (greater than or equal)

3. Years of Service ---> 8

Scenario 2: When user executes the same report second time, the selection would be as follows:

1. Department ---> Sales

2. Operator ---> = (equal)

3. Years of Service ---> 12

Hence i am looking for the above prompts should be Dyanmic selection.

Thanks,

Venu

Hi Venu Gopal,

Thanks for your email with the scenarios.

At the moment this is only possible while designing the report but not while executing the report, user will not be able to choose unless they edit the report.

This will be a good idea to give the flexibility for the user to choose the operators while running the report.

If you are happy, I can convert this ticket to idea.

Let me know if you have any concerns or questions.

Regards,

Mahesh

Venu Gopal K ● 3 days ago via Community

thanks for the update. Would be great if you can convert this ticket as Idea

Thanks,

Venu

Hi Chandana and Venu Gopal,

I have converted this to Idea Ticket.

You might have received some emails. Just ignore them.

Regards,

Mahesh

Hi Chandana and Venu Gopal,

I have logged the enhancement ticket internally and the ID is: 10331.

I will update you once it is implemented or you may also check the update for this ticket on our community Website.

Regards,

Mahesh