Skip to content

Instantly share code, notes, and snippets.

/gist:06f5bfd57954bb12d26f9d98eb34ac18

Created May 3, 2017 07:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/06f5bfd57954bb12d26f9d98eb34ac18 to your computer and use it in GitHub Desktop.
Save anonymous/06f5bfd57954bb12d26f9d98eb34ac18 to your computer and use it in GitHub Desktop.
Download ZIP
Shopware article list
Raw
gistfile1.txt
columnConfig:
>>>
{
"success": true,
"data": [{
"entity": "Article",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_articles",
"alias": "Article_id",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Vote",
"field": "articleId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "articleID",
"table": "s_articles_vote",
"alias": "Vote_articleId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Attribute",
"field": "attr17",
"editable": true,
"type": "date",
"precision": 0,
"nullable": true,
"columnName": "attr17",
"table": "s_articles_attributes",
"alias": "Attribute_attr17",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr18",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "attr18",
"table": "s_articles_attributes",
"alias": "Attribute_attr18",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr19",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr19",
"table": "s_articles_attributes",
"alias": "Attribute_attr19",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr20",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr20",
"table": "s_articles_attributes",
"alias": "Attribute_attr20",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Tax",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_core_tax",
"alias": "Tax_id",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Tax",
"field": "tax",
"editable": false,
"type": "decimal",
"precision": 0,
"nullable": false,
"columnName": "tax",
"table": "s_core_tax",
"alias": "Tax_tax",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_articles_vote",
"alias": "Vote_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_articles_vote",
"alias": "Vote_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Attribute",
"field": "attr15",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr15",
"table": "s_articles_attributes",
"alias": "Attribute_attr15",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Vote",
"field": "headline",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "headline",
"table": "s_articles_vote",
"alias": "Vote_headline",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "comment",
"editable": true,
"type": "text",
"precision": 0,
"nullable": false,
"columnName": "comment",
"table": "s_articles_vote",
"alias": "Vote_comment",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "points",
"editable": true,
"type": "float",
"precision": 0,
"nullable": false,
"columnName": "points",
"table": "s_articles_vote",
"alias": "Vote_points",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "datum",
"editable": true,
"type": "datetime",
"precision": 0,
"nullable": false,
"columnName": "datum",
"table": "s_articles_vote",
"alias": "Vote_datum",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "active",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "active",
"table": "s_articles_vote",
"alias": "Vote_active",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "email",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "email",
"table": "s_articles_vote",
"alias": "Vote_email",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Vote",
"field": "answer",
"editable": true,
"type": "text",
"precision": 0,
"nullable": false,
"columnName": "answer",
"table": "s_articles_vote",
"alias": "Vote_answer",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Attribute",
"field": "attr16",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr16",
"table": "s_articles_attributes",
"alias": "Attribute_attr16",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr14",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr14",
"table": "s_articles_attributes",
"alias": "Attribute_attr14",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "ConfiguratorSet",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_article_configurator_sets",
"alias": "ConfiguratorSet_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Attribute",
"field": "attr4",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr4",
"table": "s_articles_attributes",
"alias": "Attribute_attr4",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Unit",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "description",
"table": "s_core_units",
"alias": "Unit_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Attribute",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_articles_attributes",
"alias": "Attribute_id",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "articleId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "articleID",
"table": "s_articles_attributes",
"alias": "Attribute_articleId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Attribute",
"field": "articleDetailId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "articledetailsID",
"table": "s_articles_attributes",
"alias": "Attribute_articleDetailId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Attribute",
"field": "attr1",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr1",
"table": "s_articles_attributes",
"alias": "Attribute_attr1",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr2",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr2",
"table": "s_articles_attributes",
"alias": "Attribute_attr2",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr3",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr3",
"table": "s_articles_attributes",
"alias": "Attribute_attr3",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr5",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr5",
"table": "s_articles_attributes",
"alias": "Attribute_attr5",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr13",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr13",
"table": "s_articles_attributes",
"alias": "Attribute_attr13",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr6",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr6",
"table": "s_articles_attributes",
"alias": "Attribute_attr6",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr7",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr7",
"table": "s_articles_attributes",
"alias": "Attribute_attr7",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr8",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr8",
"table": "s_articles_attributes",
"alias": "Attribute_attr8",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr9",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "attr9",
"table": "s_articles_attributes",
"alias": "Attribute_attr9",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr10",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "attr10",
"table": "s_articles_attributes",
"alias": "Attribute_attr10",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr11",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr11",
"table": "s_articles_attributes",
"alias": "Attribute_attr11",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Attribute",
"field": "attr12",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "attr12",
"table": "s_articles_attributes",
"alias": "Attribute_attr12",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Vote",
"field": "answer_date",
"editable": true,
"type": "datetime",
"precision": 0,
"nullable": false,
"columnName": "answer_date",
"table": "s_articles_vote",
"alias": "Vote_answer_date",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorSet",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_article_configurator_sets",
"alias": "ConfiguratorSet_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "mainDetailId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "main_detail_id",
"table": "s_articles",
"alias": "Article_mainDetailId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "main",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "main",
"table": "s_articles_img",
"alias": "Image_main",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertyOption",
"field": "optionId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "optionID",
"table": "s_filter_values",
"alias": "PropertyOption_optionId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertyOption",
"field": "mediaId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "media_id",
"table": "s_filter_values",
"alias": "PropertyOption_mediaId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_articles_img",
"alias": "Image_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "articleId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "articleID",
"table": "s_articles_img",
"alias": "Image_articleId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "articleDetailId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "article_detail_id",
"table": "s_articles_img",
"alias": "Image_articleDetailId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "description",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "description",
"table": "s_articles_img",
"alias": "Image_description",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "path",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "img",
"table": "s_articles_img",
"alias": "Image_path",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "position",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "position",
"table": "s_articles_img",
"alias": "Image_position",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertyOption",
"field": "value",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "value",
"table": "s_filter_values",
"alias": "PropertyOption_value",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "width",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "width",
"table": "s_articles_img",
"alias": "Image_width",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "height",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "height",
"table": "s_articles_img",
"alias": "Image_height",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "relations",
"editable": true,
"type": "text",
"precision": 0,
"nullable": false,
"columnName": "relations",
"table": "s_articles_img",
"alias": "Image_relations",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "extension",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "extension",
"table": "s_articles_img",
"alias": "Image_extension",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "parentId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "parent_id",
"table": "s_articles_img",
"alias": "Image_parentId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Image",
"field": "mediaId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "media_id",
"table": "s_articles_img",
"alias": "Image_mediaId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Price",
"field": "pseudoPrice",
"editable": true,
"type": "float",
"selectClause": "ROUND(s_articles_prices.pseudoprice*(100+s_core_tax.tax)\/100,2)",
"precision": 3,
"nullable": true,
"columnName": "pseudoprice",
"table": "s_articles_prices",
"alias": "Price_pseudoPrice",
"allowInGrid": true,
"show": false,
"position": -1
}, {
"entity": "PropertyOption",
"field": "position",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "position",
"table": "s_filter_values",
"alias": "PropertyOption_position",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertyOption",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_filter_values",
"alias": "PropertyOption_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorSet",
"field": "public",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "public",
"table": "s_article_configurator_sets",
"alias": "ConfiguratorSet_public",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorOption",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_article_configurator_options",
"alias": "ConfiguratorOption_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorSet",
"field": "type",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "type",
"table": "s_article_configurator_sets",
"alias": "ConfiguratorSet_type",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorGroup",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_article_configurator_groups",
"alias": "ConfiguratorGroup_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorGroup",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_article_configurator_groups",
"alias": "ConfiguratorGroup_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorGroup",
"field": "description",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "description",
"table": "s_article_configurator_groups",
"alias": "ConfiguratorGroup_description",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorGroup",
"field": "position",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "position",
"table": "s_article_configurator_groups",
"alias": "ConfiguratorGroup_position",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorOption",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_article_configurator_options",
"alias": "ConfiguratorOption_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorOption",
"field": "groupId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "group_id",
"table": "s_article_configurator_options",
"alias": "ConfiguratorOption_groupId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "ConfiguratorOption",
"field": "position",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "position",
"table": "s_article_configurator_options",
"alias": "ConfiguratorOption_position",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertyGroup",
"field": "filterable",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "filterable",
"table": "s_filter_options",
"alias": "PropertyGroup_filterable",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertySet",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_filter",
"alias": "PropertySet_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertySet",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_filter",
"alias": "PropertySet_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertySet",
"field": "position",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "position",
"table": "s_filter",
"alias": "PropertySet_position",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertySet",
"field": "comparable",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "comparable",
"table": "s_filter",
"alias": "PropertySet_comparable",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertySet",
"field": "sortMode",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "sortMode",
"table": "s_filter",
"alias": "PropertySet_sortMode",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertyGroup",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_filter_options",
"alias": "PropertyGroup_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "PropertyGroup",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_filter_options",
"alias": "PropertyGroup_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Unit",
"field": "unit",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "unit",
"table": "s_core_units",
"alias": "Unit_unit",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Unit",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_core_units",
"alias": "Unit_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "mediaId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "mediaID",
"table": "s_categories",
"alias": "Category_mediaId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "kind",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "kind",
"table": "s_articles_details",
"alias": "Detail_kind",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "availableFrom",
"editable": true,
"type": "datetime",
"precision": 0,
"nullable": true,
"columnName": "available_from",
"table": "s_articles",
"alias": "Article_availableFrom",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "availableTo",
"editable": true,
"type": "datetime",
"precision": 0,
"nullable": true,
"columnName": "available_to",
"table": "s_articles",
"alias": "Article_availableTo",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_articles_details",
"alias": "Detail_id",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "articleId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "articleID",
"table": "s_articles_details",
"alias": "Detail_articleId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "unitId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "unitID",
"table": "s_articles_details",
"alias": "Detail_unitId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "supplierNumber",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "suppliernumber",
"table": "s_articles_details",
"alias": "Detail_supplierNumber",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "additionalText",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "additionaltext",
"table": "s_articles_details",
"alias": "Detail_additionalText",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "template",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "template",
"table": "s_articles",
"alias": "Article_template",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "stockMin",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "stockmin",
"table": "s_articles_details",
"alias": "Detail_stockMin",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "weight",
"editable": true,
"type": "decimal",
"precision": 3,
"nullable": true,
"columnName": "weight",
"table": "s_articles_details",
"alias": "Detail_weight",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "width",
"editable": true,
"type": "decimal",
"precision": 3,
"nullable": true,
"columnName": "width",
"table": "s_articles_details",
"alias": "Detail_width",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "len",
"editable": true,
"type": "decimal",
"precision": 3,
"nullable": true,
"columnName": "length",
"table": "s_articles_details",
"alias": "Detail_len",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "height",
"editable": true,
"type": "decimal",
"precision": 3,
"nullable": true,
"columnName": "height",
"table": "s_articles_details",
"alias": "Detail_height",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "ean",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "ean",
"table": "s_articles_details",
"alias": "Detail_ean",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Category",
"field": "added",
"editable": true,
"type": "datetime",
"precision": 0,
"nullable": false,
"columnName": "added",
"table": "s_categories",
"alias": "Category_added",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "mode",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "mode",
"table": "s_articles",
"alias": "Article_mode",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "notification",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "notification",
"table": "s_articles",
"alias": "Article_notification",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "minPurchase",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "minpurchase",
"table": "s_articles_details",
"alias": "Detail_minPurchase",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "descriptionLong",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "description_long",
"table": "s_articles",
"alias": "Article_descriptionLong",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "supplierId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "supplierID",
"table": "s_articles",
"alias": "Article_supplierId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "taxId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "taxID",
"table": "s_articles",
"alias": "Article_taxId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "priceGroupId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "pricegroupID",
"table": "s_articles",
"alias": "Article_priceGroupId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "filterGroupId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "filtergroupID",
"table": "s_articles",
"alias": "Article_filterGroupId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "configuratorSetId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "configurator_set_id",
"table": "s_articles",
"alias": "Article_configuratorSetId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "description",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "description",
"table": "s_articles",
"alias": "Article_description",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "added",
"editable": true,
"type": "date",
"precision": 0,
"nullable": true,
"columnName": "datum",
"table": "s_articles",
"alias": "Article_added",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "crossBundleLook",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "crossbundlelook",
"table": "s_articles",
"alias": "Article_crossBundleLook",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Article",
"field": "pseudoSales",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "pseudosales",
"table": "s_articles",
"alias": "Article_pseudoSales",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "highlight",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "topseller",
"table": "s_articles",
"alias": "Article_highlight",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "keywords",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "keywords",
"table": "s_articles",
"alias": "Article_keywords",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "metaTitle",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "metaTitle",
"table": "s_articles",
"alias": "Article_metaTitle",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "changed",
"editable": true,
"type": "datetime",
"precision": 0,
"nullable": false,
"columnName": "changetime",
"table": "s_articles",
"alias": "Article_changed",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "priceGroupActive",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "pricegroupActive",
"table": "s_articles",
"alias": "Article_priceGroupActive",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Article",
"field": "lastStock",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "laststock",
"table": "s_articles",
"alias": "Article_lastStock",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "position",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "position",
"table": "s_articles_details",
"alias": "Detail_position",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "purchasePrice",
"editable": true,
"type": "decimal",
"precision": 0,
"nullable": false,
"columnName": "purchaseprice",
"table": "s_articles_details",
"alias": "Detail_purchasePrice",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "purchaseSteps",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "purchasesteps",
"table": "s_articles_details",
"alias": "Detail_purchaseSteps",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Category",
"field": "cmsText",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "cmstext",
"table": "s_categories",
"alias": "Category_cmsText",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "streamId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "stream_id",
"table": "s_categories",
"alias": "Category_streamId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "description",
"table": "s_categories",
"alias": "Category_name",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "position",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "position",
"table": "s_categories",
"alias": "Category_position",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "metaTitle",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "meta_title",
"table": "s_categories",
"alias": "Category_metaTitle",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "metaKeywords",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "metakeywords",
"table": "s_categories",
"alias": "Category_metaKeywords",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "metaDescription",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "metadescription",
"table": "s_categories",
"alias": "Category_metaDescription",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "cmsHeadline",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "cmsheadline",
"table": "s_categories",
"alias": "Category_cmsHeadline",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "active",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "active",
"table": "s_categories",
"alias": "Category_active",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_categories",
"alias": "Category_id",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "template",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "template",
"table": "s_categories",
"alias": "Category_template",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "productBoxLayout",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "product_box_layout",
"table": "s_categories",
"alias": "Category_productBoxLayout",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "blog",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "blog",
"table": "s_categories",
"alias": "Category_blog",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "path",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "path",
"table": "s_categories",
"alias": "Category_path",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "external",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "external",
"table": "s_categories",
"alias": "Category_external",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "hideFilter",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "hidefilter",
"table": "s_categories",
"alias": "Category_hideFilter",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "hideTop",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "hidetop",
"table": "s_categories",
"alias": "Category_hideTop",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Category",
"field": "changed",
"editable": true,
"type": "datetime",
"precision": 0,
"nullable": false,
"columnName": "changed",
"table": "s_categories",
"alias": "Category_changed",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "maxPurchase",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "maxpurchase",
"table": "s_articles_details",
"alias": "Detail_maxPurchase",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Category",
"field": "parentId",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "parent",
"table": "s_categories",
"alias": "Category_parentId",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Supplier",
"field": "changed",
"editable": false,
"type": "datetime",
"precision": 0,
"nullable": false,
"columnName": "changed",
"table": "s_articles_supplier",
"alias": "Supplier_changed",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Supplier",
"field": "description",
"editable": false,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "description",
"table": "s_articles_supplier",
"alias": "Supplier_description",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "purchaseUnit",
"editable": true,
"type": "decimal",
"precision": 0,
"nullable": true,
"columnName": "purchaseunit",
"table": "s_articles_details",
"alias": "Detail_purchaseUnit",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "referenceUnit",
"editable": true,
"type": "decimal",
"precision": 0,
"nullable": true,
"columnName": "referenceunit",
"table": "s_articles_details",
"alias": "Detail_referenceUnit",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "packUnit",
"editable": true,
"type": "text",
"precision": 0,
"nullable": true,
"columnName": "packunit",
"table": "s_articles_details",
"alias": "Detail_packUnit",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "shippingFree",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "shippingfree",
"table": "s_articles_details",
"alias": "Detail_shippingFree",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "releaseDate",
"editable": true,
"type": "date",
"precision": 0,
"nullable": true,
"columnName": "releasedate",
"table": "s_articles_details",
"alias": "Detail_releaseDate",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "shippingTime",
"editable": true,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "shippingtime",
"table": "s_articles_details",
"alias": "Detail_shippingTime",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Supplier",
"field": "metaTitle",
"editable": false,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "meta_title",
"table": "s_articles_supplier",
"alias": "Supplier_metaTitle",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Price",
"field": "price",
"editable": false,
"type": "float",
"precision": 3,
"nullable": false,
"columnName": "price",
"table": "s_articles_prices",
"alias": "Price_netPrice",
"allowInGrid": true,
"show": false,
"position": -1
}, {
"entity": "Supplier",
"field": "metaDescription",
"editable": false,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "meta_description",
"table": "s_articles_supplier",
"alias": "Supplier_metaDescription",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Supplier",
"field": "metaKeywords",
"editable": false,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "meta_keywords",
"table": "s_articles_supplier",
"alias": "Supplier_metaKeywords",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Supplier",
"field": "id",
"editable": false,
"type": "integer",
"precision": 0,
"nullable": false,
"columnName": "id",
"table": "s_articles_supplier",
"alias": "Supplier_id",
"show": false,
"position": -1,
"allowInGrid": true
}, {
"entity": "Supplier",
"field": "image",
"editable": false,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "img",
"table": "s_articles_supplier",
"alias": "Supplier_image",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Supplier",
"field": "link",
"editable": false,
"type": "string",
"precision": 0,
"nullable": true,
"columnName": "link",
"table": "s_articles_supplier",
"alias": "Supplier_link",
"show": false,
"position": -1,
"allowInGrid": false
}, {
"entity": "Detail",
"field": "number",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "ordernumber",
"table": "s_articles_details",
"alias": "Detail_number",
"show": true,
"position": 0,
"allowInGrid": true
}, {
"entity": "Article",
"field": "name",
"editable": true,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_articles",
"alias": "Article_name",
"show": true,
"position": 1,
"allowInGrid": true
}, {
"entity": "Supplier",
"field": "name",
"editable": false,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "name",
"table": "s_articles_supplier",
"alias": "Supplier_name",
"show": true,
"position": 2,
"allowInGrid": true
}, {
"entity": "Article",
"field": "active",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "active",
"table": "s_articles",
"alias": "Article_active",
"show": true,
"position": 3,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "active",
"editable": true,
"type": "boolean",
"precision": 0,
"nullable": false,
"columnName": "active",
"table": "s_articles_details",
"alias": "Detail_active",
"show": true,
"position": 4,
"allowInGrid": true
}, {
"entity": "Price",
"field": "price",
"editable": true,
"type": "float",
"selectClause": "ROUND(s_articles_prices.price*(100+s_core_tax.tax)\/100,2)",
"precision": 3,
"nullable": false,
"columnName": "price",
"table": "s_articles_prices",
"alias": "Price_price",
"allowInGrid": true,
"show": true,
"position": 5
}, {
"entity": "Tax",
"field": "name",
"editable": false,
"type": "string",
"precision": 0,
"nullable": false,
"columnName": "description",
"table": "s_core_tax",
"alias": "Tax_name",
"show": true,
"position": 6,
"allowInGrid": true
}, {
"entity": "Detail",
"field": "inStock",
"editable": true,
"type": "integer",
"precision": 0,
"nullable": true,
"columnName": "instock",
"table": "s_articles_details",
"alias": "Detail_inStock",
"show": true,
"position": 7,
"allowInGrid": true
}]
}
<<<
getGrammar:
>>>
{
"success": true,
"data": {
"nullaryOperators": {
"HASIMAGE": "",
"HASNOIMAGE": "",
"ISMAIN": "",
"HASPROPERTIES": "",
"HASCONFIGURATOR": "",
"HASBLOCKPRICE": ""
},
"unaryOperators": {
"ISTRUE": "",
"ISFALSE": "",
"ISNULL": ""
},
"binaryOperators": {
"IN": ["("],
">=": ["\/(^-{0,1}[0-9.]+$)\/", "\/\"(.*?)\"\/"],
"=": ["\/(^-{0,1}[0-9.]+$)\/", "\/\"(.*?)\"\/"],
"!=": ["\/(^-{0,1}[0-9.]+$)\/", "\/\"(.*?)\"\/"],
"!~": ["\/\"(.*?)\"\/"],
"~": ["\/\"(.*?)\"\/"],
">": ["\/(^-{0,1}[0-9.]+$)\/", "\/\"(.*?)\"\/"],
"<=": ["\/(^-{0,1}[0-9.]+$)\/", "\/\"(.*?)\"\/"],
"<": ["\/(^-{0,1}[0-9.]+$)\/", "\/\"(.*?)\"\/"]
},
"subOperators": ["(", ")"],
"boolOperators": ["AND", "OR"],
"values": ["\/\"(.*?)\"\/", "\/^-{0,1}[0-9.]+$\/"],
"attributes": {
"ARTICLE.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.MAINDETAILID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.SUPPLIERID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.TAXID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.PRICEGROUPID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.FILTERGROUPID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.CONFIGURATORSETID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ARTICLE.DESCRIPTION": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ARTICLE.DESCRIPTIONLONG": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ARTICLE.ADDED": [">", ">=", "<", "<=", "=", "ISNULL"],
"ARTICLE.ACTIVE": ["ISTRUE", "ISFALSE", "ISNULL"],
"ARTICLE.PSEUDOSALES": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.HIGHLIGHT": ["ISTRUE", "ISFALSE", "ISNULL"],
"ARTICLE.KEYWORDS": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ARTICLE.METATITLE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ARTICLE.CHANGED": [">", ">=", "<", "<=", "=", "ISNULL"],
"ARTICLE.PRICEGROUPACTIVE": ["ISTRUE", "ISFALSE", "ISNULL"],
"ARTICLE.LASTSTOCK": ["ISTRUE", "ISFALSE", "ISNULL"],
"ARTICLE.CROSSBUNDLELOOK": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.NOTIFICATION": ["ISTRUE", "ISFALSE", "ISNULL"],
"ARTICLE.TEMPLATE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ARTICLE.MODE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ARTICLE.AVAILABLEFROM": [">", ">=", "<", "<=", "=", "ISNULL"],
"ARTICLE.AVAILABLETO": [">", ">=", "<", "<=", "=", "ISNULL"],
"DETAIL.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.ARTICLEID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.UNITID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.NUMBER": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"DETAIL.SUPPLIERNUMBER": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"DETAIL.KIND": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.ADDITIONALTEXT": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"DETAIL.ACTIVE": ["ISTRUE", "ISFALSE", "ISNULL"],
"DETAIL.INSTOCK": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.STOCKMIN": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.WEIGHT": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.WIDTH": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.LEN": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.HEIGHT": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.EAN": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"DETAIL.PURCHASEPRICE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.POSITION": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.MINPURCHASE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.PURCHASESTEPS": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.MAXPURCHASE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.PURCHASEUNIT": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.REFERENCEUNIT": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"DETAIL.PACKUNIT": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"DETAIL.SHIPPINGFREE": ["ISTRUE", "ISFALSE", "ISNULL"],
"DETAIL.RELEASEDATE": [">", ">=", "<", "<=", "=", "ISNULL"],
"DETAIL.SHIPPINGTIME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.METATITLE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.METADESCRIPTION": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.METAKEYWORDS": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"SUPPLIER.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.IMAGE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.LINK": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.DESCRIPTION": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"SUPPLIER.CHANGED": [">", ">=", "<", "<=", "=", "ISNULL"],
"CATEGORY.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CATEGORY.PARENTID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CATEGORY.STREAMID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CATEGORY.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.POSITION": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CATEGORY.METATITLE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.METAKEYWORDS": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.METADESCRIPTION": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.CMSHEADLINE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.CMSTEXT": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.ACTIVE": ["ISTRUE", "ISFALSE", "ISNULL"],
"CATEGORY.TEMPLATE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.PRODUCTBOXLAYOUT": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.BLOG": ["ISTRUE", "ISFALSE", "ISNULL"],
"CATEGORY.PATH": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.EXTERNAL": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CATEGORY.HIDEFILTER": ["ISTRUE", "ISFALSE", "ISNULL"],
"CATEGORY.HIDETOP": ["ISTRUE", "ISFALSE", "ISNULL"],
"CATEGORY.CHANGED": [">", ">=", "<", "<=", "=", "ISNULL"],
"CATEGORY.ADDED": [">", ">=", "<", "<=", "=", "ISNULL"],
"CATEGORY.MEDIAID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"UNIT.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"UNIT.UNIT": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"UNIT.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ATTRIBUTE.ARTICLEID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ATTRIBUTE.ARTICLEDETAILID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"ATTRIBUTE.ATTR1": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR2": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR3": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR4": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR5": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR6": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR7": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR8": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR9": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR10": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR11": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR12": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR13": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR14": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR15": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR16": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR17": [">", ">=", "<", "<=", "=", "ISNULL"],
"ATTRIBUTE.ATTR18": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR19": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"ATTRIBUTE.ATTR20": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"TAX.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"TAX.TAX": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"TAX.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"VOTE.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"VOTE.ARTICLEID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"VOTE.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"VOTE.HEADLINE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"VOTE.COMMENT": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"VOTE.POINTS": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"VOTE.DATUM": [">", ">=", "<", "<=", "=", "ISNULL"],
"VOTE.ACTIVE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"VOTE.EMAIL": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"VOTE.ANSWER": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"VOTE.ANSWER_DATE": [">", ">=", "<", "<=", "=", "ISNULL"],
"CONFIGURATORSET.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CONFIGURATORSET.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CONFIGURATORSET.PUBLIC": ["ISTRUE", "ISFALSE", "ISNULL"],
"CONFIGURATORSET.TYPE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CONFIGURATORGROUP.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CONFIGURATORGROUP.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CONFIGURATORGROUP.DESCRIPTION": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CONFIGURATORGROUP.POSITION": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CONFIGURATOROPTION.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CONFIGURATOROPTION.GROUPID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"CONFIGURATOROPTION.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"CONFIGURATOROPTION.POSITION": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYSET.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYSET.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"PROPERTYSET.POSITION": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYSET.COMPARABLE": ["ISTRUE", "ISFALSE", "ISNULL"],
"PROPERTYSET.SORTMODE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYGROUP.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYGROUP.NAME": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"PROPERTYGROUP.FILTERABLE": ["ISTRUE", "ISFALSE", "ISNULL"],
"PROPERTYOPTION.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYOPTION.VALUE": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"PROPERTYOPTION.POSITION": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYOPTION.OPTIONID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PROPERTYOPTION.MEDIAID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PRICE.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PRICE.ARTICLEID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PRICE.ARTICLEDETAILSID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PRICE.CUSTOMERGROUPKEY": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"PRICE.FROM": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PRICE.TO": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"PRICE.PRICE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PRICE.PSEUDOPRICE": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"PRICE.PERCENT": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.ID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.ARTICLEID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.ARTICLEDETAILID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.DESCRIPTION": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"IMAGE.PATH": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"IMAGE.MAIN": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.POSITION": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.WIDTH": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.HEIGHT": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.RELATIONS": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"IMAGE.EXTENSION": ["=", "~", "!~", "IN", "!=", "ISNULL"],
"IMAGE.PARENTID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"],
"IMAGE.MEDIAID": [">", ">=", "<", "<=", "=", "!=", "ISNULL"]
}
}
}
<<<
list:
>>>
{
"totalCount": 0,
"data": [],
"success": true
}
<<<
getList:
>>>
{
"success": true,
"data": [{
"id": 7,
"active": true,
"name": "Deutsch",
"position": null,
"parentId": 1,
"childrenCount": 0,
"text": "Deutsch",
"cls": "folder",
"leaf": true,
"allowDrag": true
}, {
"id": 3,
"active": true,
"name": "English",
"position": 0,
"parentId": 1,
"childrenCount": 5,
"text": "English",
"cls": "folder",
"leaf": false,
"allowDrag": true
}],
"total": 2
}
<<<
getFilter:
>>>
{
"success": true,
"data": [{
"id": 1,
"name": "<b>Abverkauf<\/b><br><small>Nicht auf Lager<\/small>",
"filterString": " ARTICLE.LASTSTOCK ISTRUE and DETAIL.INSTOCK <= 0",
"description": "Abverkauf-Artikel ohne Lagerbestand",
"created": null,
"isFavorite": true,
"isSimple": false
}, {
"id": 2,
"name": "Hauptartikel",
"filterString": "ismain",
"description": "Alle Hauptartikel (einfache Artikel und Standardvarianten)",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 3,
"name": "Artikel mit Staffelpreis",
"filterString": "HASBLOCKPRICE",
"description": "",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 4,
"name": "Highlight",
"filterString": "ARTICLE.HIGHLIGHT ISTRUE ",
"description": "Zeigt alle Highlight-Artikel",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 5,
"name": "Konfigurator-Artikel",
"filterString": "HASCONFIGURATOR AND ISMAIN ",
"description": "Artikel mit Konfiguratoren",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 7,
"name": "Varianten",
"filterString": "HASCONFIGURATOR ",
"description": "Alle Varianten",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 8,
"name": "Ohne Kategorie",
"filterString": "CATEGORY.ID ISNULL and ISMAIN ",
"description": "Artikel ohne Kategoriezuordnung",
"created": null,
"isFavorite": true,
"isSimple": false
}, {
"id": 16,
"name": "Artikel ohne Bilder",
"filterString": "HASNOIMAGE ",
"description": "Artikel ohne Bilder",
"created": null,
"isFavorite": true,
"isSimple": false
}, {
"id": 17,
"name": "Komplexer Filter",
"filterString": "ismain and CATEGORY.ACTIVE ISTRUE and SUPPLIER.NAME IN ( \"Teapavilion\" , \"Feinbrennerei Sasse\" ) ",
"description": "",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 18,
"name": "Artikel mit H\u00e4ndlerpreisen",
"filterString": "PRICE.CUSTOMERGROUPKEY IN (\"B2B\" , \"H\")",
"description": "Alle Artikel, f\u00fcr die H\u00e4ndlerpreise gepflegt werden",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 20,
"name": "Rote Artikel",
"filterString": "CONFIGURATOROPTION.NAME = \"%Rot%\" or PROPERTYOPTION.VALUE = \"rot\" ",
"description": "Alle Artikel, mit \u00bbrot\u00ab als Konfiguratoroption oder Eigenschaft",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 21,
"name": "Regul\u00e4rer Ausdruck",
"filterString": "DETAIL.NUMBER !~ \"^sw[0-9]*\" ",
"description": "Findet alle Artikel, die keine Bestellnummer nach dem Schema swZAHL haben",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 22,
"name": "Artikel ohne Bewertung",
"filterString": " VOTE.ID ISNULL and ismain",
"description": "Zeigt alle Artikel ohne Bewertungen und Kommentar",
"created": null,
"isFavorite": false,
"isSimple": false
}, {
"id": 23,
"name": "Artikel mit nicht-freigeschalteten Bewertungen",
"filterString": "VOTE.ACTIVE = \"0\"",
"description": "Zeigt alle Artikel, die mindestens eine inaktive Bewertung haben",
"created": null,
"isFavorite": false,
"isSimple": true
}]
}
<<<
filter:
>>>
{
"success": true,
"data": [{
"Article_id": "2",
"Attribute_attr17": null,
"Attribute_attr18": null,
"Attribute_attr19": null,
"Attribute_attr20": null,
"Tax_id": "1",
"Attribute_attr15": null,
"Attribute_attr16": null,
"Attribute_attr14": null,
"Attribute_attr4": null,
"Attribute_id": "2",
"Attribute_attr1": "\nThis belt by Peter Paulson is made of real cow leather, colour-dyed by hand - suede on the outside, and smooth leather on the inside.\nThe two main colours blue and pink go together really well and can be worn to nearly all kinds of trousers.",
"Attribute_attr2": "",
"Attribute_attr3": "",
"Attribute_attr5": null,
"Attribute_attr13": null,
"Attribute_attr6": null,
"Attribute_attr7": null,
"Attribute_attr8": null,
"Attribute_attr9": null,
"Attribute_attr10": null,
"Attribute_attr11": null,
"Attribute_attr12": null,
"Price_pseudoPrice": "0.00",
"Detail_id": "2",
"Detail_supplierNumber": "",
"Detail_additionalText": "",
"Detail_stockMin": "1",
"Detail_weight": "0.500",
"Detail_width": null,
"Detail_len": null,
"Detail_height": null,
"Detail_ean": "",
"Article_notification": "1",
"Detail_minPurchase": "1",
"Article_added": "2017-03-06",
"Article_pseudoSales": "0",
"Article_highlight": "0",
"Article_keywords": "",
"Article_metaTitle": "",
"Article_changed": "2017-04-22 22:02:32",
"Article_priceGroupActive": "0",
"Article_lastStock": "1",
"Detail_position": "0",
"Detail_purchasePrice": "20",
"Detail_purchaseSteps": null,
"Detail_maxPurchase": "10",
"Detail_purchaseUnit": "1.0000",
"Detail_referenceUnit": null,
"Detail_packUnit": "Pcs",
"Detail_shippingFree": "0",
"Detail_releaseDate": null,
"Detail_shippingTime": "4",
"Price_netPrice": "49.9",
"Supplier_id": "1",
"Detail_number": "SW10002",
"Article_name": "Belt \"Porto\"",
"Supplier_name": "Peter Paulson",
"Article_active": "1",
"Detail_active": "1",
"Price_price": "49.90",
"Tax_name": "0%",
"Detail_inStock": "0",
"hasConfigurator": false,
"imageSrc": "DSC08005_140x140.jpg",
"hasCategories": true
}, {
"Article_id": "1",
"Attribute_attr17": null,
"Attribute_attr18": null,
"Attribute_attr19": null,
"Attribute_attr20": null,
"Tax_id": "1",
"Attribute_attr15": null,
"Attribute_attr16": null,
"Attribute_attr14": null,
"Attribute_attr4": null,
"Attribute_id": "1",
"Attribute_attr1": "",
"Attribute_attr2": "",
"Attribute_attr3": "",
"Attribute_attr5": null,
"Attribute_attr13": null,
"Attribute_attr6": null,
"Attribute_attr7": null,
"Attribute_attr8": null,
"Attribute_attr9": null,
"Attribute_attr10": null,
"Attribute_attr11": null,
"Attribute_attr12": null,
"Price_pseudoPrice": "0.00",
"Detail_id": "1",
"Detail_supplierNumber": "",
"Detail_additionalText": "",
"Detail_stockMin": "1",
"Detail_weight": "0.500",
"Detail_width": null,
"Detail_len": null,
"Detail_height": null,
"Detail_ean": "",
"Article_notification": "0",
"Detail_minPurchase": "1",
"Article_added": "2017-03-06",
"Article_pseudoSales": "0",
"Article_highlight": "0",
"Article_keywords": "",
"Article_metaTitle": "",
"Article_changed": "2017-03-13 20:10:29",
"Article_priceGroupActive": "0",
"Article_lastStock": "1",
"Detail_position": "0",
"Detail_purchasePrice": "20",
"Detail_purchaseSteps": null,
"Detail_maxPurchase": "10",
"Detail_purchaseUnit": "1.0000",
"Detail_referenceUnit": null,
"Detail_packUnit": "Pcs",
"Detail_shippingFree": "0",
"Detail_releaseDate": null,
"Detail_shippingTime": "4",
"Price_netPrice": "49.9",
"Supplier_id": "1",
"Detail_number": "SW10001",
"Article_name": "Belt \"Marbella\"",
"Supplier_name": "Peter Paulson",
"Article_active": "1",
"Detail_active": "1",
"Price_price": "49.90",
"Tax_name": "0%",
"Detail_inStock": "7",
"hasConfigurator": false,
"imageSrc": "DSC08005_140x140.jpg",
"hasCategories": true
}],
"total": 2
}
<<<
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment