Mattersphere Developers Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Go down
avatar
Lynne Harding
Posts : 335
Join date : 2018-12-20

Change filter on a searchlist button Empty Change filter on a searchlist button

Mon 30 Mar 2020 - 7:54
We have a button on the search list that shows all Live matters. The action is ViewActive and this is the paramater that it uses
< config > < trashCan fieldname=“FileStatus” changeValue=“LIVE*” /> </ config >
Is it possible to have more than one paramater, so when the button is clicked it will show matters with a status of LIVE and PARTOPENED. If yes what is the syntax for this?
avatar
Lynne Harding
Posts : 335
Join date : 2018-12-20

Change filter on a searchlist button Empty Re: Change filter on a searchlist button

Mon 30 Mar 2020 - 7:54
The active filter only applies to a single field if you add a % symbol to the changevalue then a 'like' will be performed instead of an equals but that won't help in your case.
You could overcome the limitation in your query that returns the data by computing a column value.

select
*, CASE WHEN fileStatus like 'LIVE%' THEN 1 WHEN fileStatus = 'PARTOPENED' THEN 1 ELSE 0 END AS IsLive from dbfile And set fieldName = IsLive and changeValue = 1
avatar
Lynne Harding
Posts : 335
Join date : 2018-12-20

Change filter on a searchlist button Empty Re: Change filter on a searchlist button

Mon 30 Mar 2020 - 7:55
How about changing the code for PARTOPENED to LIVEPARTOPENED?I think all of our queries look for a prefix of LIVE when displaying live matters.
Sponsored content

Change filter on a searchlist button Empty Re: Change filter on a searchlist button

Back to top
Permissions in this forum:
You cannot reply to topics in this forum