Room database - remove colon from query

Asked Sep 05 '21 at 05:37

Active Sep 29 '21 at 15:55

Viewed 132 times

I am trying to sort my data by ascending and descending order using room database. So I need to pass those parameter to the DAO.

This is my code:

@Query("SELECT * FROM DEVICES_TABLE ORDER BY :sortQuery")
fun sortDatabase(sortQuery: String): Flow<List<DeviceData>>

But when I pass title DESC as sortquery (title is column name), the query becomes:

SELECT * 
FROM DEVICES_TABLE 
ORDER BY 'title ASC'

I need to remove those single quotes from query for achieving the results. I need to sort with title, price, type etc. both ascending and descending. How can I do that?

edited Sep 29 '21 at 15:55

marc_s

732,580
175
1,330
1,459

asked Sep 05 '21 at 05:37

sony

1

Did you try these approaches? https://stackoverflow.com/questions/55297165/room-dao-order-by-asc-or-desc-variable – Vlad L. Sep 05 '21 at 05:54
I've seen that but i am trying to use this same function for sorting multiple fields by changing the parameters – sony Sep 05 '21 at 06:05
You can use the same function and case inside the query. Just follow the accepted answer – Vlad L. Sep 05 '21 at 06:09
Does this answer your question? [Room DAO Order By ASC or DESC variable](https://stackoverflow.com/questions/55297165/room-dao-order-by-asc-or-desc-variable) – Some random IT boy Sep 05 '21 at 07:28
Vlad L pointed to the right place to get answers – Some random IT boy Sep 05 '21 at 07:28

Room database - remove colon from query

0 Answers0