Relationship filter

May 12, 2016 at 1:00 PM
I use Visual Query Designer for seting up pipeline and don't know how to use
DeafultPipline data for Filter value.

Here is a more detailed description of problem (diagram):

Image
Coordinator
May 12, 2016 at 2:54 PM
2sxc can do much more - because it can get config values from many places, not just from Content.

You're looking for this :)
http://2sxc.org/en/Docs-Manuals/Feature/feature/4544
May 12, 2016 at 2:58 PM
Yes!!!
Thanks
May 13, 2016 at 7:12 AM
I trying this but it seems that In: parameter don't work.

Relationship data:

Relationship : Category1
Filter : [QueryString:Category1||[In:FilterData:Category1||DŠI]]

{
"ListContent": [],
"Default": [
{
  "Title": "Prvi seznam",
  "Intro": "",
  "Category1": [
    {
      "Id": 904,
      "Title": "Ostalo"
    }
  ],
  "Category2": [
    {
      "Id": 906,
      "Title": "Odbojka"
    }
  ],
  "Year": 2016,
  "Foot": "",
  "Cat1": "Ostalo",
  "Id": 938
}
],
"Paging": [
{
  "Title": "Paging Information",
  "PageSize": 3,
  "PageNumber": 1,
  "ItemCount": 2,
  "PageCount": 1,
  "Id": 0
}
],
"Documents": [
{
  "Title": "Peta",
  "Category1": [
    {
      "Id": 901,
      "Title": "DŠI"
    }
  ],
  "Category2": [],
  "Date": "2016-05-19T00:00:00Z",
  "Body": "",
  "Gallery": "",
  "Image": "",
  "Intro": "",
  "Results": "",
  "Files": "",
  "Id": 948
},
{
  "Title": "Tretja",
  "Category1": [
    {
      "Id": 901,
      "Title": "DŠI"
    }
  ],
  "Category2": [
    {
      "Id": 908,
      "Title": "Streljanje"
    }
  ],
  "Date": "2016-05-05T00:00:00Z",
  "Body": "",
  "Gallery": "",
  "Image": "",
  "Intro": "",
  "Results": "",
  "Files": "",
  "Id": 929
}
]

}

Default.Category1.Title = "Ostalo"

But in Documents I get :

Documents.Category1.Title = "DŠI" (the same as default, not from : In:FilterData)

I also try to use Cat1 (becouse is string and not entiti like Category1 and also don't work)


Can somebody check if this is a Bug?

Image
May 13, 2016 at 7:48 AM
Edited May 13, 2016 at 7:48 AM
I also try with ValuSort filter and also don't work OK.

I also try this sample;
http://2sxc.org/en/apps/app/tutorial-query-discover-the-visual-query-designer-for-2sxc-dnn-dotnetnuke

It work if I only intall app and test the app.

But if I try to look and run In Visual Query Designer I also get error:

Image
Coordinator
May 13, 2016 at 11:49 AM
You probably have the wrong module-id in the test parameters, namely the ones from the original system. to use it in the visual designer, you must give it a module-id as a test-parameter which actually exists on your system.
May 13, 2016 at 11:56 AM
For your sample I have realy wrong module-id,
but in my module the test module id is OK

But data is still wrong.
Always falback to default or query string.
The "In" value is never used.

Any idea what I doing wrong?
Coordinator
May 13, 2016 at 12:00 PM
pls give a screenshot of the relationship filter settings...

it could also be that we never tested this with entities. could you mail me your app to info ... 2sxc.org?
May 13, 2016 at 12:08 PM
Curently the app is a mess becouse i was trying diferent ways but did not work with entity or string data.
I will start with new instalation and cleanup everithing and send you to info email.

Thanks
May 13, 2016 at 3:49 PM
I send you new app to email.

Also I figured out that if "In-Atribute" is entity filter don't work,
but if is string then work OK.

Test cases:

1.
Filter = [QueryString:Category1||[In:Config:Title||test]]
OK

2.
filter = [QueryString:Category1||[In:Config:Category1||test]]
Not Ok

3.
filter = [QueryString:Category1||[In:Config:Category1:Title||test]]
Not Ok

4.
filter = [QueryString:Category1||[In:Config:Category1[0]:Title||test]]
Not Ok


Config:Title (string)
Config:Category1 (entity)
May 13, 2016 at 5:41 PM
Also if string field ends with number. Filter don't work

In fields definition:
Title (string)
Kat1 (string)
Param (string)

eg:
Filter = [QueryString:Category1||[In:Config:Title||test]]
OK

Filter = [QueryString:Category1||[In:Config:Kat1||test]]
not OK

Filter = [QueryString:Category1||[In:Config:Param||test]]
OK
May 13, 2016 at 5:43 PM
Input field entity type don't work if name end with number or don't end with number
Coordinator
May 15, 2016 at 7:16 AM
perfect, thanks for all that input. I guess we'll do a filter update within the next few months to cover all this...