Query filter of promoted links in sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1304385%22%20slang%3D%22en-US%22%3EQuery%20filter%20of%20promoted%20links%20in%20sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1304385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EQuestion%20Description%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EIf%20I%20have%2010%20locations%2C%20I%20have%2010%20Promoted%20links.%20Each%20promoted%20links%20contain%20all%20information%20about%20that%20particular%20location%20(i.e.%20Promoted%20link%20of%20Location%201%2C%20contains%20all%20information%20about%20location%201).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20locations%20contains%2020%20columns%20as%20Col1%2C%20Col2%2C%20...Col20%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssume%3A%3C%2FP%3E%3CUL%3E%3CLI%3EIn%20location%201%3A%20Col1%20has100%20options%2C%20Col2%20has%202000%20options%2C%20and%20so%20on%3C%2FLI%3E%3CLI%3EIn%20location%202%3A%20Col1%20has%2023%20options%2C%20Col2%20has%2077%20options%20and%20so%20on%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3EProblem%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20have%20a%20query%20for%20these%20prompted%20links.%20If%20%22Location%201%22%20is%20chosen%2C%20then%20only%20the%20options%20of%20Location%201%20must%20show%20shows%20up%20for%20the%20Columns.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1304385%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Question Description:

If I have 10 locations, I have 10 Promoted links. Each promoted links contain all information about that particular location (i.e. Promoted link of Location 1, contains all information about location 1). 

 

All locations contains 20 columns as Col1, Col2, ...Col20

 

Assume:

  • In location 1: Col1 has100 options, Col2 has 2000 options, and so on
  • In location 2: Col1 has 23 options, Col2 has 77 options and so on

Problem:

Now I want to have a query for these prompted links. If "Location 1" is chosen, then only the options of Location 1 must show shows up for the Columns. 

 

Any help is appreciated. 

0 Replies