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 508 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
              • First post
                Last post