How is your experience with the OutSystems Community?
23
Views
1
Comments
LoggedIn users logic

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"

    or

    (

        SelectedOption = "FreeCapacity"

        and Index(gold_rm_board_issues.labels, "Free_Capacity") >= 0

        and gold_rm_board_issues.status <> "Done"

    )

)

2026-07-23 14-34-51
Nuno Reis
 
MVP

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?

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.