Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


mikelm last won the day on November 9 2017

mikelm had the most liked content!

Community Reputation

3 Neutral


About mikelm

  • Rank
    Level 8 Contributor
  • Birthday 04/04/1965

Contact Methods

  • Website URL
  • ICQ

Profile Information

  • Gender
  • Location
    good old germany
  • Interests
    A lot: paradigm, AHD, ServicePlus ServiceDesk, ServiceDesk, Service Desk Manager ... to be continued

Recent Profile Visitors

1,066 profile views
  1. mikelm

    QBE Date Search

    Hi. You can use a normal date string, but it has to use the date format of the server, not the one you are using in your web.cfg. I have an english installation, and my server date format looks like: "MM/DD/YYYY HH:mm:ss" So for example: http://<SERVER>/CAisd/pdmweb.exe?OP=SEARCH+FACTORY=cr+SKIPLIST=0+QBE.EQ.customer.userid=<USERID>+QBE.GE.open_date=05/26/2014 13:59:03 works well on my installation. You have to specify your timestamp in the server timezone. Regards ..............Michael
  2. Hi Eric. I did some further research with my original approach and came to the conclusion, that this approach will not work. Even if the system will accept this kind of query, it will not produce a correct result. But I got another idea, not a new one of course, and don't ask, why it doesn't came earlier into my mind. So here is another suggestion and I'm quite sure, that it will work: customer = @root.id or requested_by = @root.id or customer.supervisor_contact_uuid in ( @root.id ) or requested_by.supervisor_contact_uuid in ( @root.id )Please give it a try and let me know the results. Regards .............Michael
  3. Hi Eric. Hmm, strange. Well, it is working in my environment (12.6 CP3). Are there any other parts in your constraint? Regards ..............mikel
  4. I know it looks strange, but give it a try: (customer.id != U'00' and requested_by.id != U'00' and customer = @root.id) or (customer.id != U'00' and requested_by.id != U'00' and requested_by = @root.id) or (customer.id != U'00' and requested_by.id != U'00' and customer.supervisor_contact_uuid = @root.id) or (customer.id != U'00' and requested_by.id != U'00' and requested_by.supervisor_contact_uuid = @root.id)
  5. mikelm

    Service Request Count request Per Tenant

    Hi. I am not aware of a simple solution here. How is the count restricted? Tickets in total, active and inactive? Current Open tickets? Number of new Tickets in a specific time frame? Where do you want to define this tenant specific number of tickets? I could imagine of some kind of prefetching the tenant specific current number of tickets, and dependent on the result, displaying a "Create" button or menu item or not. But again, this is not a simple thing, from my point of view. Regards ...........mikelm
  6. Hi. your first approach should work (nearly). When you are in the "Configuration Item List", as your screenshot let me assume, you can use soemthing like : id = U'0969194BE95B974F9535687570A8E5B1' Regards ..........mikelm
  7. mikelm

    Resolved: How to use multiple QBE values

    Try to use "QBE.EQ.status.sym=Open".
  8. mikelm

    Constraint problem

    Puuh. Glad that it works finaly
  9. mikelm

    Constraint problem

    Ok. Fine. This all looks good to me. The first where clause seems to be exactly what you are looking for: var argSearchSqlClause = 'Call_Req.active_flag = 1 AND ( Call_Req.customer = ca_contact.id AND ca_contact.organization_uuid = U\'5DADE252DA004E429899175BEFE68BBE\' ) '; This query will give all open/active ticktes, where the cutsomer of the ticket belongs to the organization with the given uuid. The reason you don't find any ticket is maybe just because that there are no such tickets! If you expect at least one ticket to find, check the following: - With an administrative user, figure out a ticket you expect to find and note the ticket number. - click on the customer of the ticket and check the organization of this contact record. Is it the same as your "customer" user has? - on the server in a command box/shell, do a bop_odump domsrvr cr "ref_num='your ticket number'" customer.organization - This command will give you the uuid of the organization of the customer of the ticket you expect to find. The uuid should be the same as in the argSearchSqlClause . I just got another idea: In the access type you created, make sure, the "Licensed?" Flag is set! Regards
  10. Hi Alan. The val_update code seems to be ok. In your set_zgrp trigger, you may do a "set_return_data(cnt_uuid);" instead of a "return cnt_uuid;". In general, this is a "deep" customization. That means, it may work, but if not, don't expect any help on this..... Regards .............mikelm
  11. You have to define, for which timezone the workshift is specified. If you want to have this workshift applicable for a different timezone, just reflect the timezone difference by changing the timestamps. Subtract the timezone difference to the timestamp, use the function, and add the difference back again.
  12. My understanding: ATTR_INIT triggers are valid for so called local attributes, attributes, which are not persistent. ATTR_INIT triggers can be used to fill a value into these local attributes, and are executed, when someoned wants to read such an attribute. In your case, all these _mapped_... attributes in the sdsc_map object are local SREL attributes. This Object is used to provide different relations between a service type, a contract, and a third Object, which is a contact, a priority, an asset, a group, or an urgency. The only thing that gets physically stored, is the persistent_id of one of these third Objects. Unfortunately, this is just a string attribute and can not be used as an SREL attribute to the correspnding object. Here are the local attributes comming in. The ATTR_INIT triggers (set_...) of these attributes are filling these local attributes, which are defined as an SREL, with the real relational attribute value (enum for priority, uuid for asset, and so on) out from the stored persistent id. So, in your own trigger, you need to return the value of the relational attribute of the object which you store in this sdsc_map relation.
  13. mikelm

    Constraint problem

    No, sorry, not clearly. Let us start from the same understanding: You want to test, if a user can only see his "organizational" tickets. You created a dummy user/contact in your system. You assigned a data partition to that user. The data partition has only one view constraint for tickets with the following condition: customer.organization = @root.organization. Here are my questions: Which Accesstype did you set in the dummy users contact record?Which Role do you have, when you log in with this User?When you login with this user, do you get the "analyst" interface (the same interface as any of your agents/analysts will get), or do you get the "End User interface" (a reduced interface only for endusers, which you normaly get, when you have a "Customer" or "Employee" role ) ?Forget the Scorebouoard queries: When you search for Incidents with the only restriction of "Active" tickets, you don't get a result, even if you would expect a result, correct?After this search, please take a look at the whereclauses in the source of the result page and post them here. In the queries you have send, I can see the following: you have an additional restriction in the whereclasue, saying, that the assignee of the ticket has to belong to a specific organization also. This doesn't make sense if my understanding of your business need is correct. So where does this restriction come from? I don't think it comes from the data partition. Maybe from your stored query. But that's something you have to check. This is the reason I want you to answere the above questions. Maybe this gives us a hint, what's going on.
  14. mikelm

    Constraint problem

    Ok, when you don't get the result you expected, check the whereclause allways. Post it, if you don't understand it. When you clear the filter and press search, you should allways get all active incidents the logged in user has view access to. If you don't get a result, but you expect a result, check the where clause!
  15. mikelm

    Constraint problem

    Ok, the where clause is saying : Give me all active tickets of type "Request" (not Incidents!), where the customer and the assignee belong to the organization with UUID 5DADE252DA004E429899175BEFE68BBE. Why are you also restricting the assignee? And why are you searching for Requests. I thought, you were looking for Incidents? (type == 'I') Is this what you want? Are you looking for Request? Or do you want to get Incidents? How exactly do you search? What kind of result do you get, if you go to the Search menu, select Incidents, press "Clear Filter" and press "Search".