Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a file, where there is comment field "CleanedText_Comment"
I'd like to select any comment from "CleanedText_Comment" and get Id and Url in a table chart.
My manually steps work so:
1. I select any comment from list box "CleanedText_Comment"
2. Select possible SessionId
3. Deselect "CleanedText_Comment"
My table show me all values.
Please find the attached file.
Thanks,
I got it
vSID=IF(GetSelectedCount(CleanedText_Comment)=1, SessionId,null())
trigger CleanedText_Comment onSelect and onChange
select in Field SessionId
=vSID
in the table expression
only({<CleanedText_Comment= ,SessionId={'$(vSID)'}>}Url)
how to select certain Id?
I tried
only({<CleanedText_Comment=>} Id)
It didn't work
Hi,
I am little bit confuse in 3rd step.
could you please specify.
Just remove selection from comment field
If I understood you well, what you have to do is to keep Ctrl button pressed while doing the 3rd step.
Try that.
Regards,
Sorin
No, I don't need any manually step.
I select the comment and see many Id and all url
In text object it works. I click on any comment and get all Id and url in text objects
=Concat( {< CleanedText_Comment= ,SessionId=P()>}Url, ',')
and
=concat({<CleanedText_Comment=, SessionId=P()>} Id,',')
I think I need to use a trigger onChange and onSelect
but I don't know how select my Id
Vladimir, so what you want is the table to show all the comments associated to the ID of the selected comment?
Select any comment and get all Id and url associated to this SessionId.
Maybe aggr function ?