Hi there!Originally my goal is to filter available options in select list to depend on selected option in another column.Lets say I select Option1 in ColumnA and in ColumnB I get available OptionSet1. If I select Option2 in ColumnA, in ColumnB I get OptionSet2, etc.Yes, it is like Select List (Cascading), but in Table Grid Editor. So I tried to create a Behaviour on Groovy, but can't make it work for me. I have this script:import com.atlassian.crowd.embedded.api.Userimport com.atlassian.jira.component.ComponentAccessorimport com.atlassian.jira.issue.CustomFieldManagerimport com.atlassian.jira.issue.Issueimport com.atlassian.jira.issue.IssueManagerimport com.atlassian.jira.issue.fields.CustomFieldimport com.atlassian.jira.security.JiraAuthenticationContextimport com.atlassian.plugin.PluginAccessorimport com.atlassian.jira.user.ApplicationUserimport org.apache.log4j.Levelimport org.apache.log4j.Loggerlog.setLevel Level.DEBUGString logPref = "Test1234 "if (log.isDebugEnabled()) log.debug logPref + "START"// get an issueIssueManager issueManager = ComponentAccessor.getOSGiComponentInstanceOfType(IssueManager.class);Issue issue = issueManager.getIssueObject("BOM-1");// find TGE custom fieldsPluginAccessor pluginAccessor = ComponentAccessor.getPluginAccessor();Class tgeConfigManagerClass = pluginAccessor.getClassLoader().findClass("com.idalko.jira.plugins.igrid.api.config.grid.TGEGridConfigManager");def tgeConfigManager = ComponentAccessor.getOSGiComponentInstanceOfType(tgeConfigManagerClass);List<Long> tgeCustomFieldIds = tgeConfigManager.getGridCustomFieldIds();// get current userJiraAuthenticationContext jiraAuthenticationContext = ComponentAccessor.getOSGiComponentInstanceOfType(JiraAuthenticationContext.class);Object userObject = jiraAuthenticationContext.getLoggedInUser();User user = userObject instanceof ApplicationUser ? ((ApplicationUser) userObject).getDirectoryUser() : (User) userObject// read the grid dataClass dataManagerClass = pluginAccessor.getClassLoader().findClass("com.idalko.jira.plugins.igrid.api.data.TGEGridTableDataManager");def tgeGridDataManager = ComponentAccessor.getOSGiComponentInstanceOfType(dataManagerClass);if (log.isDebugEnabled()) log.debug logPref + "Processing..."CustomFieldManager customFieldManager = ComponentAccessor.getOSGiComponentInstanceOfType(CustomFieldManager.class)CustomField tgeCustomField = customFieldManager.getCustomFieldObject(17508)def callResult1 = tgeGridDataManager.readGridData(issue.getId(), tgeCustomField.id, null, null, 0, 10, user);if (log.isDebugEnabled()) log.debug logPref + "Result " + callResult1.getValues()StringBuilder result = new StringBuilder();for (Long tgeCustomFieldId : tgeCustomFieldIds) { if (log.isDebugEnabled()) log.debug logPref + "tgeCustomFieldId " + tgeCustomFieldId try { def callResult = tgeGridDataManager.readGridData(issue.getId(), tgeCustomFieldId, null, null, 0, 10, user); result.append("Grid ID=" + tgeCustomFieldId + " content: " + callResult.getValues() + "\n"); if (log.isDebugEnabled()) log.debug logPref + "Result " + callResult.getValues() } catch (Exception e) { result.append("Grid ID=" + tgeCustomFieldId + " data cannot be retrieved: " + e.getMessage() + "\n"); }}println(result.toString());return result.toString();if (log.isDebugEnabled()) log.debug logPref + "END"It is the only script I could find for table grid editor, there are different versions of it, but in general all they are modified versions of this one. So I tried to use it in behaviour and in post function. In both cases I get following error:groovy.lang.MissingMethodException: No signature of method: com.idalko.jira.plugins.igrid.impl.data.TGEGridTableDataManagerImpl.readGridData() is applicable for argument types: (java.lang.Long, java.lang.String, null, null, java.lang.Integer, java.lang.Integer, com.atlassian.jira.user.BridgedDirectoryUser) values: [312055, customfield_17508, null, null, 0, 10, x208214:10001]Possible solutions: readGridData(java.lang.Long, java.lang.Long, java.lang.Long, java.util.Set, java.lang.Integer, java.lang.Integer, com.atlassian.crowd.embedded.api.User) at BOM_test.run(BOM_test.groovy:39)As far as I know com.atlassian.crowd.embedded.api.User is deprecated from JIRA and I can't even test properly. Any ideas why It doesn't work? If you have an example of how to filter values in columns, I will appreciate it as well. Thank you in advance.

Community
Q&A
Jira
Questions
Filter available options for idalko table grid

Which one to select project type (Team managed or Company managed)

Hi,

I am creating all together a new project and I need someone assistance in helping me out in setting up things for smooth flow. I have confusion in selecting whether to select team managed project type or company managed project type. Kindly help.

Thanks,

Adarsh BM

1 answer

1 accepted

1 vote

Answer accepted

Hi Viktor,

Maybe I'm misunderstanding your requirement - but cascading from one column to another column can be done without scripting.

Check the example
https://wiki.idalko.com/display/TGPD/How+to+cascade+to+2+%28or+more%29+columns

Is this what you're looking for?

Francis

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Francis,

It does seem like what I was looking for. I'm trying to check it,

Thank you for quick turnaround!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

If it isn't, please send a mail to support.tge@idalko.com which will create an issue on our service desk.

I bumped by accident on this question, and further replies might get unnoticed

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Which one to select project type (Team managed or Company managed)

1 answer

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events