Is there a way to filter on the raw datawindow rowid? I don't want the row number because it changes when you sort etc. I know you can get the rowid by using GetRowFromRowId, but i would like to have a simple filter like this: rowid in (1,5,7,9,25). I don't want to add my own dummy rowid column, I want to use the rowid that already exists on the native datawindow, but how do you access it?
- You are here:
-
Home
-
Q&A
-
Q&A
-
PowerBuilder
- Rowid filter
-
Kim Berghall
- PowerBuilder
- Friday, 25 May 2018 16:36 PM UTC
Comment
- Chris Pollach @Appeon
- Friday, 25 May 2018 20:19 PM UTC
Unfortunately Kim, the GetRowIDFromRow function is not available in the DWO as one that you can use within an expression. Thus, you would need to:
Create a Global Function that uses the GetRowIDFromRow method and expects the Row # as an argument
Create a dummy RowID computed column in your DWO`s SQL
Call the external Global Function using the DWO`s expression GetRow() method to return the RowID from the global function to populate the dummy SQL column in the DWO`s primary buffer. Or do the same in the RetrieveRow event and then do a SetItemXxxx () from there.
Now you can filter on the RowID using the dummy column.
Create a Global Function that uses the GetRowIDFromRow method and expects the Row # as an argument
Create a dummy RowID computed column in your DWO`s SQL
Call the external Global Function using the DWO`s expression GetRow() method to return the RowID from the global function to populate the dummy SQL column in the DWO`s primary buffer. Or do the same in the RetrieveRow event and then do a SetItemXxxx () from there.
Now you can filter on the RowID using the dummy column.
There are no comments made yet.
- Page :
- 1
There are no replies made for this question yet.
However, you are not allowed to reply to this question.
However, you are not allowed to reply to this question.