ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Selecting the records from the relationship entries based on Field Value

June 16, 2011 11:28am

Subscribe [4]
  • #1 / Jun 16, 2011 11:28am

    Ruslan Ka

    63 posts

    I have a custom channel for members

    Member Channel has MultiSelect relationship to the brandID of Brand Channel

    Now , what I’m trying to do is to pass the member name through the url as {segment_3} and fetch all related brand_ids for this particular member.

    {exp:channel:entries channel="customMemberChannel" disable="pagination" limit="1" search:custom_member_name="{segment_3}"} 
        {multi_brand_select}
    {/exp:channel:entries}

    AS a result I’m always getting just my latest members brand IDs is there any other way to fetch data except of doing it through search:field_name ?


    And after that I want to select from the Items Channel the items based on Brand IDs and output as XML.

  • #2 / Jun 17, 2011 12:53am

    John Henry Donovan

    12339 posts

    Ruslan,

    What is used for the title of customMemberChannel?
    What type of field is custom_member_name?

    What is the Multi Select Relationship field? Is it this one?

    While we don’t support third-party custom fields we can try and put you on the right track

  • #3 / Jun 17, 2011 6:09am

    Ruslan Ka

    63 posts

    customMemberChannel is just the Channel Name
    custom_member_name is just the TextInput Field within the field Group the channel.
    multi select relationship is just a standard Multi Select Field Type in EE, not a third party. and it is linked to Brand ID of the brands channel.

  • #4 / Jun 18, 2011 12:50pm

    Greg Salt

    3988 posts

    Hi Ruslan,

    I’m afraid that I’m not really following this - I can’t visualise what it is that you’ve set up as custom fields. Can you please perhaps post some screenshots of your custom field setups. For example, if your segment_3 == ‘ruslan’ does one of your entries in the customMemberChannel have a the field custom_member_name that contains exactly ‘ruslan’? Are you using the screen name or username of the member in the custom field?

    Cheers

    Greg

  • #5 / Jun 24, 2011 6:00pm

    Ruslan Ka

    63 posts

    I know that my explanation was confusing,sorry for that. I got it actually sorted by doing the search with “=”(exact) sign.

  • #6 / Jun 27, 2011 9:14pm

    Lisa Wess

    20502 posts

    Hi, Ruslan -

    Glad you were able to figure it out!  If you have anything else come up, please do let us know.  Thank you.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases