logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Federico  
#1 Posted : Friday, March 18, 2016 4:47:42 PM(UTC)
Federico

Rank: Newbie

Groups: Registered
Joined: 3/18/2016(UTC)
Posts: 7
Italy

Hi,
I'm using this platform for reports, and I would need to use a single restriction affecting two database fields. It's possible? If so, how should I do?
For example, if a first field contains "1" and a second field contains "yes" then I show that record otherwise no.


Thanks
epf  
#2 Posted : Monday, March 21, 2016 7:20:37 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 676
Switzerland

Thanks: 12 times
Was thanked: 116 time(s) in 113 post(s)
You can use a restriction and change the "Operator" property to [Value Only], this will inject only the Value selected by the user in the SQL.
Then you can rewrite the SQL in the restriction text like: (Quantity Or Discount) = [An Input Value 123] to affect 2 columns in your query...

Another way to do it is to change the "Custom SQL" property (e.g. going from 'Quantity to (Quantity OR Discount)).

In both cases, check the SQL generated and adjust it.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.