Hello everyone.
I have a screen when I click on Show only my tickts - logged in users tickets should be seen in the DemandNumber dropdown and when free capacity is selected, I should see all the tickets in the Demand Number which are free. This filter should work together. Please assist on the same.
I have added the below filter but it did not owrk.
Below is the screenshot of the task
(
ShowMyTicketsOnly= False
or
gold_rm_board_issues.assignee_id = GetUserId()
)
and
SelectedOption = "AllDemands"
SelectedOption = "FreeCapacity"
and Index(gold_rm_board_issues.labels, "Free_Capacity") >= 0
and gold_rm_board_issues.status <> "Done"
Hello.
You have too much text in the conditions, that will slow down the query.
Can you share the structure of the table to clarify what you are working with?