질문하기

Libre Nut's profile - activity

2015-09-12 01:34:52 +0200 받은 배지  유명한 질문 (source)
2015-04-28 10:37:19 +0200 받은 배지  정리의 달인
2014-04-30 16:21:50 +0200 받은 배지  유명한 질문 (source)
2014-04-26 18:36:14 +0200 받은 배지  인기있는 질문 (source)
2014-04-26 18:36:14 +0200 받은 배지  주목할 만한 질문 (source)
2014-03-11 11:42:10 +0200 받은 배지  주목할 만한 질문 (source)
2014-03-02 04:01:13 +0200 받은 배지  개근상
2014-02-26 15:26:44 +0200 받은 배지  인기있는 질문 (source)
2014-02-26 13:43:06 +0200 질문에 답변하였습니다 How to use username in a query / sql statement?

The answer was pretty simple. Current_User returns the value of the logged in user. How naive of me! Thanks to mariosv and others who helped me find the solution.

2014-02-26 08:44:58 +0200 코멘트달린 답변 How to use username in a query / sql statement?

I'm sorry if I was not clear in my question. I want the query to pickup the name of the current user automatically. Can you guide me how to do it?

2014-02-25 06:12:21 +0200 질문하였습니다 How to use username in a query / sql statement?

I have a LO base connected to a postgresql database with mutliple users. I want to load different forms based on the current user name. How do I fetch the current user name using query or a sql statement?

2014-02-24 14:16:57 +0200 질문에 답변하였습니다 Subtotal function acts weird

I was facing a similar problem, and I found the solution here. Novices like me have difficulty understanding and following these steps, so I'm writing the steps again. Scenario: You have a list of rows with subtotals. You want only the subtotal rows (results) to be displayed so that you can work on the subtotals - maybe arrange the subtotals in ascending order or whatever. Follow these steps:

  1. Display all the data with the subtotals
  2. Select all the cells and using Date - Define Range give it a name. Named ranges store subtotals, filters etc
  3. Using Date - Filter - Standard Filter set criteria - Field name - Name of the column by which subtotals are grouped; Condition - "contains"; Value - "Sum"
  4. Click on + sign Options and check "Copy results to" and select a cell in a different sheet
  5. Now only your subtotal rows are available for further work

Use of Data Pilot (Pivot Table) is supposed to be an alternative but I have not worked on that.

2014-02-23 16:16:19 +0200 받은 배지  족집게 도사 (source)
2014-02-23 16:16:19 +0200 받은 배지  선생님 (source)
2014-02-23 08:11:54 +0200 질문에 답변하였습니다 Can an autovalue primary key be created with PostgreSQL?

I want to expand on the comment by cootcraig so that newbies like me will find it useful.

The auto-value primary key works well. If you are comfortable working with libreoffice and not with the database directly (like me) you can follow these steps:

  1. Create the new table in LO without the primary key column
  2. Create the primary key column in the database directly ( I use pgAdmin to manage the postgres database - I find it very user friendly)
  3. Make sure the data type is 'serial'.

That's it. When you reconnect your LO to the database the primary key column is available and when you design a form the auto value works too. Thanks to all the people who have helped me find this solution.

2014-02-23 08:02:39 +0200 질문에 답변하였습니다 postgresql auto-increment field problem

After I asked this question, I found another similar question - see here

2014-02-22 10:09:13 +0200 질문하였습니다 postgresql auto-increment field problem

I'm using LlibreOffice Base (English) 4.2 to connect to Postgresql 9.3. My OS is Windows 7 64-bit. I could connect successfully and create tables. My problem is with auto-value fields (for primary key) which are not getting filled up in the data entry form. I tried looking through forums but I'm unable to find the solution. Can someone please help with this?