User select field

jcvieira

Hi guys,

Tried reverse engineer some code from modules that already come with the app but i was not successful, how can i have a RB select field that fetches the users that have logins from the application?

Thank you

jasiek

You should use "Employee" type or "CompanyOrContact" http://www.epesi.org/Utils/RecordBrowser/RBO

jcvieira

[quote="Jasiek":k4fiinh9]You should use "Employee" type or "CompanyOrContact" http://www.epesi.org/Utils/RecordBrowser/RBO[/quote:k4fiinh9]
Could you kindly give me an example?

jasiek

It depends on what is that you are trying to do.
Can you post your code here?

jcvieira

Basicaly create a RB with a select field that fetches the user something like:

class TPN_SalesManagement_ConfEmail extends RBO_Recordset {

 

    function table_name() { // - choose a name for the table that will be stored in EPESI database

 

        return 'TPN_SM_CEmail';

 

    }

 

    function fields() { // - here you choose the fields to add to the record browser

		

		$fields = array();

		

		$field = new RBO_Field_Select(_M('Login'));

		$field->from('user')->fields('login')->set_required()->set_visible();

		$fields[] = $field;

		

		return $fields;

 

    }

}

Thanks

ajb

You can't use select field for user table as it's not a recordset.

You've got two options.
1. Create text/int field, and use QFfield callback to create select field with proper logins. You can get login as a value stored in database. Or user id - I think it's a better idea. (text/int depends on this choice)
2. Use CRM_Contacts_RBO_Contact field type with crits callback. You'll see only specific contacts. You'll get contact id as a value.

I suggest second one as you'll get more options and it's simpler.
Pick one and try to do this. I can help you then.

jcvieira

[quote="ajb":1uu8jzv3]You can't use select field for user table as it's not a recordset.

I suggest second one as you'll get more options and it's simpler.
Pick one and try to do this. I can help you then.[/quote:1uu8jzv3]

Thanks ajb. Ive opted by the top one and i managed to get it working.

Cheers 😃

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge