and more in a single search tool across platforms. Read the announcement here. |
01/23/2023 09:49 AM
Hello,
Does anyone have a sample query for populating the value entered in an attribute to another attribute in a user request form? For example, in attribute A the number 50 was selected and I want to populate attribute B with the value of attribute A
Thanks
Solved! Go to Solution.
01/23/2023 01:28 PM
Attribute2 Config
Select ${Attribute1} as id
add parent attribute for Attribute2 as Attribute1
01/23/2023 01:39 PM
Thanks, I actually figured something out for my usecase. However, I do have another question also in relation to User request form.
I have a query that I'm trying to use for concatenating values inputed in the form but I'm getting error messages. Any feedback would be appreciated. It's something like this
select distinct ID FROM ( select concat(${if(binding.variables.containsKey('ValueA'))
{ValueA} else {''}},${if(binding.variables.containsKey('ValueB')) {ValueB}
else {''}},${if(binding.variables.containsKey('ValueC')) {ValueC} else {''}},${if(binding.variables.containsKey('ValueD'))
{ValueD} else {''}}) as ID
01/23/2023 01:40 PM
try groovy/java concat
01/23/2023 01:49 PM
I thought it only allows sql queries?
01/23/2023 04:51 PM
Inside if you can use java/groovy functions
01/24/2023 05:10 AM
Do you have a sample of that?
01/24/2023 01:00 PM
select ${if(binding.variables.containsKey('ValueA'))
{ValueA.replace('A','AAA')} else {''}} as ID
02/01/2023 12:18 PM
I tried that but it didn't work for me. However, here's what worked for me in case anyone else has the same usecase
select concat(${ValueA},${ValueB},${ValueC}) as ID