Author Topic: Feature similar to ROW_NUMBER() from SQL?  (Read 1963 times)

vivianteoh

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 6
    • View Profile
Feature similar to ROW_NUMBER() from SQL?
« on: October 22, 2019, 01:43:30 pm »
Hi. May I know whether PQGrid able to generate sequential number within each group?

Example
Department: A
1  xxxx
2  xxx
Department: B
1  xxxxxx
2  xxxxx
3  xxxxx

If yes, may I know whether the row number can be exported to Excel?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6263
    • View Profile
Re: Feature similar to ROW_NUMBER() from SQL?
« Reply #1 on: October 23, 2019, 01:25:24 pm »
Sorry, I don't see any way to generate sequential numbers as per your requirement. I would let you know if I find one.

vivianteoh

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 6
    • View Profile
Re: Feature similar to ROW_NUMBER() from SQL?
« Reply #2 on: October 24, 2019, 08:22:29 am »
Sure! Thanks  ;)