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!!! :P

[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 :P

[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