Creating a report in OpenOffice for PyKota

[Ric_]

I'd like to make a pretty report in OpenOffice to shame staff that print ridiculous amounts and other reports to show other things.

 

I think that I can figure out the report business and I have created a DSN to connect to the PyKota database. My problem is that I only want to look at staff so I need to create a clever query.

 

I need to select only the rows where the username does not begin with a digit. How do I do this (either in Design view or SQL view)???

[Ric_]

^^ NUDGE!!!

[ChrisH]

Hmm something like

 

Select * from usernames where username not like '%0'

 

Assuming all the user names you dont want begin with a 0.

[Ric_]

Hmm something like

 

Select * from usernames where username not like '%0'

 

Assuming all the user names you dont want begin with a 0.

 

Some start with a 6

[Ric_]

SELECT "username", "balance" FROM "public"."users" WHERE ( ( "username" NOT LIKE '0%' AND "username" NOT LIKE '6%' ) ) ORDER BY "username" ASC

 

That was what I wanted

[ChrisH]

I was close enough tbh

[Ric_]

I was close enough tbh

 

Except the % was in the wrong place

[ChrisH]

I was close enough tbh

 

Except the % was in the wrong place

 

Pfft details tbpfhomgkthanksbye