How do I to use INNER JOIN in Browse Dialog component?


Author
Message
Marcio Valerio Silva
Marcio Valerio Silva
StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)StrataFrame Novice (115 reputation)
Group: Forum Members
Posts: 55, Visits: 929
How do I to use INNER JOIN in Browse Dialog Component?

Example I have a table named Order and it has a field ClientId, but I need to seek by field ClientesName that not is in table Order.

So I need to use SQL INNER JOIN or LEFT JOIN to fill the Browse Dialog Component.

How do I do this?

at,

Marcio Valerio da Silva

at,

Marcio Valerio da Silva
Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Marcio,

The easy way is to create a view in SQL, then create a BO using that view and assign that BO to the Browser Dialog. 

There are couple of messages in the forums about the same issue.  Search for Browse Dialog in the forums.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search