Jump to content

Reporting on h_sys_accounts


QEHNick

Recommended Posts

I'm creating a report to collate some information on our customers using the request table and the h_sys_accounts table. 

Within the h_sys_accounts table are the custom attributes. When viewed in the "database Direct" tool, I can see the "Attribute X"  values (one thru eight) are present.

When using the report, none of those values appear. Is this a limitation or is there something I am missing?

Link to comment
Share on other sites

and that sql clause you have specified in the table join section yes? Can you put up screen of your select tables and join so i can make sure mine is the same

Link to comment
Share on other sites

@QEHNick ,

Works ok as far as i can tell.

You sure the sys accounts login id matches the requests customer id?

Set the JOIN type to "right join" - this will then only return records if a match exists in sys accounts table.

Also maybe add those 2 cols (maybe accounts userid as well) to output so can see.

Lastly for now maybe filter report to select just 1 request by request ID where you know the request customer id = a sys account login id that has attribute fields set.

image.png



 

Link to comment
Share on other sites

That suggestion helped me figure it out - the customer ID and Login ID is the same - however, the accounts which are like that do not have any custom attributes. I have instead selected "h_fk_user_name" from the request table and "name" from the h_sys_account table. These match perfectly and the results are now correct.

 

Thanks for the mental nudge @NeilWJ

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...