Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Report manager - search by Operating system doesn't

    Scheduled Pinned Locked Moved Development
    5 Posts 2 Posters 776 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M Offline
      Milan Leszkow
      last edited by

      Hi.

      i-doit version: 27 PRO

      Report with condition of Operating system doesn't work.

      form context menu I choose desired OS name and it is placed as search condition.
      ea635894-1528-40b3-b189-0ae7cc0d8b1d-image.png

      After save and run report it doesn't run according to condition.
      Inspecting report with SQL editor I see, that condition is for

      isys_obj__id but compared to Operating system item title

      30b75f12-9dcc-4710-9dbe-d51ad3e5acbc-image.png

      instead to numerical ID

      reediting report with editor will drop then this condition:

      7dde1c6b-2343-4942-97bb-17d1977ed611-image.png

      It is possible to repiar report with SQL editor to use Title insteda of Id but it breaks Query Builder editor

      M 1 Reply Last reply Reply Quote 0
      • M Offline
        Milan Leszkow @Milan Leszkow
        last edited by

        @Milan-Leszkow
        when I change in SQL editor to search by ID with correct numerical input, report is not possible to edit with Query Builder anymore

        df4d1ef2-e7db-4bd5-96cd-c255a7acc995-image.png

        1 Reply Last reply Reply Quote 0
        • Michael HuhnM Offline
          Michael Huhn
          last edited by

          Hey @Milan-Leszkow,

          did you use any of the provided hotfixes for the report manager from here -> https://kb.i-doit.com/en/system-administration/hotfixes/index.html
          I can not reproduce this with them.

          M 2 Replies Last reply Reply Quote 0
          • M Offline
            Milan Leszkow @Michael Huhn
            last edited by

            @Michael-Huhn
            No. I will try, Thank you

            1 Reply Last reply Reply Quote 0
            • M Offline
              Milan Leszkow @Michael Huhn
              last edited by

              @Michael-Huhn
              Great! Hot fix did the job:

              40689a91-845d-47c5-bfc9-fed575095dd4-image.png

              now is ID used correctly

              Thank you

              1 Reply Last reply Reply Quote 0

              Hello! It looks like you're interested in this conversation, but you don't have an account yet.

              Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

              With your input, this post could be even better 💗

              Register Login
              • First post
                Last post