I am writing an sql query with Ice.Menu and Ice.Security.
however I am not sure how to link the Company field from the Menu to the Security table.
The Menu.Company field may be blank because it is checked as all companies,
but the Security.Company is listed twice , once for each Company.
This is just one scenario.
Another would be the menu is listed twice, once for each company
but the security table has one record and the Company is blank, because it is used in both companies.
Anyone know how to join these two tables with the company?
I am going to face the same issue when I bring the User to the SecGroup and back to the Security table.
I have it written pretty good, it just doesn’t take the Company into consideration.
Some Menus are Company specific
Not sure this will apply in your cases but…
Can you break out the company values?
e.g tilde delimited from - UserFile.CompList.
Company 1
((case when [Ice].num_entries(UserFile.CompList, ‘~’ ) > 0 then [Ice].entry(1, UserFile.CompList, ‘~’) else ‘’ end)) as [Calculated_cComp01],
Company 2
((case when [Ice].num_entries(UserFile.CompList, ‘~’ ) > 0 then [Ice].entry(2, UserFile.CompList, ‘~’) else ‘’ end)) as [Calculated_cComp2],
Thank you for your response! I do split the CompList for some User and SecGroup Reports.
but for this example, I just pull data with all companies and then write an sql expression to remove the extra rows that do not belong.
