Notifications
Announcements
No record found.
Hi All,
I had customized a custom form which will show the list of journal name that setup in the system. However, the private group user setup is not working in my custom.
How can I implement the private group user control for the journal name drop down list?
Thanks.
Regards,Teh
Hi Teh,
Can you provide some more details? Please provide a functional description of what you need to achieve. What exactly do you mean with "not working"? Do you get any error?
Hi Andre,
Below is my custom form, the one highlighted is where I need to put in the private user group control. So when user select the journal name, the list of journal only appear those is available to the user. So want to know how to add in the control?
Thanks for the clarification. Now I understand your challenge. On the form you need to override the lookup() method for the data field for the journal names. Then you can create your own lookup with help of the SysTableLookup class.
You can also have a look at the coding in the class JournalFormTable which is called from the standard LedgerJournalTable form.
This coding is used by Microsoft to define a query to take care of the journal names with a setting for having it private for a user group.
protected Query queryForLookupJournalName() { JournalStatic journalStatic = journalTableData.journalStatic(); Query query = new Query(); QueryBuildDataSource queryBuildDataSource = query.addDataSource(journalStatic.journalName().TableId); queryBuildDataSource.addRange(journalStatic.nameFieldIdJournalType()).value(journalTypeFixed ? queryValue(journalTypeId) : SysQuery::valueUnlimited()); queryBuildDataSource.addRange(journalStatic.nameFieldIdBlockUserGroupId()).value(UserGroupList::groupsForUser()); return query; }
I had managed to filter journal name now by override the lookup method and writing my own query to filter the records based on the private group setup.
Thanks for your advice.
Regards,
Teh
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 512 Super User 2025 Season 2
Sohaib Cheema 291 User Group Leader
