I have been trying to accomplish this for a long time as well, but no luck yet. Could someone assist me?
I want to display a list that queries all assets that are associated with the current user's (zoho.loginuserid) company. In our scenario licenses should be available to our customers companywide instead of associated to a specific user.
list My_Licenses
{
displayname = "My Licenses"
show all rows from Add_Asset [(Company == helpdesk.getRequesterCompanyName())]
(
Asset_Name as "Asset No"
Product_Name as "Product Name"
SKU
Location
MAC_Address as "MAC Address"
Users
License_Valid_Until as "Expiration Date"
custom action "Download License"
(
function = helpdesk.getLicense(MAC_Address, License_Valid_Until, Users, Location)
column header = "Download License"
success message = ""
)
)
This does not work, it returns the value NULL from the function.
If I change the following line the report / list is updated with records that are associated with the specific user.
show all rows from Add_Asset [Assign_User.Email_ID == zoho.loginuserid]
I need to make this list more accurate by list all of the customer's licenses that are associated with the Company, not just the current user.
Please help!
Thanks,
-Jaap