How to correctly use the ca catalog form designer

[Jose Romero]

good morning.

Dear community, I am trying to make a form using the "selec" component with an object created through a query

SELECT a.resource_name as id, b.name as family, c.name as class
FROM ca_owned_resource a, ca_resource_family b, ca_resource_class c
WHERE a.resource_family = b.id
AND a.resource_class = c.id
and (c.name like 'PLOTTER%' or c.name like 'LASER B / N%'
      or c.name like 'MFP COLOR%' or c.name like 'MFP LASER B / N%'
      or c.name like 'MFP LASER COLOR%')
order by id


The result I am looking for is that the list of printers that unlink the list of printers is displayed, which in the test if the information comes out but when I try to link it to the form it does not appear

[Lindsay Estabrooks]

What type of component are you using to call the report object (Select or Lookup Field)?

I suggest using JOINS in your SQL query:

SELECT a.resource_name as id, b.name as family, c.name as class
FROM ca_owned_resource a
JOIN ca_resource_family b ON a.resource_family = b.id
JOIN ca_resource_class c ON a.resource_class = c.id
WHERE c.name like 'PLOTTER%' or c.name like 'LASER B / N%'
   or c.name like 'MFP COLOR%' or c.name like 'MFP LASER B / N%'
   or c.name like 'MFP LASER COLOR%'
order by id

------------------------------
Lindsay Estabrooks
Principal Consultant
IT-EDU Consultants
------------------------------

[Pier Olivier Tremblay]

Report objects used with a Select component MUST return only two columns :)

The first one will be used as the value and the second one as the label.