I'm trying to filter a report based on attributes of the user. So depending on which company the user works for they should see data filtered a certain way. For example, market pricing based on the market of the company. So I'd get the user, figure out which company he/she works for an then add an attribute as a parameter to the report.
This seems like something that should be very easy to do in the IDE, but I can't find any documentation on the Creator IDE to even gives you a hint of where to start. The only comments is that if you can write Deluge code, you can use the IDE. Well, I can write deluge code, but can't figure out where to start with the IDE.
If I try to do a simple assignment statement e.g.
constant = 1; or constant = 1
both throw an error.
What is the syntax?
If I were to write regular deluge, I would expect the code to look something like this, but of course none of this works. Does the code need to be inside some wrapper? You don't even need to give me the answer. Just point me any examples or documentation for the IDE. Thanks!
list All_Price_List_Views
company_id = Users[ email == zoho.loginuserid];
company = Companies[ ID == company_ID];
{
displayName = "All Price List Views"
show all rows from Price_List_View [Market_ID.ID == company.market_id]
(
School_ID as "School ID"
Market_ID as "Market ID"
...
company = Users[ User_email ==