Clarity Service Management

Expand all | Collapse all

Creating a lrel relationship for a custom table. Cherrie Picker view

Jump to Best Answer
  • 1.  Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 09-21-2017 06:11 AM

    Hi Communities

     

    Sorry to Bother Guys and Ladies

     

    I have build a custom table called zbuservice and a custom column on CR table called zbusvc which is Business Services.

     

    This was a look up first, then the requirement changed to, they want select multiple business service at the same time. We did it like groupmem and cnt relationship by building a magic file to zlrel_cr_busvc.maj to build the brel's for us in the schema after we build the bottom screens.

     

    We also build a update_lrel_zbuservice. All works the majic script builds the brel columns on the CR and zbuservice tables, But I get this error when trying to search for Business services. Struggling to bring back the Cherrie picker.

     

    error message "attr_by_key() failed for attr_name=zbuservice; producer=zlrel_cr_busvc" service desk dies immediately and tries to recover all this is in DEV.when I clisck on the search button.

     

     

    I understand this is custom fields and tables and lrel's. I would just like see if someone has done this before and did it work and where may I be going wrong.

     

     

    Regards

     

    Edgar Louw



  • 2.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view
    Best Answer

    Posted 09-21-2017 11:31 AM

    Hi,

    have you seen this doc: How to create custom BREL/QREL/LREL attribute? I really need to update it with latest best practics inputs but common information are still valid

    Regards,

    cdtj



  • 3.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 09-28-2017 02:56 PM

    Hi Edgar,

    Did the document from cdtj help you on this?   Unfortunately from a support perspective this is not something that we can assist with as its outside the scope of support.  However there may be folks out here in the community that have gotten something like this to work and may be willing to share your info with you.

    Thanks,

    Jon I.



  • 4.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 09-28-2017 03:24 PM

    Hi Edgar,

     

    I wrote a doc detailing how to do this for multiple CIs on an Incident record.  I think it probably has most of what you need, you can review the modification and alter it for your use case.

    Multiple CIs on Request / Incident / Problem (CR to NR lrel/brel) 



  • 5.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-02-2017 02:51 AM

    HI Guy

     

    Tried every doc you supplied. I even rebuild the screens with you recommendation. No luck gives the same error as in the first post. Even build a second one, to see if it is only happening with custom tables only.

     

    thanks

    Edgar Louw



  • 6.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-02-2017 08:02 AM

    Hi Edgar, 

     

    Are you able to email me a zip containing the files for this customization? If so I'll review on my end to see what's up.



  • 7.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-02-2017 08:07 AM

    Hi Grant

     

    I will, do not mind Just need to do it. I'm just a bit busy now , I can send you everything tomorrow. I will include the everything, how we build it and the script.

     

    regard's

     

    Edgar Louw.



  • 8.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-02-2017 08:11 AM

    That's great! You should be able to find my email in my profile, if not then follow me and I'll PM you. 



  • 9.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-10-2017 03:22 AM

    Hi Grant

     

    I'm thankful for input, but

     

    This is Custom table we build and  we trying to change it to multiple selections. We think we not adding something because all work until you call the Cherrie Picker.

     

    Then Application crashes and I build everything as should, I mailed you with what I build unless you didn't get it.

     

    Regards

     

    Edgar Louw



  • 10.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-10-2017 01:24 PM

    Hi Edgar, 

     

    I haven't received an email. Can you try sending it again? I think the problem may be that the new customization is overlapping with your previous customization, but I won't know for sure until I can look at the files. 



  • 11.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-27-2017 01:51 AM

    HI Everyone

     

    Just wanted to post, thank you for helping on this. Grant helped. It was a very easy Solution. If you build a custom Table the Field that reference the custom table in the lrel must have the same name as the Custom Table Name.

     

    Everything else was correct.

     

    Big thank you to Grant for helping, Without him I would have struggled.

     

    Thanks

     

    Edgar Louw



  • 12.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-27-2017 12:25 PM

    How about posting your solution here so that others may benefit in the future?



  • 13.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-27-2017 02:40 PM

    Hi Lindsay,

     

    I posted the solution to the following document. It’s the zip file with Business Service customization in the title. It allows you to attach Business Service class CIs in a tab on an incident.

    Multiple CIs on Request / Incident / Problem (CR to NR lrel/brel) 



  • 14.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-28-2017 02:19 AM

    Hi Lindsay

     

    Just follow Grant's Document we went that way.

    Multiple CIs on Request / Incident / Problem (CR to NR lrel/brel), We deleted the custom tables and Grant's way is the best. We gonna change Business units to go through the Ci's as well, by creating a class for Business Units.

     

    Sorry Linday. Everthing is in Grants Doc. he helped with this mostly. Again thanks Brother. I was struggling.

     

    Regards

     

    Edgar Louw



  • 15.  Re: Creating a lrel relationship for a custom table. Cherrie Picker view

    Posted 11-27-2017 03:11 PM

    You’re welcome Edgar!